superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where MNG_AGENCY = 558, MNG_AG_LEV = 4 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 14 ✖
MNG_AGENCY 1
- Mission Oaks Recreation and Park District · 14 ✖
ACCESS_TYP 1
- Open Access 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1636 | 1636 | 1635 | {"type": "Polygon", "coordinates": [[[-121.36647, 38.57697], [-121.36491, 38.57743], [-121.36468, 38.57747], [-121.36465, 38.57737], [-121.36464, 38.57714], [-121.36415, 38.57728], [-121.36363, 38.57713], [-121.36368, 38.57704], [-121.36372, 38.57694], [-121.36373, 38.57674], [-121.3637, 38.57661], [-121.36346, 38.576], [-121.36344, 38.57586], [-121.36347, 38.57573], [-121.36562, 38.5751], [-121.36647, 38.57697]]]} | Open Access 1 | Ashton Park | 15656 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 11.245 | Ashton Park | ||
3260 | 3260 | 3259 | {"type": "Polygon", "coordinates": [[[-121.37363, 38.62457], [-121.37362, 38.62584], [-121.37137, 38.62611], [-121.37137, 38.62591], [-121.37181, 38.62538], [-121.37194, 38.62516], [-121.37276, 38.62514], [-121.37288, 38.62499], [-121.37351, 38.62482], [-121.37363, 38.62457]]]} | Open Access 1 | Cowan Park | 17728 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 4.409 | Cowan Park | ||
3537 | 3537 | 3536 | {"type": "Polygon", "coordinates": [[[-121.36972, 38.61298], [-121.36924, 38.61336], [-121.36905, 38.6139], [-121.36899, 38.6142], [-121.369, 38.61429], [-121.3692, 38.61451], [-121.36807, 38.61518], [-121.368, 38.61517], [-121.36778, 38.61491], [-121.36758, 38.61455], [-121.36747, 38.61425], [-121.36742, 38.61396], [-121.36742, 38.61368], [-121.3675, 38.61333], [-121.36764, 38.61301], [-121.36781, 38.61275], [-121.36798, 38.61256], [-121.36818, 38.61239], [-121.3684, 38.61224], [-121.36857, 38.61215], [-121.36862, 38.61216], [-121.36972, 38.61298]]]} | Open Access 1 | Del Paso Manor Park | 18045 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 9.907 | Del Paso Manor Park | ||
3809 | 3809 | 3808 | {"type": "Polygon", "coordinates": [[[-121.36756, 38.62183], [-121.36755, 38.6231], [-121.36591, 38.62309], [-121.3659, 38.62214], [-121.36674, 38.62215], [-121.36677, 38.62182], [-121.36756, 38.62183]]]} | Open Access 1 | Eastern Oak Park | 18391 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 4.355 | Eastern Oak Park | ||
4557 | 4557 | 4556 | {"type": "Polygon", "coordinates": [[[-121.35466, 38.63562], [-121.35466, 38.63734], [-121.35236, 38.63732], [-121.35235, 38.63558], [-121.35466, 38.63562]]]} | Open Access 1 | Gibbons Park | 19287 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 9.542 | Gibbons Park | ||
6505 | 6505 | 6504 | {"type": "Polygon", "coordinates": [[[-121.35203, 38.59911], [-121.35183, 38.59912], [-121.35182, 38.59922], [-121.34868, 38.59918], [-121.34869, 38.59873], [-121.34876, 38.59855], [-121.34909, 38.5983], [-121.34926, 38.59828], [-121.34928, 38.59802], [-121.34969, 38.59802], [-121.3498, 38.59804], [-121.34994, 38.59809], [-121.35058, 38.59853], [-121.35095, 38.5987], [-121.35115, 38.59876], [-121.35144, 38.59881], [-121.35203, 38.59884], [-121.35203, 38.59911]]]} | Open Access 1 | Maddox Park | 21644 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 5.875 | Maddox Park | ||
6591 | 6591 | 6590 | {"type": "Polygon", "coordinates": [[[-121.37683, 38.60488], [-121.37682, 38.60579], [-121.3748, 38.60579], [-121.37484, 38.60486], [-121.37683, 38.60488]]]} | Open Access 1 | Orville Wright Park | 23229 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 4.401 | Orville Wright Park | ||
7056 | 7056 | 7055 | {"type": "Polygon", "coordinates": [[[-121.35515, 38.62482], [-121.35515, 38.62653], [-121.35278, 38.6265], [-121.35281, 38.6262], [-121.35286, 38.62618], [-121.35291, 38.62571], [-121.35297, 38.6257], [-121.35297, 38.62527], [-121.35299, 38.62519], [-121.35298, 38.62471], [-121.35385, 38.6247], [-121.35395, 38.62438], [-121.35409, 38.62441], [-121.3542, 38.62445], [-121.35443, 38.6246], [-121.3546, 38.62467], [-121.35479, 38.62473], [-121.35509, 38.62475], [-121.35513, 38.62478], [-121.35515, 38.62482]]]} | Open Access 1 | Mission North Park | 22302 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 9.939 | Mission North Park | ||
7555 | 7555 | 7554 | {"type": "MultiPolygon", "coordinates": [[[[-121.39662, 38.56736], [-121.3962, 38.56742], [-121.39581, 38.56744], [-121.39409, 38.56573], [-121.39478, 38.56552], [-121.39662, 38.56736]]], [[[-121.39747, 38.56799], [-121.39733, 38.56851], [-121.39675, 38.56838], [-121.39602, 38.56765], [-121.39641, 38.56761], [-121.39681, 38.56755], [-121.39716, 38.5679], [-121.39747, 38.56799]]]]} | Open Access 1 | Oak Meadow Park | 22989 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 5.551 | Oak Meadow Park | ||
9583 | 9583 | 9582 | {"type": "Polygon", "coordinates": [[[-121.33505, 38.59867], [-121.33505, 38.5987], [-121.335, 38.59872], [-121.33385, 38.59898], [-121.33372, 38.59903], [-121.33356, 38.59912], [-121.33343, 38.59914], [-121.3334, 38.59914], [-121.33335, 38.5991], [-121.33326, 38.59884], [-121.33324, 38.59872], [-121.33323, 38.59855], [-121.3333, 38.59831], [-121.33335, 38.59821], [-121.33347, 38.59806], [-121.33439, 38.59787], [-121.33474, 38.59806], [-121.33486, 38.59816], [-121.33493, 38.59828], [-121.33505, 38.59867]]]} | Open Access 1 | Shelfield Park | 25386 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 3.728 | Shelfield Park | ||
9645 | 9645 | 9644 | {"type": "Polygon", "coordinates": [[[-121.39701, 38.56927], [-121.39659, 38.57062], [-121.39643, 38.57058], [-121.39639, 38.57067], [-121.39359, 38.57023], [-121.3936, 38.56913], [-121.39356, 38.56875], [-121.39389, 38.56874], [-121.3951, 38.56889], [-121.39701, 38.56927]]]} | Open Access 1 | Sierra Oaks Park | 25462 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 11.776 | Sierra Oaks Park | ||
10159 | 10159 | 10158 | {"type": "Polygon", "coordinates": [[[-121.40843, 38.57976], [-121.40843, 38.58149], [-121.40611, 38.58146], [-121.40612, 38.57974], [-121.40843, 38.57976]]]} | Open Access 1 | Swanston Park | 26097 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 9.581 | Swanston Park | ||
10619 | 10619 | 10618 | {"type": "Polygon", "coordinates": [[[-121.36447, 38.5847], [-121.36447, 38.58548], [-121.36311, 38.58547], [-121.36309, 38.5865], [-121.36228, 38.58649], [-121.36089, 38.58465], [-121.36447, 38.5847]]]} | Open Access 1 | Valley Oak Park | 26794 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 9.19 | Valley Oak Park | ||
11314 | 11314 | 11313 | {"type": "Polygon", "coordinates": [[[-121.36656, 38.59914], [-121.36656, 38.5994], [-121.36652, 38.59943], [-121.3658, 38.59942], [-121.36581, 38.59913], [-121.36656, 38.59914]]]} | Open Access 1 | Windemere Park | 27623 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 0.514 | Windemere 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]);