units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
210 rows where ACCESS_TYP = 2 and DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Whittier, City of 20
- Los Angeles Unified School District 13
- San Ramon, City of 11
- East Bay Regional Park District 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Los Angeles, City of 6
- Beverly Hills, City of 5
- Fullerton, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Azusa Unified School District 4
- Carlsbad, City of 3
- Vacaville, City of 3
- Hollister, City of 3
- Palmdale, City of 3
- Hayward Area Recreation and Park District 3
- Pasadena, City of 3
- Mountain View, City of 3
- San Diego, City of 2
- Los Angeles, County of 2
- Garden Grove, City of 2
- Glendora, City of 2
- Oceanside, City of 2
- Orange, County of 2
- Lake Elsinore, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- Sierra Madre, City of 2
- Conejo Valley Unified School District 2
- …
MNG_AG_TYP 7
DES_TP 1
- Local Park · 190 ✖
ACCESS_TYP 1
- Restricted Access · 190 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3663 | 3663 | 3662 | {"type": "Polygon", "coordinates": [[[-118.35756, 33.87843], [-118.35626, 33.87843], [-118.35625, 33.87755], [-118.3565, 33.87755], [-118.35651, 33.87731], [-118.35663, 33.87731], [-118.35663, 33.87709], [-118.35756, 33.87709], [-118.35756, 33.87843]]]} | Restricted Access 2 | 44123 | William Green Park | 27544 | 2396 | Lawndale Elementary School District 670 | Special District 4 | School District 14 | http://www.lawndale.k12.ca.us/ | Special District 4 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ASSETS/PDF/Parks/williamgreenpark.pdf | Los Angeles 6 | 4.064 | William Green Park | 0 | Local Park 2 | 4 |
3757 | 3757 | 3756 | {"type": "Polygon", "coordinates": [[[-122.27111, 38.04044], [-122.26883, 38.04296], [-122.26793, 38.04407], [-122.26606, 38.04552], [-122.26345, 38.04303], [-122.26441, 38.04222], [-122.26428, 38.04211], [-122.26434, 38.04207], [-122.26434, 38.04205], [-122.26428, 38.042], [-122.26421, 38.04204], [-122.26333, 38.04124], [-122.26342, 38.04109], [-122.26365, 38.0408], [-122.26384, 38.04059], [-122.26413, 38.04034], [-122.26445, 38.04011], [-122.2648, 38.03991], [-122.26517, 38.03974], [-122.26694, 38.04149], [-122.27043, 38.0391], [-122.27111, 38.04044]]]} | Restricted Access 2 | 466 | San Pablo Bay Regional Shoreline | 24966 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 57.631 | San Pablo Bay Reg. Shoreline | 1976 | Local Park 2 | 4 | |
3922 | 3922 | 3921 | {"type": "Polygon", "coordinates": [[[-118.17903, 34.59426], [-118.17429, 34.59426], [-118.17423, 34.59106], [-118.17426, 34.59084], [-118.17426, 34.59041], [-118.17434, 34.59034], [-118.17507, 34.59036], [-118.17509, 34.59034], [-118.17895, 34.59035], [-118.17903, 34.59426]]]} | Restricted Access 2 | 46141 | Highland High School Park | 31877 | 2388 | Antelope Valley Union High School District 698 | Special District 4 | School District 14 | http://www.avdistrict.org/ | Special District 4 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | Los Angeles 6 | 46.587 | Highland High School Park | 0 | Local Park 2 | 4 | |
3932 | 3932 | 3931 | {"type": "Polygon", "coordinates": [[[-118.4757, 34.42905], [-118.47423, 34.42905], [-118.4742, 34.42839], [-118.47412, 34.42835], [-118.47409, 34.42733], [-118.47558, 34.42732], [-118.47558, 34.42796], [-118.47557, 34.42802], [-118.47558, 34.42841], [-118.47568, 34.42842], [-118.4757, 34.42905]]]} | Restricted Access 2 | 46226 | North Oaks Park | 31633 | 2389 | William S. Hart Union High School District 702 | Special District 4 | School District 14 | http://www.hartdistrict.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=413 | Los Angeles 6 | 6.399 | North Oaks 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 | |
3975 | 3975 | 3974 | {"type": "Polygon", "coordinates": [[[-118.01891, 33.96032], [-118.01812, 33.96131], [-118.01618, 33.96022], [-118.01659, 33.95971], [-118.01891, 33.96032]]]} | Restricted Access 2 | 46582 | Ocean View Elementary School Park | 31920 | 2370 | East Whittier City School District 707 | Special District 4 | School District 14 | http://ewcsd.org/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 5.333 | Ocean View Elementary School Park | 0 | Local Park 2 | 4 | |
3978 | 3978 | 3977 | {"type": "Polygon", "coordinates": [[[-118.05658, 34.16669], [-118.05578, 34.16669], [-118.05577, 34.16573], [-118.05657, 34.16571], [-118.05658, 34.16669]]]} | Restricted Access 2 | 46602 | Sierra Madre Elementary School Park | 31924 | 2360 | Pasadena Unified School District 708 | Special District 4 | School District 14 | http://www.pusd.us/pages/PasadenaUSD | Special District 4 | 1333 | Sierra Madre, City of 308 | City 2 | City Agency 2 | Los Angeles 6 | 1.948 | Sierra Madre Elementary School Park | 0 | Local Park 2 | 4 | |
4031 | 4031 | 4030 | {"type": "Polygon", "coordinates": [[[-122.01457, 37.93282], [-122.01322, 37.93363], [-122.01205, 37.93236], [-122.01398, 37.93158], [-122.01414, 37.93182], [-122.01456, 37.93195], [-122.01454, 37.93209], [-122.01455, 37.93222], [-122.01415, 37.93237], [-122.01457, 37.93282]]]} | Restricted Access 2 | 44198 | Valle Verde Park | 26771 | 2317 | Mount Diablo Unified School District 712 | Special District 4 | School District 14 | http://www.mdusd.org/ | Special District 4 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | Contra Costa 12 | 6.862 | Valle Verde Park | 0 | Local Park 2 | 4 | |
4057 | 4057 | 4056 | {"type": "Polygon", "coordinates": [[[-122.40231, 40.58043], [-122.40172, 40.58057], [-122.40131, 40.57969], [-122.40194, 40.57953], [-122.40231, 40.58043]]]} | Restricted Access 2 | 44420 | Magnolia Park | 21676 | 343 | Shasta, County of 717 | County 3 | County Agency 3 | http://www.co.shasta.ca.us/index.aspx | County 3 | 343 | Shasta, County of 700 | County 3 | County Agency 3 | Shasta 27 | 1.399 | Magnolia Park | 0 | Local Park 2 | 4 | |
4067 | 4067 | 4066 | {"type": "Polygon", "coordinates": [[[-121.45978, 38.51394], [-121.45866, 38.51395], [-121.45865, 38.51401], [-121.45764, 38.51401], [-121.45764, 38.5122], [-121.45977, 38.5122], [-121.45978, 38.51394]]]} | Restricted Access 2 | 44414 | Pacific Park | 23303 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.079 | Pacific Park | 0 | Local Park 2 | 4 | |
4203 | 4203 | 4202 | {"type": "Polygon", "coordinates": [[[-122.06282, 37.39283], [-122.06247, 37.39378], [-122.06108, 37.39346], [-122.06133, 37.39277], [-122.06139, 37.39266], [-122.06151, 37.39252], [-122.06282, 37.39283]]]} | Restricted Access 2 | 44932 | Slater School Park | 25552 | 1218 | Mountain View, City of 460 | City 2 | City Agency 2 | http://www.ci.mtnview.ca.us/services/parks/default.asp | City 2 | 1218 | Mountain View, City of 453 | City 2 | City Agency 2 | Santa Clara 19 | 3.482 | Slater School Park | 0 | Local Park 2 | 4 | |
4212 | 4212 | 4211 | {"type": "Polygon", "coordinates": [[[-118.35177, 33.8854], [-118.35106, 33.8854], [-118.35104, 33.88537], [-118.35099, 33.88502], [-118.35116, 33.88502], [-118.35131, 33.88511], [-118.35148, 33.88516], [-118.35162, 33.88518], [-118.35177, 33.88517], [-118.35177, 33.8854]]]} | Restricted Access 2 | 44962 | Dan McKenzie Community Gardens | 29797 | 1172 | Lawndale, City of 484 | City 2 | City Agency 2 | http://www.lawndalecity.org/ | City 2 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/html/depthtml/csd/McKenzieGarden.html | Los Angeles 6 | 0.544 | Dan McKenzie Community Gardens | 0 | Local Park 2 | 4 |
4215 | 4215 | 4214 | {"type": "Polygon", "coordinates": [[[-121.7549, 36.91849], [-121.7545, 36.91871], [-121.75429, 36.91848], [-121.75388, 36.91869], [-121.75349, 36.91824], [-121.75322, 36.91838], [-121.75291, 36.91799], [-121.75268, 36.91773], [-121.75158, 36.91849], [-121.75102, 36.91787], [-121.7528, 36.91657], [-121.75302, 36.91683], [-121.75341, 36.91661], [-121.7542, 36.91753], [-121.7549, 36.91849]]]} | Restricted Access 2 | 44966 | E.A. Hall School Park | 32705 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 9.82 | E.A. Hall 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 | |
4263 | 4263 | 4262 | {"type": "Polygon", "coordinates": [[[-121.37991, 38.65194], [-121.3799, 38.65359], [-121.37973, 38.65357], [-121.37973, 38.65316], [-121.3795, 38.65317], [-121.3795, 38.65353], [-121.37887, 38.65352], [-121.37888, 38.65336], [-121.37887, 38.65335], [-121.37852, 38.65336], [-121.37852, 38.65344], [-121.3775, 38.65342], [-121.3775, 38.65302], [-121.37713, 38.65301], [-121.37715, 38.65196], [-121.37991, 38.65194]]]} | Restricted Access 2 | 47982 | Oakdale Park | 32369 | 2201 | Arcade Creek Recreation and Park District 739 | Special District 4 | Recreation/Parks District 4 | http://www.acrpd.com/ | Special District 4 | 2201 | Arcade Creek Recreation and Park District 724 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 9.4 | Oakdale Park | 0 | Local Park 2 | 4 | |
4264 | 4264 | 4263 | {"type": "Polygon", "coordinates": [[[-118.10522, 34.07637], [-118.10463, 34.07637], [-118.10463, 34.07569], [-118.1044, 34.07568], [-118.10441, 34.07532], [-118.10455, 34.0753], [-118.10521, 34.07529], [-118.10522, 34.07637]]]} | Restricted Access 2 | 45322 | Marshall Community Park | 32836 | 1301 | San Gabriel, City of 740 | City 2 | City Agency 2 | http://www.sangabrielcity.com/ | City 2 | 1301 | San Gabriel, City of 725 | City 2 | City Agency 2 | http://www.sangabrielcity.com/539/Marshall-Park | Los Angeles 6 | 1.81 | Marshall Community Park | 0 | Local Park 2 | 4 |
4298 | 4298 | 4297 | {"type": "MultiPolygon", "coordinates": [[[[-121.97565, 37.70051], [-121.97562, 37.70061], [-121.97543, 37.70073], [-121.97507, 37.70044], [-121.97405, 37.69985], [-121.97434, 37.69948], [-121.9747, 37.69968], [-121.975, 37.69989], [-121.97538, 37.70022], [-121.97565, 37.70051]]], [[[-121.98765, 37.73258], [-121.98688, 37.73201], [-121.97964, 37.7298], [-121.9786, 37.72967], [-121.97859, 37.72783], [-121.97863, 37.72405], [-121.9862, 37.72382], [-121.98624, 37.72657], [-121.98763, 37.72776], [-121.98761, 37.73085], [-121.98765, 37.73258]]]]} | Restricted Access 2 | 45337 | Dublin Hills Regional Park | 18292 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 142.3 | Dublin Hills RP | 0 | Local Park 2 | 4 | |
4318 | 4318 | 4317 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | 48251 | El Dorado Community Gardens | 32803 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 8.255 | El Dorado Community Gardens | 0 | Local Park 2 | 4 | |
4372 | 4372 | 4371 | {"type": "Polygon", "coordinates": [[[-118.22505, 33.96758], [-118.22454, 33.96753], [-118.22448, 33.9675], [-118.22431, 33.96734], [-118.22437, 33.96694], [-118.22436, 33.96693], [-118.22415, 33.96711], [-118.22327, 33.96702], [-118.22323, 33.96723], [-118.22254, 33.96715], [-118.22254, 33.96649], [-118.22474, 33.96672], [-118.22469, 33.96704], [-118.22505, 33.96708], [-118.22505, 33.96758]]]} | Restricted Access 2 | 45864 | Walnut Nature Park | 28911 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.587 | Walnut Nature Park | 0 | Local Park 2 | 4 | |
4386 | 4386 | 4385 | {"type": "Polygon", "coordinates": [[[-117.35693, 33.17681], [-117.35685, 33.17689], [-117.3562, 33.17729], [-117.35652, 33.17766], [-117.35629, 33.17779], [-117.35659, 33.17815], [-117.3568, 33.1783], [-117.3563, 33.1786], [-117.35517, 33.17726], [-117.3566, 33.1764], [-117.35693, 33.17681]]]} | Restricted Access 2 | 45967 | South Oceanside School Park | 31598 | 2100 | Oceanside Unified School District 756 | Special District 4 | School District 14 | http://www.oside.k12.ca.us/ | Special District 4 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#48 | San Diego 4 | 4.254 | South Oceanside 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]);