superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 32 and YR_EST = 1962
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5685 | 5685 | 5684 | {"type": "Polygon", "coordinates": [[[-121.86436, 37.32449], [-121.86277, 37.32544], [-121.86265, 37.32553], [-121.86248, 37.32557], [-121.86223, 37.32554], [-121.86213, 37.32557], [-121.86205, 37.32555], [-121.86197, 37.32556], [-121.86167, 37.32565], [-121.86133, 37.32587], [-121.86139, 37.32606], [-121.86102, 37.32624], [-121.861, 37.32635], [-121.86093, 37.32652], [-121.861, 37.32662], [-121.86058, 37.3271], [-121.8609, 37.32761], [-121.86112, 37.32772], [-121.85953, 37.32881], [-121.85297, 37.32221], [-121.85255, 37.32176], [-121.85209, 37.32147], [-121.85155, 37.32086], [-121.85073, 37.32013], [-121.8527, 37.31876], [-121.85442, 37.31764], [-121.85452, 37.31752], [-121.85459, 37.31753], [-121.85456, 37.31756], [-121.85453, 37.31781], [-121.85598, 37.31917], [-121.85403, 37.31875], [-121.85358, 37.31878], [-121.85293, 37.31909], [-121.85295, 37.3193], [-121.85337, 37.31946], [-121.85374, 37.31951], [-121.85506, 37.31936], [-121.85577, 37.31971], [-121.85625, 37.31956], [-121.85664, 37.31937], [-121.85688, 37.31921], [-121.85731, 37.31911], [-121.85852, 37.3184], [-121.86171, 37.32174], [-121.86436, 37.32449]]]} | Open Access 1 | Kelley Park | 20576 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 164.335 | Kelley Park | 1962 | |
7833 | 7833 | 7832 | {"type": "Polygon", "coordinates": [[[-121.85257, 37.34148], [-121.84776, 37.34453], [-121.84758, 37.34434], [-121.8473, 37.34393], [-121.84727, 37.34384], [-121.84727, 37.34377], [-121.84728, 37.34371], [-121.84732, 37.34362], [-121.84737, 37.34356], [-121.84804, 37.34292], [-121.8502, 37.34167], [-121.8504, 37.34158], [-121.85073, 37.34146], [-121.85108, 37.34137], [-121.85137, 37.34133], [-121.85163, 37.34134], [-121.85257, 37.34148]]]} | Open Access 1 | P.A.L. Sportscenter | 23287 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 13.751 | P.A.L. Sportscenter | 1962 | |
8875 | 8875 | 8874 | {"type": "Polygon", "coordinates": [[[-121.8548, 37.31737], [-121.85467, 37.31744], [-121.8546, 37.31739], [-121.85458, 37.31695], [-121.85444, 37.31663], [-121.85461, 37.31658], [-121.85474, 37.31677], [-121.8548, 37.31705], [-121.85478, 37.31731], [-121.8548, 37.31737]]]} | Open Access 1 | Rocksprings Playground | 24534 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.408 | Rocksprings Playground | 1962 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);