superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 260 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1969 | 1969 | 1968 | {"type": "Polygon", "coordinates": [[[-119.61346, 36.56549], [-119.61318, 36.56569], [-119.61257, 36.56512], [-119.61285, 36.56492], [-119.61346, 36.56549]]]} | Open Access 1 | Berry Park | 16033 | 1332 | Selma, City of 260 | City 2 | City Agency 2 | http://www.cityofselma.com/recreate/parks.htm | City 2 | 0.702 | Berry Park | ||
2227 | 2227 | 2226 | {"type": "Polygon", "coordinates": [[[-119.60635, 36.56895], [-119.60587, 36.57059], [-119.60518, 36.57246], [-119.60457, 36.57246], [-119.60457, 36.56894], [-119.60635, 36.56895]]]} | Open Access 1 | Brentlinger Park | 16354 | 1332 | Selma, City of 260 | City 2 | City Agency 2 | http://www.cityofselma.com/recreate/parks.htm | City 2 | 10.621 | Brentlinger Park | ||
6201 | 6201 | 6200 | {"type": "Polygon", "coordinates": [[[-119.61061, 36.56877], [-119.6098, 36.56878], [-119.60894, 36.56878], [-119.60977, 36.56754], [-119.61055, 36.5679], [-119.61056, 36.56845], [-119.61061, 36.56846], [-119.61061, 36.56877]]]} | Open Access 1 | Lincoln Park | 21272 | 1332 | Selma, City of 260 | City 2 | City Agency 2 | http://www.cityofselma.com/recreate/parks.htm | City 2 | 3.321 | Lincoln Park | ||
8111 | 8111 | 8110 | {"type": "Polygon", "coordinates": [[[-119.62649, 36.56174], [-119.62646, 36.56248], [-119.62644, 36.56528], [-119.62429, 36.56527], [-119.62426, 36.56173], [-119.62649, 36.56174]]]} | Open Access 1 | Peter Ringo Park | 23628 | 1332 | Selma, City of 260 | City 2 | City Agency 2 | http://www.cityofselma.com/recreate/parks.htm | City 2 | 18.964 | Peter Ringo Park | ||
9115 | 9115 | 9114 | {"type": "Polygon", "coordinates": [[[-119.61297, 36.55872], [-119.61262, 36.55873], [-119.61262, 36.55917], [-119.61184, 36.55918], [-119.61247, 36.55814], [-119.61296, 36.55814], [-119.61297, 36.55872]]]} | Open Access 1 | Salazar Park | 24794 | 1332 | Selma, City of 260 | City 2 | City Agency 2 | http://www.cityofselma.com/recreate/parks.htm | City 2 | 1.672 | Salazar Park | ||
9534 | 9534 | 9533 | {"type": "Polygon", "coordinates": [[[-119.62137, 36.57632], [-119.62132, 36.5787], [-119.61977, 36.57872], [-119.61982, 36.57633], [-119.62137, 36.57632]]]} | Open Access 1 | Shafer Park | 25351 | 1332 | Selma, City of 260 | City 2 | City Agency 2 | http://www.cityofselma.com/recreate/parks.htm | City 2 | 9.081 | Shafer Park |
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]);