4,243 reputation
720
bio website boringnerdystuff.wordpress.co…
location Indiana, USA
age
visits member for 1 year, 11 months
seen Sep 26 at 15:51

Jan
3
comment ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
That fixed it and it saves some space. Thanks!
Jan
3
accepted ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
Jan
3
revised ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
deleted 7 characters in body
Jan
3
asked ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
Jan
3
revised Install PostGIS and TIGER Data in Ubuntu 12.04
Added section on setting up geocoder lookup tables, etc.
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
Double sorry! I forgot about that too! First thing to check will be your database's search path, make sure the tiger schema is in there. 2nd thing to check is in the tiger schema there are tables, tiger.loader_platform and tiger.loader_variables that tell your scripts your password and other information. Use PGAdmin to edit those. Finally, before running your loader script run the loader_generate_nation function to set up all the tables that the geocoder needs. I'll edit my answer to fill in these blanks.
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
Sorry! I forgot most people don't use their normal user accounts to run psql. You'll need to save the script somewhere that your postgres user has write permission. Easiest is to use \o /tmp/loader_script.sql which will save the file to /tmp. Then to run the file it will be sh ./tmp/loader_script.sql.
Jan
3
answered Install PostGIS and TIGER Data in Ubuntu 12.04
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
What version of PostGIS are you running? Is it the version packaged with 12.04 or have you upgraded? If you can you want to run the latest PostGIS, 2.1.1. The TIGER Geocoder that comes with that version is much better than the version that works with PostGIS 1.5.
Jan
2
revised Some remote sensing tutorials
Added tags
Jan
2
reviewed Approve suggested edit on Inaccurate result while clipping on gis data
Jan
2
comment Calculate distance of points along a route QGIS
Is the data stored in a PostGIS database?
Dec
31
answered Exporting all attributes from a GPX file
Dec
31
reviewed Approve suggested edit on Is there a way to keep toll_booth nodes in osm2po's output?
Dec
30
reviewed Approve suggested edit on Network Analyst in Arcgis to generate the network for further analysis what should the attribute table must contain?
Dec
26
reviewed Approve suggested edit on Connecting a map to live data from Yahoo Finance
Dec
26
answered arcgis 10.1 account manager, authorizeSoftware script
Dec
26
revised arcgis 10.1 account manager, authorizeSoftware script
edited tags
Dec
26
reviewed Approve suggested edit on What ratio scales do Google Maps zoom levels correspond to?
Dec
25
reviewed Approve suggested edit on What free programs should every GIS user have installed?