3,739 reputation
734
bio website twitter.com/mapbaker
location Denver, CO
age
visits member for 2 years, 7 months
seen 14 hours ago

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


16h
comment How to turn a shapefile into a table?
@drizo right on!!! Good luck!!!
16h
comment How to turn a shapefile into a table?
@drizo gotcha - updating answer shortly...
22h
comment Why don't shapefiles online contain the coastline (country borders)?
@Jack.Usa I'd think that would work ok! They don't seem to be broken out by Country. Have you also looked at Natural Earth data? naturalearthdata.com/downloads/50m-physical-vectors
Apr
8
comment Geocoding using Excel spreadsheet
Does that 'geocoding' plugin support geocoding from CSV, or would you suggest the MMQGIS plugin?
Apr
3
comment Labeling points with field value except those with a value of 0?
love your profile pic
Apr
2
comment 3D interpolation of pollutants across water depth
@alybaba726 you should try the program Surfer for 3D interpolation... goldensoftware.com/products/surfer
Apr
2
comment File GeoDatabase Table is too large to export?
@tonic do you have access to the Data Interoperability Extension through your ESRI licence?
Mar
26
comment How to Geocode a Google SpreadSheet?
Check the first link in my answer below... it will do exactly that...
Mar
26
comment How to Geocode a Google SpreadSheet?
what do you mean 'in-situ'?
Mar
25
comment How to Geocode a Google SpreadSheet?
did any of the solutions below work for you?
Mar
24
comment Finding model created using ArcGIS ModelBuilder?
do an operating system search on *.tbx - what OS are you using?
Mar
24
comment Querying on Household Income ranges in a dataset
Oh I see what you're doing... you have text values describing ranges... so you can't use a numeric operator on a) a string and b) a string of ranges. You'll have to be very specific in your string operators... (sorry, please disregard my previous answer)
Mar
24
comment Count intersections of lines with polygon
Could you, as you suggested, intersect the buffers with the streets, then use the Vector > Geometry Tools > Extract Nodes tool to convert your lines to points where they were split by the intersect tool - then use the buffers to select those nodes, and count them up?
Mar
24
comment QGIS table join with multiple fields
In the layer properties, go to the Joins section, then click the green cross to add a join - there is a spot in there to 'choose which fields to join' - does that do the trick? Otherwise, Spatialite is a great gateway to PostGIS and the joys of a relational database...
Mar
24
comment Euclidean Distance with Weighted Values
If you have 5 classes, could you create 5 euclidean distance rasters on each of the 5 classes, then divide each one by the 'weight' you're describing for each class, then merge them all back together?
Mar
24
comment Adding a GeoTiff created in QGIS to Map Box
Is this what Turf is for? mapbox.com/blog/heatmaps-and-grids-with-turf (just in case you want to skip creating the raster...)
Mar
24
comment Count all records X distance from a given point using SQL in CartoDB
4326 is the SRID (coordinate system) of the point created with ST_GeomFromText
Mar
24
comment Count all records X distance from a given point using SQL in CartoDB
I'm trying to get this to work on my table, but can't... maybe someone will chime in! SELECT * FROM tableName where ST_DWithin(tableName.the_geom_webmercator, ST_GeomFromText('POINT(39.704017 -104.959488)', 4326), 5000)
Mar
24
comment Count all records X distance from a given point using SQL in CartoDB
inner join means the query will only return the records that match the query (rather than returning ALL records with NULL data for the ones that are outside the distance). The query you've got there returns the POI name, the road name it is closest to, and within the ST_DWithin function specifies the distance to look for features from the road - 1609 (metres or feet I don't know...)
Mar
24
comment Count all records X distance from a given point using SQL in CartoDB
Try the ST_DWithin function, and here's a post about it's use: postgis.net/2013/08/26/tip_ST_DWithin