superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 32 and PARK_URL = "http://www.sanjoseca.gov/Facilities/Facility/Details/Tully-Community-Ballfields-97"
This data as json, copyable, CSV (advanced)
PARK_URL 1 ✖
- http://www.sanjoseca.gov/Facilities/Facility/Details/Tully-Community-Ballfields-97 · 1 ✖
MNG_AG_TYP 1
MNG_AGENCY 1
- San Jose, City of · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11528 | 11528 | 11527 | {"type": "Polygon", "coordinates": [[[-121.84501, 37.30972], [-121.84413, 37.31027], [-121.84415, 37.31039], [-121.8424, 37.31155], [-121.84227, 37.31143], [-121.84087, 37.31233], [-121.83874, 37.31013], [-121.83834, 37.31021], [-121.83826, 37.31018], [-121.83818, 37.30998], [-121.8405, 37.30851], [-121.84104, 37.30881], [-121.84172, 37.30836], [-121.84174, 37.30816], [-121.84192, 37.30821], [-121.84201, 37.30813], [-121.84264, 37.30823], [-121.84316, 37.30838], [-121.84336, 37.3085], [-121.8433, 37.30859], [-121.84323, 37.30876], [-121.84333, 37.30881], [-121.84336, 37.30881], [-121.84355, 37.30895], [-121.84378, 37.30875], [-121.84442, 37.30913], [-121.84501, 37.30972]]]} | Open Access 1 | Tully Community Ballfields | http://www.sanjoseca.gov/Facilities/Facility/Details/Tully-Community-Ballfields-97 | 27907 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 36.448 | Tully Community Ballfields |
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]);