63 reputation
5
bio website
location
age
visits member for 1 year, 11 months
seen Feb 18 at 2:20

Nov
7
awarded  Popular Question
Oct
12
awarded  Popular Question
Aug
25
awarded  Editor
Aug
25
revised Three table postgres sql join query
added 1155 characters in body
Aug
25
awarded  Scholar
Aug
25
accepted Three table postgres sql join query
Aug
22
asked Three table postgres sql join query
Jul
10
comment Building SQL statement in javascript and casting variables as strings
I'm also having the problem that when my incoming shedId is this: PU2_3900_3750 the browser returns this in the error: pu2_3900_3750. (It doesn't see the capital letters, hence the comparison fails). Maybe this is related to my question above, or at least maybe an answer will solve both problems.
Jul
10
asked Building SQL statement in javascript and casting variables as strings
Jun
5
answered Can't read returned geojson
Jun
5
comment Can't read returned geojson
I think I've made some progess: I was able to parse the returned geojson only after I changed my select statement from: var sql = "select st_asgeojson(the_geom), id, area_sqmi "; to var sql = "select st_asgeojson(ST_Force_2D(the_geom)), id, area_sqmi ";
Jun
5
comment Can't read returned geojson
I've been using the firebug console for a while, but console shows the e.responseText similar to the geojson show above. The console log of features says it's null. I assume the failure to read the responseText is due to the z parameter present?
Jun
4
comment Can't read returned geojson
Unfortunately, there are so many tutorials on the web on how to accomplish complex tasks for beginners like me (on POSTGIS, javascript, etc), but ALL of them show you these tasks, then tell you "oh, but of course there are inherent SQL injection risks here", but then don't show you how to accomplish those same tasks to avoid SQL injection. No wonder it's so hard for beginners to learn anything secure - the examples we learn from aren't secure. If you can recommend a good source for learning secure javascript for beginners, please advise. Thank you.
Jun
4
revised Can't read returned geojson
edited tags
Jun
4
comment Can't read returned geojson
I'm assuming my problem is likely in the fact that my PostGIS geometry is putting out a z coordinate and my code can't handle that. I'll have to research how to remove the z coordinate from my geojson returned from PostGIS. Anyone know how to remove the z coordinate from a POSTGIS geometry?
Jun
1
asked Can't read returned geojson
Aug
14
asked What are valid values for “data defined” labeling settings?
May
11
awarded  Student
May
10
asked Beginner needs suggestions on map clicks and geojson