superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where MNG_AGENCY = 558 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 9 ✖
MNG_AGENCY 1
- Mission Oaks Recreation and Park District · 9 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);