Mike,
My spatial_ref_sys does not have an entry for SRID 8307 either, and
I wonder what query exactly you tried, because I'm not sure how that
SRID would appear. I thought your original data were in 4326, and
geography defaults to 4326 if an SRID is not specified (and I think
prior to PostGIS 2.1, not SRID other 4326 was possible for geography
type).
Since most (recent) versions of PostGIS will be populated
spatial_ref_sys automatically during installation, the empty
spatial_ref_sys is odd. What is result of SELECT version() and
SELECT postgis_full_version()?
Your statements to ALTER TABLE, UPDATE, and CREATE INDEX all look
correct. However, I would have your DBAs confirm that your PostGIS
installation is set up correctly before anything else.
As an aside, you would probably get more responses from the PostGIS
Users mailing list (postgis-users@lists.osgeo.org) or
gis.stackexchange.com.
Best,
--Lee
On 04/05/2016 05:56 PM, Michael Moore
wrote:
--
Lee Hachadoorian
Assistant Professor of Instruction, Geography & Urban Studies
Assistant Director, Professional Science Master's in GIS
Temple University
http://geospatial.commons.gc.cuny.edu
http://freecity.commons.gc.cuny.edu