The user never leaves AutoCAD. A custom .NET or Python plugin (using pyautocad + psycopg2 ) sends the current selection set to PostGIS and returns results as temporary, colored "ghost geometry." 4. Real-World Case Study: Subdivision Drainage Design Challenge: An engineering firm had 200 AutoCAD drawings of a proposed subdivision. They needed to ensure no building fell inside the 100-year floodplain, but the floodplain data was a 2GB PostGIS raster ( ST_AsGDALRaster ).
Store a transformation table in PostGIS: