This morning, Matt Hampel tweeted to me asking if CartoDB can pull in data directly from the Socrata API. It can, but the dataset in question, DOB Permits, does not contain any geo data, so it would need an additional step before it would be “mappable”.
This prompted some more twitter discussion on the best way to publish this data. My assertion was that mapping was probably a top use case, and that the city ought to at least provide a point geometry with each row.
@sromalewski pointed out that this is additional work that the city shouldn’t have to do when publishing data, and that the dataset included Borough, Block, Lot, and BIN, which could be used with a little SQL to join to either PLUTO or building footprints.
So, what do you think? Should the city take the extra step of adding geometries to this data, or leave it be?
Next question, if they should add geometries, should they be points or polygons? Building Footprints or Parcels? Should they be in NY State Plane that the city uses internally, or in WGS84 (lat/lon) that is more recognizable to a wider audience?