I'm a total neophyte when it comes to writing SQL queries, so please bear with me. I'm interested in pulling down real estate transaction data for 19128 and using those data in ArcMap. I'm able to successfully pull down the data for 19128 into excel, but now I would like to map these data using longitude and latitude (x, y) in ArcMap, so the WKB spatial coding is not useful to me. I am running into an issue when I try to amend the query to include the geometry conversion from WKB to x, y (ST_Y, ST_X).
Here is my attempt at the query based on the guidance on the API Explorer documentation for RTT_SUMMARY:
https://phl.carto.com/api/v2/sql?q=SELECT * FROM RTT_SUMMARY WHERE zip_code LIKE '19128%', ST_Y(the_geom) AS lat, ST_X(the_geom) AS lng
Any help in pointing out where I'm screwing this up would be much appreciated!
Hi,
I'm a total neophyte when it comes to writing SQL queries, so please bear with me. I'm interested in pulling down real estate transaction data for 19128 and using those data in ArcMap. I'm able to successfully pull down the data for 19128 into excel, but now I would like to map these data using longitude and latitude (x, y) in ArcMap, so the WKB spatial coding is not useful to me. I am running into an issue when I try to amend the query to include the geometry conversion from WKB to x, y (ST_Y, ST_X).
Here is my attempt at the query based on the guidance on the API Explorer documentation for RTT_SUMMARY: https://phl.carto.com/api/v2/sql?q=SELECT * FROM RTT_SUMMARY WHERE zip_code LIKE '19128%', ST_Y(the_geom) AS lat, ST_X(the_geom) AS lng
Any help in pointing out where I'm screwing this up would be much appreciated!
Thank you, S