118 reputation
5
bio website geostellar.com
location Turners Falls, MA
age 27
visits member for 3 years, 2 months
seen Jan 24 '13 at 22:49

I am the Lead Software Engineer for Geostellar, a WV-based clean tech company. We're aiming to make solar accessible to everyone, offering instant free solar appraisals for any home in America. Prior to Geostellar, I worked with a Virginia-based government contractor writing applications for special "clean energy task force" divisions of the US Department of Energy, the Environmental Protection Agency, and several other agencies. Clean/Green folks, connect with me on LinkedIn!


Nov
14
comment Finding the Geometry within which a Point falls
@RagiYaserBurhum it just needed a vacuum analyze.
Oct
9
awarded  Scholar
Oct
9
comment Finding the Geometry within which a Point falls
Resolved. Thanks
Oct
9
accepted Finding the Geometry within which a Point falls
Oct
5
comment Finding the Geometry within which a Point falls
We actually do have a spatial index on wkb_geometry. Any other thoughts?
Oct
5
awarded  Supporter
Oct
5
comment Finding the Geometry within which a Point falls
The query is still nearly 4 seconds long...what can I do to improve that?
Oct
5
awarded  Editor
Oct
5
revised Finding the Geometry within which a Point falls
added 229 characters in body
Oct
5
asked Finding the Geometry within which a Point falls
Nov
15
awarded  Autobiographer
May
5
comment Converting LinestringM to Polygon PostGIS
You were correct, but the implementation we were using here was unnecessarily long... Instead of the above code, we got away with just using POLYGON, eliminating the and ST_MakePolygon, ST_GeomFromText, LINESTRINGM
May
5
awarded  Student
May
5
asked Converting LinestringM to Polygon PostGIS