units_with_maps_view (view)
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
172 | {"type": "Polygon", "coordinates": [[[-120.4259, 37.94699], [-120.42564, 37.9476], [-120.4255, 37.94811], [-120.42551, 37.94822], [-120.42504, 37.94841], [-120.42471, 37.94817], [-120.42435, 37.94782], [-120.42412, 37.94745], [-120.42349, 37.94692], [-120.42464, 37.94646], [-120.42483, 37.94685], [-120.42539, 37.94659], [-120.42558, 37.94679], [-120.4259, 37.94699]]]} | 1 | 548 | Cemetery | 17011 | 2050 | 66 | 4 | 11 | 4 | 2050 | 64 | 4 | 11 | 21 | 6.082 | Cemetery | 0 | 19 | 4 | ||
174 | {"type": "Polygon", "coordinates": [[[-119.65914, 34.41998], [-119.65807, 34.4201], [-119.65671, 34.42044], [-119.65662, 34.42048], [-119.65651, 34.42056], [-119.65592, 34.42119], [-119.65575, 34.42131], [-119.65555, 34.42137], [-119.65541, 34.42139], [-119.65297, 34.42138], [-119.65294, 34.42134], [-119.65294, 34.41914], [-119.65261, 34.41913], [-119.65261, 34.41724], [-119.65352, 34.41719], [-119.65403, 34.41712], [-119.65457, 34.41717], [-119.65502, 34.41711], [-119.65526, 34.41712], [-119.65548, 34.41708], [-119.65595, 34.41711], [-119.65614, 34.41706], [-119.65649, 34.41705], [-119.65687, 34.41702], [-119.65729, 34.41703], [-119.65751, 34.41701], [-119.65793, 34.41701], [-119.65827, 34.41698], [-119.6587, 34.41702], [-119.65912, 34.41699], [-119.65914, 34.41998]]]} | 1 | 481 | Santa Barbara Cemetery | 25039 | 2140 | 67 | 4 | 11 | 4 | 2140 | 65 | 4 | 11 | 7 | 59.983 | Santa Barbara Cemetery | 0 | 19 | 4 | ||
181 | {"type": "Polygon", "coordinates": [[[-120.40136, 38.00555], [-120.40072, 38.00607], [-120.40064, 38.00615], [-120.40061, 38.00621], [-120.40038, 38.00615], [-120.40036, 38.00603], [-120.39992, 38.00605], [-120.39963, 38.00604], [-120.40009, 38.00557], [-120.40036, 38.00524], [-120.40055, 38.00505], [-120.40073, 38.00515], [-120.40136, 38.00555]]]} | 1 | 579 | Cemetery | 17015 | 2150 | 69 | 4 | 11 | 4 | 2150 | 67 | 4 | 11 | 21 | 2.301 | Cemetery | 0 | 19 | 4 | ||
183 | {"type": "Polygon", "coordinates": [[[-120.2455, 37.82767], [-120.24545, 37.82809], [-120.24528, 37.82907], [-120.24525, 37.82917], [-120.24352, 37.82889], [-120.24371, 37.82745], [-120.2455, 37.82767]]]} | 1 | 561 | Cemetery | 17014 | 2098 | 71 | 4 | 11 | 4 | 2098 | 69 | 4 | 11 | 21 | 6.428 | Cemetery | 0 | 19 | 4 | ||
188 | {"type": "Polygon", "coordinates": [[[-121.69813, 38.13724], [-121.69797, 38.13757], [-121.69794, 38.13778], [-121.698, 38.138], [-121.698, 38.13839], [-121.69766, 38.13941], [-121.69748, 38.13979], [-121.69707, 38.14119], [-121.69655, 38.14207], [-121.69614, 38.14262], [-121.69612, 38.14317], [-121.69601, 38.14374], [-121.69455, 38.14262], [-121.69398, 38.1421], [-121.69404, 38.14198], [-121.69415, 38.14179], [-121.69439, 38.14132], [-121.69453, 38.14097], [-121.69475, 38.14037], [-121.69492, 38.14001], [-121.6952, 38.13921], [-121.6953, 38.13884], [-121.69555, 38.13824], [-121.69594, 38.13708], [-121.6961, 38.13642], [-121.69719, 38.1368], [-121.69813, 38.13724]]]} | 1 | 520 | Sandy Beach Park | 25025 | 2187 | 74 | 4 | 6 | 4 | 2187 | 72 | 4 | 6 | 26 | 36.239 | Sandy Beach Park | 0 | 2 | 4 | ||
194 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | 1 | 569 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | 78 | 4 | 4 | 4 | 2203 | 76 | 4 | 4 | 22 | 9.887 | Foglesong Park/Eda Henderson Pool | 0 | 3 | 4 | ||
238 | {"type": "Polygon", "coordinates": [[[-119.19796, 36.31684], [-119.19795, 36.31782], [-119.19604, 36.31789], [-119.196, 36.31689], [-119.19796, 36.31684]]]} | 1 | 773 | Deep Creek Cemetery | 17988 | 2033 | 99 | 4 | 11 | 4 | 2033 | 97 | 4 | 11 | 29 | 4.704 | Deep Creek Cemetery | 0 | 19 | 4 | ||
285 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | 1 | 778 | Exeter Cemetery | 18773 | 2033 | 99 | 4 | 11 | 4 | 2033 | 97 | 4 | 11 | 29 | 18.069 | Exeter Cemetery | 0 | 19 | 4 | ||
289 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | 1 | 782 | Hamilton Cemetery | 19616 | 2033 | 99 | 4 | 11 | 4 | 2033 | 97 | 4 | 11 | 29 | 7.139 | Hamilton Cemetery | 0 | 19 | 4 | ||
297 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | 1 | 802 | Frazier Valley Cemetery | 19071 | 2060 | 122 | 4 | 11 | 4 | 2060 | 119 | 4 | 11 | 29 | 2.538 | Frazier Valley Cemetery | 0 | 19 | 4 | ||
303 | {"type": "Polygon", "coordinates": [[[-119.10787, 36.41389], [-119.10786, 36.41561], [-119.10573, 36.41561], [-119.10572, 36.4146], [-119.10643, 36.4146], [-119.10644, 36.41385], [-119.10787, 36.41389]]]} | 1 | 1041 | Antelope Cemetery | 15507 | 2184 | 124 | 4 | 11 | 4 | 2184 | 121 | 4 | 11 | 29 | 7.877 | Antelope Cemetery | 0 | 19 | 4 | ||
324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | 131 | 5 | 5 | 5 | 299 | 128 | 5 | 5 | 5 | 0.139 | Stockton Avenue Beach | 33 | ||||
331 | {"type": "Polygon", "coordinates": [[[-121.31293, 36.42631], [-121.31293, 36.42822], [-121.31184, 36.42912], [-121.3115, 36.42912], [-121.3115, 36.42606], [-121.31293, 36.42631]]]} | 1 | 911 | Soledad Cemetery | 25597 | 2153 | 135 | 4 | 11 | 4 | 2153 | 132 | 4 | 11 | 14 | 9.116 | Soledad Cemetery | 0 | 19 | 4 | ||
350 | {"type": "Polygon", "coordinates": [[[-119.32193, 36.20761], [-119.32189, 36.20923], [-119.32081, 36.20925], [-119.32078, 36.20934], [-119.31981, 36.20934], [-119.31987, 36.20762], [-119.32193, 36.20761]]]} | 1 | 969 | Tulare Veterans Memorial Park | 26570 | 2168 | 144 | 4 | 11 | 4 | 2168 | 140 | 4 | 11 | 29 | 8.555 | Tulare Veterans Memorial Park | 0 | 2 | 4 | ||
365 | {"type": "Polygon", "coordinates": [[[-119.18856, 36.09471], [-119.18594, 36.09472], [-119.18594, 36.09315], [-119.18855, 36.09314], [-119.18856, 36.09471]]]} | 1 | 1046 | Woodville Cemetery | 27750 | 2185 | 150 | 4 | 11 | 4 | 2185 | 146 | 4 | 11 | 29 | 10.155 | Woodville Cemetery | 0 | 19 | 4 | ||
377 | {"type": "Polygon", "coordinates": [[[-119.20947, 36.30166], [-119.20848, 36.30166], [-119.20849, 36.30084], [-119.20946, 36.30084], [-119.20947, 36.30166]]]} | 1 | 1136 | Jennings Park | 20389 | 1106 | 155 | 2 | 2 | 2 | 1106 | 151 | 2 | 2 | 29 | 1.978 | Jennings Park | 0 | 2 | 4 | ||
380 | {"type": "Polygon", "coordinates": [[[-119.21304, 36.31701], [-119.213, 36.31821], [-119.20857, 36.31818], [-119.20859, 36.31659], [-119.20864, 36.31665], [-119.20877, 36.31669], [-119.20887, 36.31664], [-119.21059, 36.31665], [-119.21139, 36.31671], [-119.21209, 36.31679], [-119.21304, 36.31701]]]} | 1 | 1141 | Liberty Park | 21210 | 1106 | 155 | 2 | 2 | 2 | 1106 | 151 | 2 | 2 | 29 | 16.086 | Liberty Park | 0 | 2 | 4 | ||
383 | {"type": "Polygon", "coordinates": [[[-119.20715, 36.29112], [-119.20714, 36.29174], [-119.20533, 36.29176], [-119.20533, 36.29057], [-119.20679, 36.29058], [-119.20679, 36.29112], [-119.20715, 36.29112]]]} | 1 | 1151 | Roy Park | 24712 | 1106 | 155 | 2 | 2 | 2 | 1106 | 151 | 2 | 2 | 29 | 4.789 | Roy Park | 0 | 2 | 4 | ||
515 | {"type": "Polygon", "coordinates": [[[-120.62395, 36.98985], [-120.62208, 36.98986], [-120.62208, 36.98902], [-120.62395, 36.98902], [-120.62395, 36.98985]]]} | 1 | 25989 | Pierini Park | 23664 | 1460 | 194 | 2 | 2 | 2 | 1460 | 190 | 2 | 2 | 37 | 3.824 | Pierini Park | 0 | 2 | 4 | ||
526 | {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} | 1 | 25990 | Des Park | 18106 | 1460 | 194 | 2 | 2 | 2 | 1460 | 190 | 2 | 2 | 37 | 0.735 | Des Park | 0 | 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW units_with_maps_view AS select id, AsGeoJSON(geometry) as 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 from CPAD_2020a_Units order by id;