socrata / discuss

Discuss all the things!
https://dev.socrata.com
Apache License 2.0
10 stars 3 forks source link

JOINing filtered views??? [data.cityofnewyork.us/bnx9-e6tj] Question about "ACRIS - Real Property Master" #182

Open fedex1 opened 7 months ago

fedex1 commented 7 months ago

Is there a way to join this dataset right on the socrata server side?

The "ACRIS - Real Property Master" is not really very useful by itself.

Would it not make sense to JOIN the LEGALS (properties) and PARTIES etc and make one flat table.

OR let us create a TABLES that we can JOIN.

I asked a similar question 8 years ago and it appears that we still cannot join filtered views.

What is a filtered view and WHY would the source of the dataset be able to produce it and make the table basically unusable?

API Docs: https://dev.socrata.com/foundry/data.cityofnewyork.us/bnx9-e6tj