3,081 reputation
618
bio website
location Ardmore, PA
age
visits member for 3 years, 9 months
seen Mar 22 at 2:04

Feb
21
awarded  Custodian
Feb
21
reviewed Approve suggested edit on How to best remove rgb values outside of aerial image?
Jul
22
awarded  Yearling
Mar
9
awarded  Enlightened
Mar
9
awarded  Nice Answer
Feb
9
comment Why does DC belong to Maryland in OpenStreetMap/Nominatim?
It's definitely incorrect to consider it a part of Maryland. As others point out, this probably isn't the best forum to address it. File a bug report with OpenStreetMap.
Dec
31
comment ST_Touches function in Spatialite
Was your version compiled with GEOS support?
Dec
6
comment How to remove shapefile from PostGIS
Since he didn't specify version and DropGeometryTable is still in 2.0, I figured this was the cleaned way.
Nov
25
comment Why all WFS and WPS are CGI based?
rashad: Are you sure you understand what CGI is? It's a way for a web-server to pass requests on to other applications. It can be slower in some cases but it has nothing to do with HTML5Canvas or SVG. PHP can be used as a CGI. There are CGI for C++ and Java. CGI has its uses when you want a web server in front of your application.
Nov
22
answered How to remove shapefile from PostGIS
Oct
17
answered 1990 US Census Block Boundary File?
Oct
10
comment Is Spatialite Really Slow?
Welcome to gis.stackexchange.com! The format for this site implies that answers posted should be answers to the original question. When responding to an answer or comment it is best to make it a comment.
Sep
1
answered What's the best way to implement routing through areas such as parking lots?
Aug
11
comment Acquiring ArcGIS-like speed in Postgis
It's a common idiom in PostGIS to add a bounding box intersection check to speed things up. Try adding 'AND a.geom && b.geom' to your WHERE clause and see how much of a difference it makes.
Aug
6
revised Some data Loss when Import PGDB Table from Excel
added 5 characters in body
Aug
6
answered Some data Loss when Import PGDB Table from Excel
Aug
5
comment Solutions for fast operations on large GIS datasets
I'll agree with others that the solution is probably solved by optimizing your query/indexes and that distributed computing might not be necessary. For point-in-polygon, why do you use st_intersects and not st_contains? Are your points individual geometries or are some stored as multipoint?
Jul
22
awarded  Yearling
Jul
18
comment How to record tracks finer than 10-30cm resolution (possibly using an iPhone)?
If you want to find out specific capabilities of an iPhone unrelated to GPS, the Apple Stack Exchange might be a better place for your question. c.f. apple.stackexchange.com/questions/10722/…
Jul
18
answered How to convert Landsat L1G raster to Geotiff?