superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where MNG_AGENCY = 109
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5463 | 5463 | 5462 | {"type": "Polygon", "coordinates": [[[-121.96099, 36.97023], [-121.95986, 36.97023], [-121.95983, 36.97013], [-121.95832, 36.97013], [-121.95832, 36.96878], [-121.96098, 36.96853], [-121.96099, 36.97023]]]} | Open Access 1 | Jade Street Park | 20334 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 9.882 | Jade Street Park | ||
7142 | 7142 | 7141 | {"type": "Polygon", "coordinates": [[[-121.94638, 36.98028], [-121.94534, 36.98101], [-121.94528, 36.98093], [-121.94521, 36.98071], [-121.94506, 36.98036], [-121.94494, 36.98016], [-121.94468, 36.97983], [-121.94567, 36.97911], [-121.94638, 36.98028]]]} | Open Access 1 | Monterey Avenue Park | 22414 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 3.988 | Monterey Avenue Park | ||
7143 | 7143 | 7142 | {"type": "Polygon", "coordinates": [[[-121.94543, 36.97873], [-121.9451, 36.97895], [-121.94502, 36.97897], [-121.94541, 36.9787], [-121.94543, 36.97873]]]} | Open Access 1 | Monterey Avenue Park Access | 22415 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 0.034 | Monterey Avenue Park Access | ||
7401 | 7401 | 7400 | {"type": "Polygon", "coordinates": [[[-121.95042, 36.97668], [-121.95007, 36.97711], [-121.94999, 36.97716], [-121.94991, 36.97733], [-121.94972, 36.97786], [-121.94988, 36.97832], [-121.94997, 36.97847], [-121.94934, 36.97817], [-121.94947, 36.97798], [-121.9492, 36.97784], [-121.95014, 36.97662], [-121.9502, 36.97659], [-121.95027, 36.97659], [-121.95032, 36.9766], [-121.95042, 36.97668]]]} | Open Access 1 | Noble Gulch Park | 22777 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1.559 | Noble Gulch Park | ||
8065 | 8065 | 8064 | {"type": "Polygon", "coordinates": [[[-121.95942, 36.98268], [-121.95913, 36.98269], [-121.95908, 36.98266], [-121.95881, 36.98205], [-121.95873, 36.98207], [-121.9587, 36.98201], [-121.95876, 36.98198], [-121.95877, 36.98197], [-121.95847, 36.9815], [-121.95792, 36.98085], [-121.95761, 36.98058], [-121.95751, 36.98023], [-121.95726, 36.98027], [-121.95668, 36.97982], [-121.95655, 36.97966], [-121.95707, 36.9794], [-121.95682, 36.97903], [-121.95655, 36.97916], [-121.95646, 36.979], [-121.95641, 36.97888], [-121.95636, 36.97863], [-121.95642, 36.97743], [-121.95637, 36.97725], [-121.95643, 36.97725], [-121.9566, 36.9777], [-121.9572, 36.97748], [-121.95793, 36.97954], [-121.95802, 36.97969], [-121.95819, 36.97986], [-121.95847, 36.98], [-121.95912, 36.98053], [-121.9589, 36.98075], [-121.95911, 36.98114], [-121.95923, 36.98178], [-121.95933, 36.98176], [-121.95937, 36.98193], [-121.95935, 36.98225], [-121.95942, 36.98268]]]} | Open Access 1 | Peery Park | 23565 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 12.539 | Peery Park | ||
9768 | 9768 | 9767 | {"type": "MultiPolygon", "coordinates": [[[[-121.95373, 36.97272], [-121.95357, 36.973], [-121.95313, 36.97262], [-121.95289, 36.97279], [-121.95277, 36.97267], [-121.95323, 36.97241], [-121.9534, 36.97233], [-121.95349, 36.97232], [-121.95355, 36.97237], [-121.95362, 36.97253], [-121.95373, 36.97272]]], [[[-121.95514, 36.97464], [-121.95484, 36.97468], [-121.95481, 36.97466], [-121.95468, 36.97473], [-121.95455, 36.97457], [-121.95473, 36.97446], [-121.95467, 36.97434], [-121.95418, 36.97457], [-121.95416, 36.97455], [-121.95466, 36.97429], [-121.95458, 36.97412], [-121.95379, 36.97318], [-121.95387, 36.97304], [-121.95418, 36.97332], [-121.95431, 36.97348], [-121.95434, 36.97354], [-121.95474, 36.97406], [-121.95493, 36.97432], [-121.95502, 36.97451], [-121.95505, 36.97451], [-121.95514, 36.97464]]], [[[-121.95491, 36.97485], [-121.95485, 36.9749], [-121.95478, 36.97481], [-121.95487, 36.97475], [-121.95491, 36.97485]]], [[[-121.95588, 36.97452], [-121.9558, 36.97455], [-121.95563, 36.97424], [-121.95526, 36.97383], [-121.9551, 36.97373], [-121.95525, 36.97374], [-121.95532, 36.97379], [-121.95571, 36.97421], [-121.95588, 36.97452]]]]} | Open Access 1 | Soquel Creek Park | 25621 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 2.031 | Soquel Creek Park | ||
11795 | 11795 | 11794 | {"type": "Polygon", "coordinates": [[[-121.95838, 36.97879], [-121.95814, 36.97879], [-121.95814, 36.97846], [-121.95838, 36.97845], [-121.95838, 36.97879]]]} | Open Access 1 | Library Tot Lot | http://www.santacruzpl.org/branches/6/ | 28423 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 0.197 | Library Tot Lot | |
15181 | 15181 | 15180 | {"type": "MultiPolygon", "coordinates": [[[[-121.93582, 36.98343], [-121.93526, 36.98352], [-121.93436, 36.98353], [-121.93408, 36.98356], [-121.93438, 36.98218], [-121.93441, 36.98218], [-121.9356, 36.98248], [-121.93582, 36.98343]]], [[[-121.93845, 36.98138], [-121.93822, 36.98211], [-121.93823, 36.98217], [-121.9383, 36.98221], [-121.93804, 36.9822], [-121.938, 36.98217], [-121.93799, 36.98211], [-121.93823, 36.98134], [-121.93845, 36.98138]]]]} | Open Access 1 | New Brighton State Beach | http://www.parks.ca.gov/?page_id=542 | 22706 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 4.78 | New Brighton SB | 1933 |
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]);