search

CityOfPhiladelphia / property2

Find information on real estate property in Philadelphia.
https://property.phila.gov
ISC License
6 stars 7 forks source link

Sale dates are off by one day #204

Open bertday opened 6 years ago

bertday commented 6 years ago

Compare sale date in the app:

http://property.phila.gov/?p=883309050

to sale date in Carto:

https://phl.carto.com/api/v2/sql?q=select+*+from+opa_properties_public+where+parcel_number+%3D+%27883309050%27

Seems to be a time zone issue with Moment.js.

bertday commented 6 years ago

Actually, Moment seems to be working fine. It's seeing a UTM date (e.g. 1993-09-17T00:00:00Z) and shifting it back to Eastern time. So, technically, the issue is that the time zone is off in the source data (Carto/DataBridge).