Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Where can I get a file that would allow me to bulk upload all of the ESRI projections into the spatial_ref_sys table of postgis. I know that you can get insert statements on; however one must look these up one by one --and I would rather just load them all at once.

share|improve this question

A pretty dusty old answer: Back in version 0.8.2 (from 2004), spatial_ref_sys.sql was a colourful table with 563 definitions from ESRI, 1221 from EPSG, and one from BC (it was initially developed in Victoria, British Columbia.) The table was regenerated for later releases with only auth_name = 'EPSG'. The data can be merged with an existing table by first loading it into another table with identical schemata (e.g., spatial_ref_sys2), then:

INSERT INTO spatial_ref_sys(srid, auth_name, auth_srid, srtext, proj4text)
SELECT srid, auth_name, auth_srid, srtext, proj4text
FROM spatial_ref_sys2
WHERE srid not in (select srid from spatial_ref_sys);

which adds 473 'ESRI' definitions (not 563, as some have the same SRID codes as EPSG).

On a related note, I recall seeing an ESRI-specific spatial_ref_sys extra data with zigGIS years ago.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.