1,492 reputation
221
bio website twitter.com/mapbaker
location Denver, CO
age
visits member for 1 year, 11 months
seen 13 hours ago

Spatial Information Manager at Denver Public Schools.
Community Technologist at OpeningOfDetroit.org


19h
comment How to build a relational database system with 4 tables in arcgis desktop?
What makes this hard, even if you're using MS SQL Server or PostGIS is that creating spatial views or tables that are constructed using SQL joins, relates, etc. are difficult - though not impossible - to consume using ArcMap. Building a table that joins geometry to features by an ID requires not only the geometry, but a unique ID column in order to be displayed. ArcMap cannot index/optimize the data, however, as that is what it uses all the extra tables in ArcSDE for (how quickly a MSSQL/PostGIS database gets clogged up so quickly...) But we're doing this at DPS and its going OK for some tasks
1d
revised OSM, Query for POIs in a building
added tag for overpass-api
1d
suggested suggested edit on OSM, Query for POIs in a building
2d
asked Street-view Image not rendering in CartoDB infoWindow
2d
comment mmqgis plugin not showing up in plugin dropdown menu
at QGIS 2.4 it should be its own menu option along the top menu bar...
2d
comment Buying location data of Restaurants with Cuisine information?
@Zeus ok good to know... thank you!
2d
comment Buying location data of Restaurants with Cuisine information?
@Zeus uh oh I'd better let my friend know - he was pulling data down and building leaflet visualizations from it... would that then be against their policy?
2d
answered Buying location data of Restaurants with Cuisine information?
2d
comment What to do in CartoDB so that null/zero values are not shown on the map?
Glad to help, @Paulina!
2d
comment How can I work with very large shapefiles (~1 GB) in QGIS?
@user35138 that's great! my pleasure and glad I could help!
Jul
28
comment from shape files to a database
is there any reason you converted to WKT from SHP before going to the RDMS? QGIS, for example can allow you to dump the SHP to SpatiaLite, for example, without going to WKT... maybe I'm not understanding the problem...
Jul
28
comment How can I work with very large shapefiles (~1 GB) in QGIS?
that's the first time I've seen a suggestion that someone move INTO a proprietary system as a solution versus using an open source solution to move OUT of one... interesting!
Jul
28
comment How can I work with very large shapefiles (~1 GB) in QGIS?
file geodatabase???
Jul
28
answered How can I work with very large shapefiles (~1 GB) in QGIS?
Jul
25
answered What to do in CartoDB so that null/zero values are not shown on the map?
Jul
17
comment How can I Georeference a column of multiple zip codes?
Can you give an example of the contents of the 'comma separated string' you're trying to geocode in CartoDB? If you want a shapefile of zip codes for the USA, go here, census.gov/cgi-bin/geo/shapefiles2012/main, choose 'select layer type' and choose 'zip code tabulation areas' - the file is ~500mb but you can select and export (save as vector layer) the features you're after using QGIS then upload that result to CartoDB
Jul
17
comment Problems Joining CSV to Shpfile arcgis 9.3
@MichaelMiles-Stimson you should add your solution as an answer...
Jul
17
comment Problems Joining CSV to Shpfile arcgis 9.3
good stuff @Walter.K.Jenkins!
Jul
17
comment How to rename PostgreSQL/PostGIS columns while importing Shapefiles?
@RyanDalton is -f for the filename rather than a column name in the destination file?
Jul
17
comment Problems Joining CSV to Shpfile arcgis 9.3
@MichaelMiles-Stimson DUDE where's my ArcGIS license? Glad you found the real problem. I used QGIS to look at the data.