units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2 sorted by MNG_AG_TYP descending
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY >30
- Los Angeles, City of 314
- San Diego, City of 281
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 118
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 95
- Consumnes Community Services District 92
- Fresno, City of 83
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Mountains Recreation and Conservation Authority 67
- Stockton, City of 67
- Roseville, City of 67
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
ACCESS_TYP 4
- Open Access 9,084
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,376 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11636 | 11636 | 11635 | {"type": "Polygon", "coordinates": [[[-121.39679, 38.62353], [-121.39677, 38.62509], [-121.39471, 38.62507], [-121.39517, 38.62469], [-121.39555, 38.62429], [-121.39587, 38.62388], [-121.3961, 38.62353], [-121.39679, 38.62353]]]} | Open Access 1 | 23963 | Seely Park | 25284 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 4.81 | Seely Park | 0 | Local Park 2 | 4 | |
11666 | 11666 | 11665 | {"type": "Polygon", "coordinates": [[[-121.41459, 38.61315], [-121.41258, 38.61312], [-121.41258, 38.61407], [-121.41181, 38.61406], [-121.41183, 38.61375], [-121.41241, 38.61319], [-121.41241, 38.61267], [-121.41458, 38.6127], [-121.41459, 38.61315]]]} | Open Access 1 | 23972 | Bellview Park | 15992 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 3.545 | Bellview Park | 0 | Local Park 2 | 4 | |
11672 | 11672 | 11671 | {"type": "Polygon", "coordinates": [[[-121.40835, 38.62349], [-121.40616, 38.62348], [-121.40616, 38.62206], [-121.40617, 38.62203], [-121.40621, 38.622], [-121.40625, 38.62199], [-121.40792, 38.622], [-121.40806, 38.62199], [-121.40823, 38.62194], [-121.40835, 38.62213], [-121.40835, 38.62349]]]} | Open Access 1 | 23964 | Bohemian Park | 16233 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 7.793 | Bohemian Park | 0 | Local Park 2 | 4 | |
11679 | 11679 | 11678 | {"type": "Polygon", "coordinates": [[[-121.42753, 38.60727], [-121.4274, 38.60767], [-121.42735, 38.6079], [-121.42733, 38.60801], [-121.42733, 38.60856], [-121.42569, 38.60856], [-121.42568, 38.60844], [-121.42541, 38.60842], [-121.42542, 38.60749], [-121.42547, 38.60723], [-121.42753, 38.60727]]]} | Open Access 1 | 23975 | Babcock Park | 15745 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 6.063 | Babcock Park | 0 | Local Park 2 | 4 | |
11680 | 11680 | 11679 | {"type": "Polygon", "coordinates": [[[-121.41056, 38.60659], [-121.41056, 38.60714], [-121.40937, 38.60713], [-121.40883, 38.60772], [-121.40883, 38.60803], [-121.40837, 38.60803], [-121.40837, 38.60806], [-121.40809, 38.60806], [-121.40808, 38.60814], [-121.40684, 38.60813], [-121.40629, 38.60794], [-121.40621, 38.60778], [-121.40835, 38.60733], [-121.40838, 38.60712], [-121.40905, 38.60713], [-121.40905, 38.60699], [-121.40893, 38.60687], [-121.40899, 38.60681], [-121.40901, 38.60677], [-121.409, 38.60673], [-121.40887, 38.60658], [-121.4092, 38.60658], [-121.40962, 38.60669], [-121.41022, 38.60659], [-121.41056, 38.60659]]]} | Open Access 1 | 23976 | Santa Anita Park | 25036 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 6.072 | Santa Anita Park | 0 | Local Park 2 | 4 | |
11684 | 11684 | 11683 | {"type": "Polygon", "coordinates": [[[-121.39391, 38.60316], [-121.3939, 38.60535], [-121.39175, 38.60532], [-121.39174, 38.60496], [-121.39056, 38.60494], [-121.39049, 38.60483], [-121.39047, 38.60352], [-121.39089, 38.60353], [-121.39089, 38.60343], [-121.39165, 38.60344], [-121.39166, 38.60313], [-121.39391, 38.60316]]]} | Open Access 1 | 23979 | Cottage Park | 17682 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 15.826 | Cottage Park | 0 | Local Park 2 | 4 | |
13663 | 13663 | 13662 | {"type": "Polygon", "coordinates": [[[-121.41513, 38.6044], [-121.41511, 38.60441], [-121.41512, 38.60684], [-121.41298, 38.60682], [-121.41298, 38.60718], [-121.41077, 38.60714], [-121.41077, 38.6036], [-121.41497, 38.60368], [-121.41497, 38.60412], [-121.41513, 38.60413], [-121.41513, 38.6044]]]} | Open Access 1 | 36029 | Howe Park | 20125 | 2192 | Fulton - El Camino 984 | Special District 4 | Special District - Other 26 | http://www.fecrecpark.com/index.htm | Special District 4 | 2192 | Fulton - El Camino 948 | Special District 4 | Special District - Other 24 | Sacramento 41 | 34.701 | Howe Park | 0 | Local Park 2 | 4 | |
14989 | 14989 | 14988 | {"type": "Polygon", "coordinates": [[[-117.3355, 34.59883], [-117.33556, 34.59885], [-117.33599, 34.59944], [-117.33599, 34.5995], [-117.33454, 34.60022], [-117.3345, 34.60023], [-117.33446, 34.60022], [-117.33402, 34.59962], [-117.33402, 34.59956], [-117.3355, 34.59883]]]} | Open Access 1 | 45634 | Oro Grande Park | 28514 | 2355 | County Service Area 42 1132 | Special District 4 | Special District - Other 26 | http://specialdistricts.org/index.aspx?page=404 | Special District 4 | 2355 | County Service Area 42 1087 | Special District 4 | Special District - Other 24 | San Bernardino 22 | 3.531 | Oro Grande Park | 0 | Local Park 2 | 4 | |
15011 | 15011 | 15010 | {"type": "Polygon", "coordinates": [[[-118.81765, 36.13081], [-118.81735, 36.13107], [-118.81709, 36.13088], [-118.81696, 36.13099], [-118.81693, 36.13097], [-118.81688, 36.13102], [-118.81664, 36.13084], [-118.81712, 36.13041], [-118.81765, 36.13081]]]} | Open Access 1 | 45663 | Springville Veterans Memorial Park | 28480 | 2353 | Springville Memorial District 1133 | Special District 4 | Special District - Other 26 | Special District 4 | 2353 | Springville Memorial District 1088 | Special District 4 | Special District - Other 24 | Tulare 29 | 0.831 | Springville Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
14978 | 14978 | 14977 | {"type": "Polygon", "coordinates": [[[-121.50878, 38.25131], [-121.50859, 38.25132], [-121.50676, 38.25202], [-121.50797, 38.25004], [-121.5081, 38.2501], [-121.50805, 38.25044], [-121.5081, 38.2506], [-121.50859, 38.25106], [-121.50862, 38.25117], [-121.50878, 38.25131]]]} | Open Access 1 | 45599 | Locke Boarding House Park | 28425 | 2349 | Sacramento Housing and Redevelopment Agency 1129 | Joint 8 | Joint Powers Authority 24 | http://www.shra.org/ | Special District 4 | 2349 | Sacramento Housing and Redevelopment Agency 1084 | Joint 8 | Joint Powers Authority 23 | Sacramento 41 | 3.349 | Locke Boarding House Park | 0 | Local Park 2 | 4 | |
2245 | 2245 | 2244 | {"type": "Polygon", "coordinates": [[[-118.84354, 34.17707], [-118.84327, 34.17764], [-118.84313, 34.17791], [-118.84297, 34.17808], [-118.84271, 34.178], [-118.84174, 34.17697], [-118.84123, 34.17723], [-118.84141, 34.17751], [-118.84091, 34.17775], [-118.84047, 34.17714], [-118.84173, 34.17649], [-118.84228, 34.17687], [-118.84243, 34.17692], [-118.84354, 34.17707]]]} | Restricted Access 2 | 18017 | Beyer Park | 31603 | 2026 | Conejo Valley Unified School District 501 | Special District 4 | School District 14 | http://www.conejo.k12.ca.us/ | Special District 4 | 2026 | Conejo Valley Unified School District 493 | Special District 4 | School District 21 | Ventura 8 | 5.138 | Beyer Park | 0 | Local Park 2 | 4 | |
3314 | 3314 | 3313 | {"type": "Polygon", "coordinates": [[[-118.64407, 34.17777], [-118.64325, 34.17777], [-118.64319, 34.17773], [-118.64316, 34.17565], [-118.6432, 34.1756], [-118.64385, 34.17559], [-118.64406, 34.17557], [-118.64407, 34.17777]]]} | Restricted Access 2 | 46863 | Hale Middle School Park | 31933 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 4.875 | Hale Middle School Park | 0 | Local Park 2 | 4 | |
3315 | 3315 | 3314 | {"type": "Polygon", "coordinates": [[[-118.64398, 34.17228], [-118.64364, 34.17254], [-118.64342, 34.17277], [-118.64336, 34.17279], [-118.64174, 34.17195], [-118.64141, 34.17184], [-118.64117, 34.17179], [-118.64091, 34.17176], [-118.64087, 34.17171], [-118.64087, 34.17063], [-118.64304, 34.17156], [-118.64323, 34.17156], [-118.64367, 34.17194], [-118.64398, 34.17228]]]} | Restricted Access 2 | 46867 | El Camino Real High School Park | 31936 | 2361 | Los Angeles Unified School District 616 | Special District 4 | School District 14 | http://home.lausd.net/ | Special District 4 | 2361 | Los Angeles Unified School District 605 | Special District 4 | School District 21 | Los Angeles 6 | 7.345 | El Camino Real High School Park | 0 | Local Park 2 | 4 | |
3963 | 3963 | 3962 | {"type": "Polygon", "coordinates": [[[-118.10299, 34.1077], [-118.1021, 34.1077], [-118.10206, 34.10769], [-118.10203, 34.1063], [-118.10278, 34.10629], [-118.10278, 34.10728], [-118.10298, 34.10729], [-118.10299, 34.1077]]]} | Restricted Access 2 | 46471 | Washington School Park | 32680 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 2393 | San Gabriel Unified School District 693 | Special District 4 | School District 21 | Los Angeles 6 | 2.827 | Washington School Park | 0 | Local Park 2 | 4 | |
4236 | 4236 | 4235 | {"type": "Polygon", "coordinates": [[[-117.89955, 34.13086], [-117.89865, 34.13086], [-117.89864, 34.13131], [-117.89633, 34.1313], [-117.89633, 34.13075], [-117.89641, 34.13075], [-117.8965, 34.13064], [-117.89807, 34.12999], [-117.89819, 34.12996], [-117.89829, 34.1299], [-117.89904, 34.1299], [-117.89906, 34.13045], [-117.89953, 34.13046], [-117.89955, 34.13086]]]} | Restricted Access 2 | 47860 | Charles Lee Elementary School Park | 31944 | 2365 | Azusa Unified School District 736 | Special District 4 | School District 14 | https://ausd-ca.schoolloop.com/ | Special District 4 | 2365 | Azusa Unified School District 720 | Special District 4 | School District 21 | Los Angeles 6 | 7.662 | Charles Lee Elementary School Park | 0 | Local Park 2 | 4 | |
6509 | 6509 | 6508 | {"type": "Polygon", "coordinates": [[[-118.8506, 34.24115], [-118.85027, 34.24136], [-118.84991, 34.24147], [-118.84796, 34.24131], [-118.84799, 34.24055], [-118.84755, 34.24005], [-118.84838, 34.23945], [-118.84862, 34.23965], [-118.84898, 34.23985], [-118.84953, 34.2401], [-118.84993, 34.24033], [-118.85027, 34.24067], [-118.8506, 34.24115]]]} | Restricted Access 2 | 2495 | Canada Park | 31606 | 2026 | Conejo Valley Unified School District 501 | Special District 4 | School District 14 | http://www.conejo.k12.ca.us/ | Special District 4 | 2026 | Conejo Valley Unified School District 493 | Special District 4 | School District 21 | Ventura 8 | 9.09 | Canada Park | 0 | Local Park 2 | 4 | |
9694 | 9694 | 9693 | {"type": "Polygon", "coordinates": [[[-117.9018, 34.13808], [-117.9011, 34.13804], [-117.90114, 34.13892], [-117.89971, 34.13891], [-117.89972, 34.13725], [-117.90091, 34.13731], [-117.90091, 34.13764], [-117.90178, 34.13764], [-117.9018, 34.13808]]]} | Restricted Access 2 | 47859 | Dalton Elementary School Park | 31943 | 2365 | Azusa Unified School District 736 | Special District 4 | School District 14 | https://ausd-ca.schoolloop.com/ | Special District 4 | 2365 | Azusa Unified School District 720 | Special District 4 | School District 21 | Los Angeles 6 | 6.301 | Dalton Elementary School Park | 0 | Local Park 2 | 4 | |
9696 | 9696 | 9695 | {"type": "Polygon", "coordinates": [[[-117.99846, 33.91409], [-117.99722, 33.91503], [-117.99693, 33.91519], [-117.99664, 33.9153], [-117.99651, 33.91534], [-117.99616, 33.91537], [-117.99445, 33.91539], [-117.99442, 33.91319], [-117.99449, 33.91314], [-117.9955, 33.91313], [-117.99551, 33.91328], [-117.99564, 33.91327], [-117.99564, 33.91353], [-117.99557, 33.91354], [-117.99556, 33.91381], [-117.99565, 33.91381], [-117.99567, 33.91413], [-117.99623, 33.91412], [-117.99624, 33.91418], [-117.99629, 33.91419], [-117.99636, 33.91434], [-117.99676, 33.91415], [-117.99666, 33.91396], [-117.99716, 33.91371], [-117.99727, 33.91386], [-117.99741, 33.91379], [-117.99741, 33.91373], [-117.99758, 33.91367], [-117.99742, 33.91337], [-117.99773, 33.91325], [-117.9983, 33.91344], [-117.99833, 33.91366], [-117.99846, 33.91409]]]} | Restricted Access 2 | 47861 | Benton Middle School Park | 31848 | 2417 | Norwalk La Mirada Unified School District 919 | Special District 4 | School District 14 | https://www.nlmusd.org/ | Special District 4 | 2417 | Norwalk La Mirada Unified School District 892 | Special District 4 | School District 21 | Los Angeles 6 | 15.056 | Benton Middle School Park | 0 | Local Park 2 | 4 | |
9697 | 9697 | 9696 | {"type": "Polygon", "coordinates": [[[-118.06854, 33.96506], [-118.06786, 33.96522], [-118.06772, 33.96583], [-118.06704, 33.96582], [-118.06704, 33.96591], [-118.06669, 33.96591], [-118.06667, 33.9658], [-118.06616, 33.96578], [-118.06653, 33.96476], [-118.06654, 33.96478], [-118.06732, 33.9648], [-118.06733, 33.96478], [-118.06851, 33.96481], [-118.06854, 33.96506]]]} | Restricted Access 2 | 47862 | Aeolian Elementary School Park | 31844 | 2376 | Los Nietos School District 920 | Special District 4 | School District 14 | http://www.losnietos.k12.ca.us/ | Special District 4 | 2376 | Los Nietos School District 893 | Special District 4 | School District 21 | Los Angeles 6 | 4.508 | Aeolian Elementary School Park | 0 | Local Park 2 | 4 | |
9724 | 9724 | 9723 | {"type": "Polygon", "coordinates": [[[-118.0761, 33.96475], [-118.0759, 33.96532], [-118.07581, 33.96536], [-118.07425, 33.965], [-118.07349, 33.96488], [-118.07357, 33.96454], [-118.07358, 33.96438], [-118.07335, 33.96435], [-118.07294, 33.96434], [-118.07307, 33.96347], [-118.07313, 33.96345], [-118.07381, 33.96344], [-118.07369, 33.96395], [-118.07429, 33.96406], [-118.07422, 33.96432], [-118.0761, 33.96475]]]} | Restricted Access 2 | 47865 | Los Nietos Middle School Park | 31945 | 2376 | Los Nietos School District 920 | Special District 4 | School District 14 | http://www.losnietos.k12.ca.us/ | Special District 4 | 2376 | Los Nietos School District 893 | Special District 4 | School District 21 | Los Angeles 6 | 6.183 | Los Nietos Middle School 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]);