superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_LEV = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 465
- San Diego, City of 433
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 218
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 124
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 94
- Modesto, City of 84
- Stockton, City of 81
- Santa Rosa, City of 79
- Huntington Beach, City of 76
- Tracy, City of 73
- Torrance, City of 72
- Santa Cruz, City of 69
- Chula Vista, City of 69
- Brentwood, City of 68
- Poway, City of 67
- Newport Beach, City of 65
- Santa Barbara, City of 64
- Davis, City of 64
- San Luis Obispo, City of 63
- Napa, City of 62
- Clovis, City of 62
- Bakersfield, City of 61
- Manteca, City of 60
- Anaheim, City of 59
- …
ACCESS_TYP 4
- Open Access 9,670
- Restricted Access 356
- No Public Access 155
- Unknown Access 29
MNG_AG_TYP 1
- City Agency 10,210
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1214 | 1214 | 1213 | {"type": "Polygon", "coordinates": [[[-121.92056, 41.96329], [-121.92015, 41.9633], [-121.92014, 41.96304], [-121.92012, 41.96303], [-121.92011, 41.96278], [-121.92056, 41.96277], [-121.92056, 41.96329]]]} | Open Access 1 | Dorris Park | 32906 | 1699 | Dorris, City of 809 | City 2 | City Agency 2 | City 2 | 0.509 | Dorris Park | |||
1572 | 1572 | 1571 | {"type": "Polygon", "coordinates": [[[-119.20262, 36.30185], [-119.2026, 36.30265], [-119.20192, 36.3026], [-119.20185, 36.30252], [-119.20175, 36.30248], [-119.20153, 36.30251], [-119.20151, 36.30182], [-119.20256, 36.30181], [-119.20262, 36.30185]]]} | Open Access 1 | Armstrong Park | 15595 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | City 2 | 2.064 | Armstrong Park | |||
3383 | 3383 | 3382 | {"type": "Polygon", "coordinates": [[[-120.12771, 36.00901], [-120.12558, 36.00898], [-120.12556, 36.00807], [-120.1277, 36.00811], [-120.12771, 36.00901]]]} | Open Access 1 | Floyd Rice Park | 18965 | 1017 | Avenal, City of 719 | City 2 | City Agency 2 | City 2 | 4.786 | Floyd Rice Park | |||
3578 | 3578 | 3577 | {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} | Open Access 1 | Des Park | 18106 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | City 2 | 0.735 | Des Park | |||
3830 | 3830 | 3829 | {"type": "Polygon", "coordinates": [[[-120.57104, 34.97032], [-120.57096, 34.97044], [-120.57051, 34.97024], [-120.57058, 34.97012], [-120.57104, 34.97032]]]} | Open Access 1 | Guadalupe holding 10 | 19546 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.174 | Guadalupe holding 10 | |||
3831 | 3831 | 3830 | {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} | Open Access 1 | Guadalupe holding 2 | 19547 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.371 | Guadalupe holding 2 | |||
3832 | 3832 | 3831 | {"type": "Polygon", "coordinates": [[[-120.5712, 34.97007], [-120.57104, 34.97032], [-120.57058, 34.97012], [-120.5709, 34.96963], [-120.57109, 34.96971], [-120.57095, 34.96996], [-120.5712, 34.97007]]]} | Open Access 1 | Guadalupe holding 3 | 19548 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.517 | Guadalupe holding 3 | |||
3833 | 3833 | 3832 | {"type": "Polygon", "coordinates": [[[-120.57089, 34.97056], [-120.57073, 34.9708], [-120.57028, 34.97061], [-120.57051, 34.97024], [-120.57088, 34.9704], [-120.57082, 34.97051], [-120.57089, 34.97056]]]} | Open Access 1 | Guadalupe holding 4 | 19549 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.501 | Guadalupe holding 4 | |||
3834 | 3834 | 3833 | {"type": "Polygon", "coordinates": [[[-120.58072, 34.9624], [-120.58052, 34.96254], [-120.58041, 34.96249], [-120.58049, 34.96217], [-120.58062, 34.96216], [-120.58072, 34.9624]]]} | Open Access 1 | Guadalupe holding 5 | 19550 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.189 | Guadalupe holding 5 | |||
4788 | 4788 | 4787 | {"type": "Polygon", "coordinates": [[[-120.57749, 34.95931], [-120.57749, 34.95936], [-120.57745, 34.95938], [-120.57717, 34.95939], [-120.57718, 34.95846], [-120.57722, 34.95871], [-120.57726, 34.95884], [-120.57749, 34.95931]]]} | Open Access 1 | Guadalupe holding 1 | 19545 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.328 | Guadalupe holding 1 | |||
4789 | 4789 | 4788 | {"type": "Polygon", "coordinates": [[[-120.57892, 34.964], [-120.57887, 34.96401], [-120.57829, 34.96412], [-120.57829, 34.964], [-120.57892, 34.964]]]} | Open Access 1 | Guadalupe holding 6 | 19551 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.1 | Guadalupe holding 6 | |||
4790 | 4790 | 4789 | {"type": "Polygon", "coordinates": [[[-120.58049, 34.96217], [-120.58041, 34.96249], [-120.58017, 34.96234], [-120.58038, 34.96212], [-120.58049, 34.96217]]]} | Open Access 1 | Guadalupe holding 7 | 19552 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.158 | Guadalupe holding 7 | |||
4791 | 4791 | 4790 | {"type": "Polygon", "coordinates": [[[-120.57643, 34.96381], [-120.57642, 34.96423], [-120.57588, 34.96423], [-120.57589, 34.96395], [-120.57623, 34.96395], [-120.57625, 34.96381], [-120.57643, 34.96381]]]} | Open Access 1 | Guadalupe holding 8 | 19553 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.437 | Guadalupe holding 8 | |||
4792 | 4792 | 4791 | {"type": "Polygon", "coordinates": [[[-120.57752, 34.96378], [-120.57752, 34.96399], [-120.57714, 34.96399], [-120.57714, 34.96377], [-120.57752, 34.96378]]]} | Unknown Access 4 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.205 | Guadalupe holding 9 | |||
5441 | 5441 | 5440 | {"type": "Polygon", "coordinates": [[[-120.59124, 34.95777], [-120.59116, 34.96061], [-120.58835, 34.96058], [-120.58837, 34.96035], [-120.58852, 34.95999], [-120.58868, 34.9598], [-120.58886, 34.95964], [-120.5892, 34.95938], [-120.58939, 34.95916], [-120.58958, 34.9588], [-120.58962, 34.9586], [-120.58965, 34.95785], [-120.58967, 34.9578], [-120.58974, 34.95777], [-120.59124, 34.95777]]]} | Open Access 1 | Jack O'Conell Park | 20306 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 14.46 | Jack O'Conell Park | |||
5513 | 5513 | 5512 | {"type": "Polygon", "coordinates": [[[-119.20947, 36.30166], [-119.20848, 36.30166], [-119.20849, 36.30084], [-119.20946, 36.30084], [-119.20947, 36.30166]]]} | Open Access 1 | Jennings Park | 20389 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | City 2 | 1.977 | Jennings Park | |||
6117 | 6117 | 6116 | {"type": "Polygon", "coordinates": [[[-120.57389, 34.97384], [-120.57321, 34.97483], [-120.57204, 34.97432], [-120.57273, 34.97333], [-120.57389, 34.97384]]]} | Open Access 1 | Leroy Park | 21178 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 3.784 | Leroy Park | |||
6149 | 6149 | 6148 | {"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]]]} | Open Access 1 | Liberty Park | 21210 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | City 2 | 16.086 | Liberty Park | |||
6355 | 6355 | 6354 | {"type": "Polygon", "coordinates": [[[-119.20698, 36.30827], [-119.20697, 36.30938], [-119.20663, 36.30949], [-119.2063, 36.30958], [-119.20595, 36.30965], [-119.20552, 36.30971], [-119.20556, 36.30825], [-119.20572, 36.30826], [-119.20698, 36.30827]]]} | Open Access 1 | Lone Oak Park | 21439 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | City 2 | 4.622 | Lone Oak Park | |||
9039 | 9039 | 9038 | {"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]]]} | Open Access 1 | Roy Park | 24712 | 1106 | Farmersville, City of 151 | City 2 | City Agency 2 | City 2 | 4.792 | Roy 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]);