units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where COUNTY = 41, MNG_AGENCY = 558 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 ✖
DES_TP 1
- Local Park 14
ACCESS_TYP 1
- Open Access 14
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2978 | 2978 | 2977 | {"type": "Polygon", "coordinates": [[[-121.36756, 38.62183], [-121.36755, 38.6231], [-121.36591, 38.62309], [-121.3659, 38.62214], [-121.36675, 38.62215], [-121.36677, 38.62182], [-121.36756, 38.62183]]]} | Open Access 1 | 23965 | Eastern Oak Park | 18391 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.352 | Eastern Oak Park | 0 | Local Park 2 | 4 | |
11664 | 11664 | 11663 | {"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 | 23957 | Gibbons Park | 19287 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.543 | Gibbons Park | 0 | Local Park 2 | 4 | |
11669 | 11669 | 11668 | {"type": "Polygon", "coordinates": [[[-121.35515, 38.62653], [-121.35278, 38.6265], [-121.35281, 38.6262], [-121.35286, 38.62619], [-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], [-121.35515, 38.62653]]]} | Open Access 1 | 23961 | Mission North Park | 22302 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.936 | Mission North Park | 0 | Local Park 2 | 4 | |
11670 | 11670 | 11669 | {"type": "Polygon", "coordinates": [[[-121.37363, 38.62457], [-121.37362, 38.62584], [-121.37137, 38.62611], [-121.37137, 38.62591], [-121.37182, 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 | 23962 | Cowan Park | 17728 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.408 | Cowan Park | 0 | Local Park 2 | 4 | |
11676 | 11676 | 11675 | {"type": "Polygon", "coordinates": [[[-121.36972, 38.61298], [-121.36924, 38.61336], [-121.36905, 38.6139], [-121.36899, 38.6142], [-121.369, 38.6143], [-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.36746, 38.61347], [-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 | 23969 | Del Paso Manor Park | 18045 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.911 | Del Paso Manor Park | 0 | Local Park 2 | 4 | |
11683 | 11683 | 11682 | {"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 | 23978 | Orville Wright Park | 23229 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.401 | Orville Wright Park | 0 | Local Park 2 | 4 | |
11688 | 11688 | 11687 | {"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 | 23983 | Windemere Park | 27623 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 0.514 | Windemere Park | 0 | Local Park 2 | 4 | |
11689 | 11689 | 11688 | {"type": "Polygon", "coordinates": [[[-121.33505, 38.59867], [-121.33505, 38.5987], [-121.335, 38.59872], [-121.33385, 38.59898], [-121.33372, 38.59902], [-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 | 23984 | Shelfield Park | 25386 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.728 | Shelfield Park | 0 | Local Park 2 | 4 | |
11690 | 11690 | 11689 | {"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.34927, 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 | 23985 | Maddox Park | 21644 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.873 | Maddox Park | 0 | Local Park 2 | 4 | |
11692 | 11692 | 11691 | {"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 | 23989 | Valley Oak Park | 26794 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.183 | Valley Oak Park | 0 | Local Park 2 | 4 | |
11697 | 11697 | 11696 | {"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 | 23994 | Swanston Park | 26097 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.582 | Swanston Park | 0 | Local Park 2 | 4 | |
11700 | 11700 | 11699 | {"type": "Polygon", "coordinates": [[[-121.39701, 38.56927], [-121.39659, 38.57062], [-121.39642, 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 | 23997 | Sierra Oaks Park | 25462 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 11.776 | Sierra Oaks Park | 0 | Local Park 2 | 4 | |
11703 | 11703 | 11702 | {"type": "MultiPolygon", "coordinates": [[[[-121.39662, 38.56736], [-121.39619, 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.56791], [-121.39747, 38.56799]]]]} | Open Access 1 | 24000 | Oak Meadow Park | 22989 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.552 | Oak Meadow Park | 0 | Local Park 2 | 4 | |
13106 | 13106 | 13105 | {"type": "Polygon", "coordinates": [[[-121.36647, 38.57697], [-121.36491, 38.57743], [-121.36468, 38.57747], [-121.36465, 38.57737], [-121.36465, 38.57714], [-121.36415, 38.57728], [-121.36363, 38.57713], [-121.36368, 38.57704], [-121.36372, 38.57694], [-121.36374, 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 | 35024 | Ashton Park | 15656 | 2191 | Mission Oaks Recreation and Park District 566 | Special District 4 | Recreation/Parks District 4 | http://www.morpd.com/ | Special District 4 | 2191 | Mission Oaks Recreation and Park District 558 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 11.243 | Ashton Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);