units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,394 rows where AGNCY_LEV = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 525
- Los Angeles, City of 485
- San Jose, City of 253
- San Francisco, City and County of 238
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 144
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 98
- Fresno, City of 90
- Modesto, City of 85
- Santa Rosa, City of 82
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Tracy, City of 73
- Santa Cruz, City of 72
- Torrance, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- Davis, City of 65
- San Luis Obispo, City of 64
- Santa Barbara, City of 64
- Newport Beach, City of 64
- Glendale, City of 61
- Bakersfield, City of 61
- Manteca, City of 61
- Riverside, City of 60
- …
DES_TP >30
- Local Park 7,336
- Local Recreation Area 1,414
- Local Other or Unknown 657
- Local Conservation Area 149
- Local Historic or Cultural Area 38
- Local Resource Management Area 6
- National Monument or Landmark 5
- State Conservation Area 2
- None 1
- None 1
- National Forest 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 14
- City Agency 10,272
- Open Space District 21
- Recreation/Parks District 19
- County Agency 16
- Non Profit - Other 11
- Commercial 9
- Non Profit - Conservation 7
- State Agency 5
- County Agency - Parks 4
- Other 3
- County Agency - Other 2
- Non Profit - Land Trust 2
- Port/Harbor District 2
- Community Services District 1
ACCESS_TYP 4
- Open Access 9,878
- Restricted Access 260
- No Public Access 207
- Unknown Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13233 | 13233 | 13232 | {"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 | 35277 | Guadalupe holding 10 | 19546 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.174 | Guadalupe holding 10 | 0 | Local Other or Unknown 14 | 4 | ||
13234 | 13234 | 13233 | {"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 | 35278 | Guadalupe holding 9 | 19554 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.206 | Guadalupe holding 9 | 0 | Local Other or Unknown 14 | 4 | ||
13237 | 13237 | 13236 | {"type": "Polygon", "coordinates": [[[-120.57643, 34.96381], [-120.57642, 34.96423], [-120.57588, 34.96423], [-120.57589, 34.96395], [-120.57624, 34.96395], [-120.57625, 34.96381], [-120.57643, 34.96381]]]} | Open Access 1 | 35281 | Guadalupe holding 8 | 19553 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.436 | Guadalupe holding 8 | 0 | Local Other or Unknown 14 | 4 | ||
13305 | 13305 | 13304 | {"type": "Polygon", "coordinates": [[[-120.5712, 34.97007], [-120.57104, 34.97032], [-120.57058, 34.97012], [-120.5709, 34.96963], [-120.57109, 34.96971], [-120.57094, 34.96996], [-120.5712, 34.97007]]]} | Open Access 1 | 35367 | Guadalupe holding 3 | 19548 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.514 | Guadalupe holding 3 | 0 | Local Other or Unknown 14 | 4 | ||
13306 | 13306 | 13305 | {"type": "Polygon", "coordinates": [[[-120.57089, 34.97056], [-120.57073, 34.9708], [-120.57028, 34.97061], [-120.57051, 34.97024], [-120.57088, 34.9704], [-120.57081, 34.97052], [-120.57089, 34.97056]]]} | Open Access 1 | 35368 | Guadalupe holding 4 | 19549 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.5 | Guadalupe holding 4 | 0 | Local Other or Unknown 14 | 4 | ||
13339 | 13339 | 13338 | {"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 | 35417 | Guadalupe holding 5 | 19550 | 1126 | Guadalupe, City of 480 | City 2 | City Agency 2 | City 2 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | Santa Barbara 7 | 0.189 | Guadalupe holding 5 | 0 | Local Other or Unknown 14 | 4 | ||
14566 | 14566 | 14565 | {"type": "Polygon", "coordinates": [[[-121.48119, 41.95612], [-121.48119, 41.95718], [-121.47928, 41.95717], [-121.47928, 41.95612], [-121.48119, 41.95612]]]} | Open Access 1 | 44710 | Tulelake City Park | 26573 | 1704 | Tulelake, City of 719 | City 2 | City Agency 2 | City 2 | 1704 | Tulelake, City of 702 | City 2 | City Agency 2 | Siskiyou 28 | 4.605 | Tulelake City Park | 0 | Local Park 2 | 4 | ||
15031 | 15031 | 15030 | {"type": "Polygon", "coordinates": [[[-122.83393, 41.61987], [-122.83324, 41.62052], [-122.83325, 41.62054], [-122.83331, 41.62054], [-122.83314, 41.62075], [-122.83212, 41.62027], [-122.83205, 41.62032], [-122.83181, 41.62017], [-122.83282, 41.61921], [-122.83393, 41.61987]]]} | Open Access 1 | 45683 | Walker Field | 28497 | 1701 | Fort Jones, City of 1135 | City 2 | City Agency 2 | City 2 | 1701 | Fort Jones, City of 1090 | City 2 | City Agency 2 | Siskiyou 28 | 3.716 | Walker Field | 0 | Local Recreation Area 3 | 4 | ||
15528 | 15528 | 15527 | {"type": "Polygon", "coordinates": [[[-120.63297, 36.97684], [-120.63292, 36.97688], [-120.63232, 36.97688], [-120.63228, 36.97685], [-120.63228, 36.97652], [-120.63297, 36.97652], [-120.63297, 36.97684]]]} | Open Access 1 | 48941 | Unknown park - Dos Palos, City of | 33657 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 0.607 | 0 | Local Other or Unknown 14 | 4 | |||
480 | 480 | 479 | {"type": "Polygon", "coordinates": [[[-122.25181, 37.74294], [-122.25094, 37.74333], [-122.2502, 37.74331], [-122.2502, 37.74256], [-122.25026, 37.74211], [-122.25158, 37.74235], [-122.25161, 37.74252], [-122.25168, 37.74271], [-122.25181, 37.74294]]]} | Open Access 1 | 1631 | Tillman Park | 26365 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 3.586 | Tillman Park | 0 | Local Park 2 | 4 | |
1754 | 1754 | 1753 | {"type": "Polygon", "coordinates": [[[-122.26219, 37.76826], [-122.26215, 37.76912], [-122.26062, 37.76844], [-122.26111, 37.76773], [-122.26212, 37.76817], [-122.26217, 37.76821], [-122.26219, 37.76826]]]} | Open Access 1 | 13146 | Franklin Park | 19060 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.958 | Franklin Park | 0 | Local Park 2 | 4 | |
1964 | 1964 | 1963 | {"type": "Polygon", "coordinates": [[[-122.23324, 37.73433], [-122.23167, 37.73513], [-122.2312, 37.73448], [-122.23129, 37.73391], [-122.23247, 37.73335], [-122.23324, 37.73433]]]} | Open Access 1 | 15110 | Godfrey Park | 19352 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.982 | Godfrey Park | 0 | Local Park 2 | 4 | |
1965 | 1965 | 1964 | {"type": "Polygon", "coordinates": [[[-122.23947, 37.7313], [-122.23907, 37.73176], [-122.2378, 37.73113], [-122.23824, 37.73064], [-122.23947, 37.7313]]]} | Open Access 1 | 15113 | Doc Harrington Park | 18177 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.094 | Doc Harrington Park | 0 | Local Park 2 | 4 | |
1968 | 1968 | 1967 | {"type": "Polygon", "coordinates": [[[-122.24109, 37.75354], [-122.2401, 37.75443], [-122.23818, 37.75321], [-122.2392, 37.7522], [-122.24109, 37.75354]]]} | Open Access 1 | 15123 | Krusi Park | 20727 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.492 | Krusi Park | 2000 | Local Park 2 | 4 | |
1969 | 1969 | 1968 | {"type": "Polygon", "coordinates": [[[-122.23152, 37.75852], [-122.2309, 37.75909], [-122.22784, 37.75697], [-122.22846, 37.75639], [-122.23152, 37.75852]]]} | Open Access 1 | 15126 | Lincoln Park | 21260 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 7.412 | Lincoln Park | 0 | Local Park 2 | 4 | |
3429 | 3429 | 3428 | {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28707, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | 48739 | Estuary Park | 33465 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | Alameda 17 | 7.72 | Estuary Park | 2017 | Local Park 2 | 4 |
4062 | 4062 | 4061 | {"type": "Polygon", "coordinates": [[[-122.30734, 37.78918], [-122.30729, 37.7897], [-122.30701, 37.78969], [-122.30686, 37.78973], [-122.30677, 37.78959], [-122.3068, 37.78922], [-122.30689, 37.78916], [-122.30734, 37.78918]]]} | Open Access 1 | 47050 | City View Skate Park | 30700 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 0.667 | City View Skate Park | 0 | Local Recreation Area 3 | 4 | |
4101 | 4101 | 4100 | {"type": "Polygon", "coordinates": [[[-122.2971, 37.78993], [-122.29707, 37.79023], [-122.29505, 37.79057], [-122.29505, 37.78997], [-122.29569, 37.79], [-122.29571, 37.78985], [-122.2971, 37.78993]]]} | Open Access 1 | 47052 | Main Street Dog Park | 30702 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 2.363 | Main Street Dog Park | 0 | Local Park 2 | 4 | |
4104 | 4104 | 4103 | {"type": "Polygon", "coordinates": [[[-122.28814, 37.78267], [-122.28814, 37.78306], [-122.28666, 37.78304], [-122.28669, 37.78184], [-122.28791, 37.78185], [-122.28808, 37.78232], [-122.28799, 37.78241], [-122.28798, 37.78247], [-122.28798, 37.78253], [-122.28804, 37.78262], [-122.28814, 37.78267]]]} | Open Access 1 | 47045 | Bayport Park | 30695 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.003 | Bayport Park | 0 | Local Park 2 | 4 | |
4107 | 4107 | 4106 | {"type": "Polygon", "coordinates": [[[-122.30486, 37.78899], [-122.30487, 37.78905], [-122.3047, 37.79053], [-122.30344, 37.79025], [-122.30345, 37.79004], [-122.30357, 37.79001], [-122.30361, 37.78948], [-122.30357, 37.78946], [-122.30359, 37.7889], [-122.30486, 37.78899]]]} | Open Access 1 | 47048 | Multipurpose Field | 30698 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 4.381 | Multipurpose Field | 0 | Local Recreation Area 3 | 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]);