166 reputation
4
bio website
location
age
visits member for 2 years, 11 months
seen Feb 18 '12 at 21:21

Dec
7
awarded  Teacher
Dec
7
answered Split line using line/point in PostGIS 1.5
Dec
7
awarded  Scholar
Dec
7
accepted How to convert factfinder2.census.gov map data to KML?
Dec
7
answered How to convert factfinder2.census.gov map data to KML?
Dec
7
comment How to convert factfinder2.census.gov map data to KML?
EPSG:3857 gets it. And ... I probably should have guessed this from the gdal ticket, which also mentioned 3857. Thanks for the pointers.
Dec
7
comment How to convert factfinder2.census.gov map data to KML?
That told me that the gz_2010 data was in EPSG:4269, which worked, but the closest it got to the problematic data was EPSG:32663, which still put it north of Redding (when it should cover San Francisco). I'm going to try searching the whole PostGIS spatial_ref_sys table to see if I can find something that matches.
Dec
6
awarded  Editor
Dec
6
revised How to convert factfinder2.census.gov map data to KML?
Explained workaround.
Dec
6
comment How to convert factfinder2.census.gov map data to KML?
GeoServer's loading interface is remarkably complicated. When I load the problematic shapefile as a "store" into GeoServer (2.1.2), and then try to add a "layer" for it, it doesn't pick up either a native SRS or a declared SRS, and won't finish the import without them. Even when I create a store and layer from one of the working shapefiles (www2.census.gov/geo/tiger/GENZ2010/gz_2010_06_140_00_500k.zip), it wants me to guess a "Declared SRS", and the find button won't let me actually search (it just reloads the page). So ... can you be more precise?
Dec
4
comment How to convert factfinder2.census.gov map data to KML?
It looks like shpescape is actually using OGR under the covers (code.google.com/p/shpescape/source/browse/shapeft/views.py#26) so it's not surprising that it's no more powerful than the default options to the command-line tool. Still, it's more convenient than converting before the upload. Thanks for the pointer, for other files.
Dec
4
comment How to convert factfinder2.census.gov map data to KML?
Unfortunately, shpescape seems as confused as ogr2ogr when trying to upload the census data. The upload button just redirects straight back to the home page. It does fine at the data from census.gov/geo/www/cob/tr2000.html, but ogr2ogr could also handle that.
Dec
4
awarded  Student
Dec
4
asked How to convert factfinder2.census.gov map data to KML?