Philly Property Assessment Data Inaccessible

[Naili Ding]

Hello Everyone, 

I recently encountered some trouble downloading the property assessments data, with the url: https://phl.carto.com/api/v2/sql?q=SELECT+*,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+opa_properties_public&filename=opa_properties_public&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator

After sending this query based API, the response was never sent back. I understand that limit the data size would be helpful but would really appreciate it if someone knows how to export the full dataset. Much appreciated!

Best,

Naili

[Joanna Winchester]

I am also having this issue! Not able to download the latest dataset of property assessments data...

[Robert Cheetham]

Naili and Joanna,

I'm sorry you are having trouble. I think this you are running into an issue with the CARTO service that the City uses for hosting some of its data. I've reached out to them. It's not limited to the crime incidents and affects all of the large data sets, including assessments, crime, 311, RTT transfers, etc.

One potential workaround is to use elements of the SQL where clause to limit the amount of data you retrieve on each request. There are some examples in in threads on this mailing list at:

 * https://groups.google.com/forum/#!topic/opendataphilly/3GVsMJfOi3Q
 * https://groups.google.com/forum/#!topic/opendataphilly/7vrSuWmmUwg
 
Regards,

Robert

------------------

Robert Cheetham

Azavea 

--
You received this message because you are subscribed to the Google Groups "Open Data Philly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to opendataphill...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/opendataphilly/f5eed2c5-c784-47e4-aff1-30baa8c9ec2c%40googlegroups.com.

[Nicholas Manganaro]

Good afternoon.
I have been having a similar problem getting shp files for RTT after August 2022, even using the API. 

Is that information going to be made available? I even tried importing the gdb file into QGis so I could export it as a shp file, but ran into a data type problem for certain fields somewhere around record #450,000 and couldn't identify a way to fix them. 

Is anyone having better luck than I am?

-Nick