4,020 reputation
836
bio website twitter.com/mapbaker
location Denver, CO
age
visits member for 2 years, 10 months
seen 10 mins ago

Spatial Information Manager / Sr. GIS Analyst at Denver Public Schools


Jun
18
comment Convert manual colored maps to vector
it's all pixels, right? Do you have a little snippet you can post of what the scanned image looks like?
Jun
18
comment Convert manual colored maps to vector
this is almost like land cover classification - at least some raster re-classification can be done once you've scanned the map - how many colours are you dealing with? Once reclassified to 'just' those colours, converting to vector based should be easy...
Jun
17
comment How do you embed iFrame content into a CartoDB infoWindow?
thanks for the updated info!!!
Jun
16
comment How do you generate WKT from a graphic drawn on a map?
I just tried this and it works great - it will do us well when we're using QGIS/PostGIS... thanks again!
Jun
15
comment How to speed up SQL spatial query (spatial index error)
@Erica I wouldn't give him too much guff... people post to GeoNet and GIS.SE all the time and when I challenge that it's always met as 'ok'...
Jun
15
comment Accuracy of coordinates from 1960's
@mc1972 are the LAT/LON values in decimal degrees, ie. they LOOK like normal LAT/LON values in WGS84 (ie. 37.285543, -100.340014) ? Or do they look like something different?
Jun
15
comment Mosaicking many tif files in ArcMap for ENVI
I'm not sure if ENVI can use a mosaic dataset (MD), but if you used the MD as a 'middle man', ie. loading all your rasters into an MD then exporting that into a ENVI-friendly format, that could take some of the work out...
Jun
15
comment Accuracy of coordinates from 1960's
would those coordinates have been based on NAD27? If so, could they be plotted in say QGIS using EPSG:4267 then re-projected to NAD83?
Jun
11
comment Strange coordinate system
ewwwww Ontario MTM... that's a toughie!!!
Jun
11
comment How to change the “application_name” of a PostGIS-connection in QGIS?
@Name is this a PostGIS issue or a PostgreSQL issue? Just asking because dba.stackexchange might be a place to ask this...
Jun
10
comment Need a vector format that is editable in QGIS and supports >10 character column names
SQLite? (87654321...)
Jun
9
comment Adding point layer in QGIS from SQL Server failing
is there an OBJECTID column in the table?
Jun
4
comment QGIS and Spatialite: Is it usable?
can you give an example of a CREATE statement you're using, and a GUI that doesn't accept Spatialite layers? Thanks!
Jun
4
comment How to update the OSM data in a PGRouting Database built with osm2pgrouting?
@alpha-beta-soup would the 'clean' option work? I'm going to pull the trigger on that soon just to see if it works - according to pgrouting.org/docs/tools/osm2pgrouting.html, clean will " drop peviously created tables"
Jun
3
comment Is it possible to connect a libreoffice database to qgis?
@AndresAristizabal I did a little talk on Geodesign at FOSS4G last year that discusses integrating PostgreSQL/PostGIS + QGIS + LibreOffice vimeo.com/106233274 To me it's such an incredible and powerful open source stack ...
Jun
3
comment Is it possible to connect a libreoffice database to qgis?
Andres - my advice would be to use PostgreSQL instead of LibreOffice Base. My experience with both tools is that PostgreSQL can handle the data side of things, and since you can 'add PostGIS layers' to QGIS, you can also check the box to 'Also list tables with no geometry' and voila - you have your non-spatial PostgreSQL tables accessible too!!! However, you may have a reason for using LibreOffice Base, which I'd be interested to hear! (also: PostgreSQL has drivers for LibreOffice, meaning you can connect your PostgreSQL AND PostGIS tables to LibreOffice!!!
Jun
2
comment Walkshed Analysis
There's no 'out of the box' tools for doing walkshed analysis - first: how would you define a walkshed?
Jun
1
comment Why are my block neighborhoods not square?
Sounds like your rasters were created in a different coordinate system than what you're using to display them - can you verify this?
May
29
comment GIS Wireframe into SketchUp
Try this thread and my updated answer: gis.stackexchange.com/questions/66537/…
May
29
comment How to use a PostGIS sequence in QGIS editing session?
@NathanW no - I get an error about violating the 'non null' policy of the column...