units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,524 rows where MNG_AG_TYP = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- Oakland, City of 122
- Irvine, City of 101
- Fresno, City of 95
- Modesto, City of 85
- Santa Rosa, City of 83
- Stockton, City of 81
- Napa, City of 81
- Huntington Beach, City of 76
- Torrance, City of 73
- Tracy, City of 73
- Santa Cruz, City of 72
- Chula Vista, City of 70
- Brentwood, City of 68
- Poway, City of 67
- San Luis Obispo, City of 66
- Newport Beach, City of 65
- Davis, City of 65
- Santa Barbara, City of 64
- Clovis, City of 62
- Glendale, City of 61
- Riverside, City of 61
- Bakersfield, City of 61
- …
DES_TP >30
- Local Park 7,469
- Local Recreation Area 1,440
- Local Other or Unknown 660
- Local Conservation Area 143
- Local Historic or Cultural Area 37
- Local Resource Management Area 6
- National Monument or Landmark 5
- 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
- None 1
- …
ACCESS_TYP 4
- Open Access 9,905
- Restricted Access 363
- No Public Access 207
- Unknown Access 29
MNG_AG_TYP 1
- City Agency · 10,504 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6151 | 6151 | 6150 | {"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 | 48342 | Dorris Park | 32906 | 1699 | Dorris, City of 829 | City 2 | City Agency 2 | City 2 | 1699 | Dorris, City of 809 | City 2 | City Agency 2 | Siskiyou 28 | 0.509 | Dorris Park | 0 | Local Park 2 | 4 | ||
7869 | 7869 | 7868 | {"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 | 9869 | Floyd Rice Park | 18965 | 1017 | Avenal, City of 735 | City 2 | City Agency 2 | City 2 | 1017 | Avenal, City of 719 | City 2 | City Agency 2 | Kings 44 | 4.787 | Floyd Rice Park | 0 | Local Park 2 | 4 | ||
8372 | 8372 | 8371 | {"type": "Polygon", "coordinates": [[[-121.13806, 36.21648], [-121.13809, 36.21658], [-121.13804, 36.21705], [-121.138, 36.21722], [-121.13792, 36.21739], [-121.13781, 36.21754], [-121.13767, 36.21767], [-121.13751, 36.21779], [-121.13718, 36.21797], [-121.13712, 36.21799], [-121.13705, 36.21799], [-121.13694, 36.21794], [-121.13639, 36.21725], [-121.13787, 36.21647], [-121.13806, 36.21648]]]} | Open Access 1 | 48506 | CreekBridge Baseball Park | 33217 | 7033 | Creekbridge Homes LLC 892 | Private 7 | Home Owners Association 16 | Private 14 | 1152 | King City, City of 473 | City 2 | City Agency 2 | Monterey 14 | 3.565 | CreekBridge Baseball Park | 0 | Local Park 2 | 4 | ||
11154 | 11154 | 11153 | {"type": "Polygon", "coordinates": [[[-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79644, 33.7006], [-117.79664, 33.7004], [-117.79662, 33.70038], [-117.79668, 33.70036], [-117.79698, 33.70006]]]} | Open Access 1 | 48692 | Flagstone Park | 18936 | 6033 | Windwood Homeowners Association 926 | Private 7 | Home Owners Association 16 | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 0.248 | Flagstone Park | 0 | Local Park 2 | 4 | ||
11164 | 11164 | 11163 | {"type": "Polygon", "coordinates": [[[-118.34615, 34.09177], [-118.34615, 34.09186], [-118.34569, 34.09186], [-118.3457, 34.09177], [-118.34615, 34.09177]]]} | Open Access 1 | 47993 | Formosa Park | 32414 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | https://www.weho.org/Home/Components/FacilityDirectory/FacilityDirectory/17/773 | Los Angeles 6 | 0.105 | Formosa Park | 2008 | Local Park 2 | 4 | |
13144 | 13144 | 13143 | {"type": "Polygon", "coordinates": [[[-117.6363, 33.4373], [-117.63625, 33.43732], [-117.63621, 33.43736], [-117.63622, 33.43744], [-117.63619, 33.43747], [-117.63618, 33.43754], [-117.63611, 33.43758], [-117.6361, 33.43765], [-117.636, 33.43768], [-117.63601, 33.43753], [-117.63591, 33.4373], [-117.63591, 33.43715], [-117.63589, 33.4371], [-117.6358, 33.43706], [-117.6357, 33.43709], [-117.63566, 33.43715], [-117.63567, 33.4372], [-117.6357, 33.43723], [-117.63547, 33.43703], [-117.63541, 33.437], [-117.63532, 33.43699], [-117.63532, 33.43695], [-117.63553, 33.43688], [-117.63566, 33.43668], [-117.6357, 33.43666], [-117.63577, 33.43667], [-117.63585, 33.43672], [-117.63594, 33.43687], [-117.63593, 33.43698], [-117.63596, 33.43709], [-117.63593, 33.43725], [-117.63595, 33.43735], [-117.63598, 33.43737], [-117.63604, 33.43735], [-117.6362, 33.43724], [-117.63627, 33.43727], [-117.6363, 33.4373]]]} | Open Access 1 | 48825 | Vista Del Sol Park | 33544 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/175/2553?npage=2 | Orange 3 | 0.637 | Vista Del Sol Park | 0 | Local Park 2 | 4 | |
13147 | 13147 | 13146 | {"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 | 35256 | Guadalupe holding 7 | 19552 | 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.158 | Guadalupe holding 7 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
13544 | 13544 | 13543 | {"type": "Polygon", "coordinates": [[[-117.63464, 33.44433], [-117.63368, 33.44513], [-117.63359, 33.44529], [-117.63357, 33.44527], [-117.63343, 33.44529], [-117.63333, 33.44533], [-117.63317, 33.44552], [-117.63307, 33.44557], [-117.63301, 33.44552], [-117.63294, 33.44537], [-117.63296, 33.44526], [-117.63278, 33.44448], [-117.63247, 33.44421], [-117.63228, 33.44418], [-117.63214, 33.44405], [-117.63214, 33.444], [-117.63222, 33.44385], [-117.63236, 33.44332], [-117.6324, 33.44296], [-117.63253, 33.44286], [-117.63261, 33.44289], [-117.63314, 33.4433], [-117.63313, 33.44335], [-117.63427, 33.4443], [-117.63438, 33.44434], [-117.63448, 33.44433], [-117.63456, 33.44428], [-117.63464, 33.44433]]]} | Open Access 1 | 48827 | Jim Johnson Memorial Sports Park | 33546 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/187/2783 | Orange 3 | 7.375 | Jim Johnson Memorial Sports Park | 0 | Local Recreation Area 3 | 4 | |
13701 | 13701 | 13700 | {"type": "MultiPolygon", "coordinates": [[[[-117.63252, 33.4339], [-117.63259, 33.43393], [-117.63262, 33.43399], [-117.63263, 33.43406], [-117.63262, 33.43414], [-117.63251, 33.43429], [-117.63248, 33.43427], [-117.63244, 33.43427], [-117.63226, 33.43438], [-117.6319, 33.43429], [-117.63182, 33.43432], [-117.63142, 33.43433], [-117.63138, 33.43432], [-117.63136, 33.43428], [-117.6312, 33.43434], [-117.63105, 33.43432], [-117.63095, 33.43434], [-117.63103, 33.43432], [-117.63107, 33.43427], [-117.63109, 33.43427], [-117.63111, 33.43423], [-117.63109, 33.43416], [-117.63125, 33.43393], [-117.63252, 33.4339]]], [[[-117.63431, 33.44132], [-117.6342, 33.44142], [-117.63397, 33.44124], [-117.63408, 33.44114], [-117.63431, 33.44132]]]]} | Open Access 1 | 48828 | Pico Park | 33547 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/177/2783 | Orange 3 | 1.598 | Pico Park | 0 | Local Park 2 | 4 | |
13710 | 13710 | 13709 | {"type": "Polygon", "coordinates": [[[-117.63508, 33.43915], [-117.63504, 33.43931], [-117.63483, 33.43958], [-117.6348, 33.43975], [-117.63483, 33.43992], [-117.63482, 33.43996], [-117.6348, 33.43996], [-117.63467, 33.43984], [-117.63463, 33.43977], [-117.63447, 33.43944], [-117.63446, 33.43937], [-117.63453, 33.43926], [-117.63476, 33.43918], [-117.63492, 33.4391], [-117.63508, 33.43915]]]} | Open Access 1 | 48829 | Canyon View Park | 33548 | 6132 | Marblehead Development Partners LLC 1045 | Private 7 | Home Owners Association 16 | Private 14 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/173/2783 | Orange 3 | 0.667 | Canyon View Park | 0 | Local Park 2 | 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 | ||
15168 | 15168 | 15167 | {"type": "Polygon", "coordinates": [[[-118.32353, 33.34225], [-118.32381, 33.34224], [-118.32377, 33.34263], [-118.32321, 33.34256], [-118.32326, 33.34241], [-118.32332, 33.34234], [-118.32339, 33.34229], [-118.32353, 33.34225]]]} | Open Access 1 | 46018 | Avalon City Park | 29343 | 6013 | Northwood II Community Association 1139 | Private 7 | Home Owners Association 16 | Private 14 | 1016 | Avalon, City of 327 | City 2 | City Agency 2 | Los Angeles 6 | 0.445 | Avalon City Park | 0 | Local Park 2 | 4 | ||
15256 | 15256 | 15255 | {"type": "MultiPolygon", "coordinates": [[[[-118.109, 33.88327], [-118.10866, 33.88327], [-118.10866, 33.88309], [-118.109, 33.88308], [-118.109, 33.88327]]], [[[-118.10902, 33.88416], [-118.10866, 33.88416], [-118.10866, 33.8838], [-118.10901, 33.8838], [-118.10902, 33.88416]]]]} | Open Access 1 | 46312 | Caruthers Park North | 29601 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 1024 | Bellflower, City of 443 | City 2 | City Agency 2 | https://www.bellflower.org/home/index.asp?page=132 | Los Angeles 6 | 0.48 | Caruthers Park North | 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]);