3,933 reputation
734
bio website twitter.com/mapbaker
location Denver, CO
age
visits member for 2 years, 8 months
seen 31 mins ago

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


1d
comment How to count points once with overlappying polygons?
I had to get this into PostGIS to get a better handle on the problem, but your solution worked best - thank you and very sorry for the delay, but the problem just re-surfaced and I've finally got it working!!!
2d
comment How do you set the extent of a CartoDB 'embed' map?
Ok I see that's in there - would be nice to have it exposed in the embed window as this isn't really intuitive (embedding being the most basic form of using a cartodb map...) Thanks!!!
May
21
comment Directly querying a raster
A arcgis mosaic dataset can store images OUTSIDE the dataset itself - ie. on the other server - then it can be accessed by arcgis tools locally as per the answers below...
May
21
comment How to use STUnion with GroupBy
that's a bummer!
May
20
comment Directly querying a raster
so you're not using SQL server really you're using ArcSDE to store the raster?
May
20
comment Directly querying a raster
The guys down in BI did this for me but it was the first time I've heard of rasters in SQL server - they are stored as BLOB's I believe, but not georeferenced and thus not 'data'... so... this might not be an option in SQL Server.
May
20
comment Directly querying a raster
We have stored raster 'images' in SQL server but not raster 'data'. We can query the images as records in a table, but we can't do pixel-level overlays, queries, etc. I can find out how it was done if you'd like...
May
18
comment Researching into the nuts and bolts of displaying ESRI Grids in QGIS
You're talking about an ArcGIS data format - not an 'open' format - so the best way would be to export the GRIDs as geoTIFF's or another georeferenced raster layer... I think...?
May
15
comment Creating spatial database with many categories that have same set of values?
@RyanM what locational information is in the CSV, that is, is the data by X,Y for crop locations, or are they each given a County name?
May
14
comment Creating spatial database with many categories that have same set of values?
how many input datasets are you going to be working with? And do you have any idea of the types of analysis you'll be doing?
May
6
comment Advanced Digitizing Tools Crashing in QGIS 2.8.1 x64 on Ubuntu 14.04
nice - did you submit to the QGIS bug trackers?
May
6
comment Printing (or exporting) Imagery from a Image Service using pre-defined map layout templates within an JavaScript based ArcGIS web app
Check out the so-called 'clip, zip, and ship' examples: resources.arcgis.com/en/help/main/10.1/index.html#//…
May
6
comment If Geographic Coordinates are unprojected coordinates, how can GIS softwares display such unprojected data on a plane?
They're projected to X/Y on the earths surface - as a globe - They're just not projected to a 2D plane... the software knows how to plot LAT/LON onto a projected coordinate system... but if your question is how is THAT done... well... I'll defer to the programmers...
May
5
comment Modifying DEM elevation data in QGIS using a polygon
You might find a solution in one of the workflows submitted on this thread: gis.stackexchange.com/questions/130300/…
May
5
comment Optimizing Geometry.STIntersect Query
@RichardMonteiro sorry I forgot the 'with' before the spatial index in my answer using your example ... I have updated.
May
4
comment Optimizing Geometry.STIntersect Query
I updated my answer to show how you might use your spatial index in the query in your original post...
May
4
comment Optimizing Geometry.STIntersect Query
1a) 'with' is used in this case in the FROM statement and 1b) I don't know if it will work if you use 2 'with' statements... 2) I've only tried this with a spatial index
May
4
comment Optimizing Geometry.STIntersect Query
We've been using SQL Server spatial data and functions for our analysis for almost 2 years and we're not turning back any time soon!!!
May
4
comment Optimizing Geometry.STIntersect Query
fun, isn't it!?
May
4
comment Creating geometry from lat/lon in table using PostGIS?
do you mean create lines from these points? Because points are geometry just as lines and polygons are... So if you're looking at creating lines from these points, check this recent blog post from Paul Ramsey: blog.cleverelephant.ca/2015/03/making-lines-from-points.html