units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
363 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by AGNCY_WEB descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, GAP_STS
MNG_AGENCY >30
- Los Angeles, City of 20
- Whittier, City of 20
- San Ramon, City of 15
- San Diego, City of 10
- Long Beach, City of 9
- Arcadia, City of 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Modesto, City of 7
- San Jose, City of 6
- Carlsbad, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Vacaville, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Glendora, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- San Luis Obispo, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- …
DES_TP >30
- Local Recreation Area 168
- Local Park 151
- Local Conservation Area 10
- Local Other or Unknown 6
- Local Historic or Cultural Area 2
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 1
- City Agency · 363 ✖
ACCESS_TYP 1
- Restricted Access · 363 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10863 | 10863 | 10862 | {"type": "Polygon", "coordinates": [[[-118.82414, 34.0228], [-118.82415, 34.02343], [-118.8242, 34.02514], [-118.82383, 34.02594], [-118.82355, 34.02636], [-118.82309, 34.02697], [-118.8214, 34.02658], [-118.82087, 34.0264], [-118.82069, 34.02541], [-118.82061, 34.02514], [-118.82048, 34.02484], [-118.82045, 34.02472], [-118.82044, 34.02459], [-118.82046, 34.02446], [-118.82054, 34.02429], [-118.82093, 34.02387], [-118.82105, 34.02371], [-118.82121, 34.02343], [-118.82192, 34.02391], [-118.82243, 34.02344], [-118.8217, 34.02273], [-118.82181, 34.0226], [-118.82192, 34.0225], [-118.82258, 34.02203], [-118.82271, 34.02189], [-118.82412, 34.02284], [-118.82414, 34.02283], [-118.82414, 34.0228]]]} | Restricted Access 2 | 20661 | Malibu Equestrian Park | 32834 | 2423 | Santa Monica-Malibu Unified School District 960 | Special District 4 | School District 14 | www.smmusd.org | Special District 4 | 1193 | Malibu, City of 928 | City 2 | City Agency 2 | Los Angeles 6 | 32.463 | Malibu Equestrian Park | 0 | Local Recreation Area 3 | 4 | |
4166 | 4166 | 4165 | {"type": "Polygon", "coordinates": [[[-121.07771, 39.22081], [-121.07676, 39.22153], [-121.07673, 39.22149], [-121.07655, 39.22152], [-121.07648, 39.22148], [-121.07549, 39.22233], [-121.07527, 39.22221], [-121.07499, 39.22212], [-121.07443, 39.22199], [-121.07444, 39.22102], [-121.07552, 39.22103], [-121.07557, 39.22092], [-121.07556, 39.22075], [-121.07569, 39.22072], [-121.07668, 39.22003], [-121.07771, 39.22081]]]} | Restricted Access 2 | 48291 | Margaret G Scotten School Ballfields | 32866 | 2429 | Grass Valley School District 728 | Special District 4 | School District 14 | www.gvsd.us | Special District 4 | 1673 | Grass Valley, City of 712 | City 2 | City Agency 2 | Nevada 30 | 8.566 | Margaret G Scotten School Ballfields | 2018 | None 361 | ||
3237 | 3237 | 3236 | {"type": "MultiPolygon", "coordinates": [[[[-115.58465, 32.79644], [-115.5824, 32.79643], [-115.58235, 32.79448], [-115.58464, 32.79447], [-115.58465, 32.79644]]], [[[-115.58623, 32.79447], [-115.58623, 32.79645], [-115.58486, 32.79644], [-115.58485, 32.79446], [-115.58623, 32.79447]]]]} | Restricted Access 2 | 48110 | Sunflower Park | 32835 | 2422 | El Centro Elementary School District 602 | Special District 4 | School District 14 | www.ecesd.org | Special District 4 | 1093 | El Centro, City of 92 | City 2 | City Agency 2 | http://www.cityofelcentro.org | Imperial 20 | 18.451 | Sunflower Park | 2000 | Local Park 2 | 4 |
15695 | 15695 | 15694 | {"type": "Polygon", "coordinates": [[[-114.6039, 34.84393], [-114.60287, 34.84392], [-114.60287, 34.84339], [-114.6039, 34.84339], [-114.6039, 34.84393]]]} | Restricted Access 2 | 49074 | River's Edge Golf Course | 33774 | 2442 | Needles Unified School District 1161 | Special District 4 | School District 14 | https://www.needlesusd.org/ | Special District 4 | 1220 | Needles, City of 276 | City 2 | City Agency 2 | http://cityofneedles.com/services/rivers-edge-golf-course/ | San Bernardino 22 | 1.368 | River's Edge GC | 0 | Local Recreation Area 3 | 4 |
2890 | 2890 | 2889 | {"type": "Polygon", "coordinates": [[[-121.39678, 36.84126], [-121.39678, 36.84159], [-121.39616, 36.84157], [-121.39614, 36.84183], [-121.39515, 36.8418], [-121.39507, 36.842], [-121.39507, 36.84215], [-121.39527, 36.84217], [-121.39527, 36.84247], [-121.39543, 36.84248], [-121.39542, 36.84336], [-121.39404, 36.84334], [-121.39252, 36.84106], [-121.39624, 36.84113], [-121.39633, 36.8412], [-121.39644, 36.84126], [-121.39678, 36.84126]]]} | Restricted Access 2 | 18924 | Rancho San Justo Sports Complex | 32730 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 13.179 | Rancho San Justo Sports Complex | 0 | Local Recreation Area 3 | 4 | |
3290 | 3290 | 3289 | {"type": "Polygon", "coordinates": [[[-121.39236, 36.82838], [-121.39233, 36.82946], [-121.39215, 36.82958], [-121.39084, 36.82955], [-121.3909, 36.8283], [-121.39236, 36.82838]]]} | Restricted Access 2 | 48200 | Ladd Lane School Park | 32765 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 4.424 | Ladd Lane School Park | 0 | Local Park 2 | 4 | |
6226 | 6226 | 6225 | {"type": "Polygon", "coordinates": [[[-121.37339, 36.82911], [-121.37285, 36.82909], [-121.37285, 36.82903], [-121.37278, 36.82902], [-121.37207, 36.82902], [-121.37206, 36.82921], [-121.37191, 36.82922], [-121.3719, 36.82957], [-121.37204, 36.82957], [-121.37203, 36.82976], [-121.37222, 36.82978], [-121.3722, 36.82988], [-121.37101, 36.82984], [-121.37093, 36.82991], [-121.37094, 36.83008], [-121.37077, 36.83008], [-121.37086, 36.82825], [-121.3734, 36.82827], [-121.37344, 36.8283], [-121.37345, 36.82833], [-121.37344, 36.82867], [-121.37339, 36.82911]]]} | Restricted Access 2 | 48357 | Cerra Vista School Park | 32923 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 7.458 | Cerra Vista School Park | 0 | Local Park 2 | 4 |
11439 | 11439 | 11438 | {"type": "Polygon", "coordinates": [[[-121.41269, 36.84537], [-121.41263, 36.84665], [-121.41135, 36.84659], [-121.41134, 36.84673], [-121.41065, 36.84671], [-121.41073, 36.84529], [-121.41269, 36.84537]]]} | Restricted Access 2 | 48202 | R. O. Hardin School Park | 32844 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 6.377 | R. O. Hardin School Park | 0 | Local Park 2 | 4 | |
11503 | 11503 | 11502 | {"type": "Polygon", "coordinates": [[[-121.38663, 36.85252], [-121.38651, 36.85489], [-121.38407, 36.85481], [-121.38414, 36.85323], [-121.38515, 36.85329], [-121.38551, 36.85316], [-121.38596, 36.8531], [-121.38603, 36.85232], [-121.3862, 36.85233], [-121.38623, 36.85252], [-121.38663, 36.85252]]]} | Restricted Access 2 | 48191 | Marguerite Maze Sports Complex | 32728 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 10.915 | Marguerite Maze Sports Complex | 0 | Local Recreation Area 3 | 4 |
14270 | 14270 | 14269 | {"type": "Polygon", "coordinates": [[[-121.41823, 36.85522], [-121.41821, 36.85579], [-121.41762, 36.85577], [-121.41756, 36.85611], [-121.41681, 36.85613], [-121.41681, 36.85719], [-121.41572, 36.85714], [-121.4157, 36.85711], [-121.41574, 36.85598], [-121.41578, 36.85511], [-121.41823, 36.85522]]]} | Restricted Access 2 | 44193 | Calaveras School Park | 16672 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | San Benito 38 | 8.022 | Calaveras School Park | 0 | Local Park 2 | 4 | |
14065 | 14065 | 14064 | {"type": "Polygon", "coordinates": [[[-116.30359, 33.73308], [-116.30359, 33.73519], [-116.30357, 33.73521], [-116.30275, 33.7352], [-116.30248, 33.73516], [-116.3022, 33.73508], [-116.30193, 33.73495], [-116.30169, 33.73479], [-116.30148, 33.73458], [-116.30134, 33.73438], [-116.30125, 33.73419], [-116.3012, 33.73402], [-116.30118, 33.73389], [-116.30117, 33.73365], [-116.30159, 33.73364], [-116.30181, 33.73349], [-116.30286, 33.73352], [-116.30285, 33.73308], [-116.30359, 33.73308]]]} | Restricted Access 2 | 39073 | Colonel Mitchell Page Middle School Fields | 31608 | 2325 | Desert Sands Unified School District 1071 | Special District 4 | School District 14 | https://www.dsusd.us/ | Special District 4 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | Riverside 10 | 9.692 | Colonel Mitchell Page Middle School Fields | 0 | Local Recreation Area 3 | 4 | |
15171 | 15171 | 15170 | {"type": "Polygon", "coordinates": [[[-117.90331, 34.11113], [-117.90329, 34.11315], [-117.90111, 34.11315], [-117.90112, 34.11113], [-117.90331, 34.11113]]]} | Restricted Access 2 | 46041 | Murray Elementary School Park | 31893 | 2365 | Azusa Unified School District 736 | Special District 4 | School District 14 | https://ausd-ca.schoolloop.com/ | Special District 4 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?nid=1240 | Los Angeles 6 | 11.168 | Murray Elementary School Park | 0 | Local Park 2 | 4 |
15366 | 15366 | 15365 | {"type": "Polygon", "coordinates": [[[-117.99819, 33.95654], [-117.99808, 33.957], [-117.99805, 33.95724], [-117.99805, 33.95742], [-117.99797, 33.95761], [-117.99795, 33.95761], [-117.99766, 33.9579], [-117.99726, 33.95842], [-117.99394, 33.95658], [-117.99393, 33.95522], [-117.99456, 33.95479], [-117.9948, 33.95469], [-117.99819, 33.95654]]]} | Restricted Access 2 | 46562 | La Serna High School Park | 31907 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 22.498 | La Serna High School Park | 0 | Local Park 2 | 4 | |
15367 | 15367 | 15366 | {"type": "Polygon", "coordinates": [[[-118.02225, 33.94131], [-118.02046, 33.94359], [-118.01735, 33.94146], [-118.01943, 33.93937], [-118.02225, 33.94131]]]} | Restricted Access 2 | 46563 | California High School Park | 31908 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 26.421 | California High School Park | 0 | Local Park 2 | 4 | |
15368 | 15368 | 15367 | {"type": "Polygon", "coordinates": [[[-118.04953, 33.95322], [-118.04794, 33.95479], [-118.04703, 33.95414], [-118.04712, 33.95402], [-118.04661, 33.95363], [-118.0473, 33.95299], [-118.04766, 33.95262], [-118.04765, 33.95257], [-118.04729, 33.95235], [-118.04701, 33.95253], [-118.04688, 33.95257], [-118.04672, 33.95256], [-118.04499, 33.95139], [-118.04575, 33.95062], [-118.04953, 33.95322]]]} | Restricted Access 2 | 46564 | Sierra Vista Adult School Park | 31909 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 16.345 | Sierra Vista Adult School Park | 0 | Local Park 2 | 4 | |
15369 | 15369 | 15368 | {"type": "Polygon", "coordinates": [[[-118.04661, 33.98098], [-118.0466, 33.98257], [-118.04655, 33.98262], [-118.0434, 33.98262], [-118.04335, 33.98259], [-118.04335, 33.98089], [-118.0454, 33.98089], [-118.04541, 33.98097], [-118.04661, 33.98098]]]} | Restricted Access 2 | 46565 | Whittier High School Park | 31910 | 2372 | Whittier Union High School District 922 | Special District 4 | School District 14 | http://www.wuhsd.org/site/default.aspx?PageID=1 | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 14.027 | Whittier High School Park | 0 | Local Park 2 | 4 | |
14159 | 14159 | 14158 | {"type": "Polygon", "coordinates": [[[-122.75048, 38.43421], [-122.74811, 38.43393], [-122.74801, 38.43312], [-122.75043, 38.43316], [-122.75037, 38.43323], [-122.75048, 38.43421]]]} | Restricted Access 2 | 44115 | J.X. Wilson Park | 31385 | 2307 | Wright Elementary School District 1089 | Special District 4 | School District 14 | http://www.wrightesd.org/site/default.aspx?PageID=1 | Special District 4 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 5.235 | J.X. Wilson Park | 0 | Local Park 2 | 4 | |
15370 | 15370 | 15369 | {"type": "Polygon", "coordinates": [[[-118.05409, 33.98997], [-118.05257, 33.98997], [-118.05256, 33.98817], [-118.05247, 33.98816], [-118.05247, 33.98725], [-118.05276, 33.98725], [-118.05365, 33.98816], [-118.05359, 33.98816], [-118.05358, 33.98817], [-118.05408, 33.98868], [-118.05409, 33.98997]]]} | Restricted Access 2 | 46566 | Dexter Middle School Park | 31911 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 8.327 | Dexter Middle School Park | 0 | Local Park 2 | 4 | |
15374 | 15374 | 15373 | {"type": "Polygon", "coordinates": [[[-118.07089, 33.98277], [-118.07034, 33.98332], [-118.07025, 33.98332], [-118.07025, 33.98291], [-118.06916, 33.98298], [-118.06903, 33.98295], [-118.06895, 33.98284], [-118.06879, 33.9828], [-118.06867, 33.98281], [-118.06848, 33.98289], [-118.06761, 33.98287], [-118.06732, 33.98319], [-118.06592, 33.98222], [-118.0659, 33.98218], [-118.06677, 33.98141], [-118.0679, 33.98219], [-118.06876, 33.9813], [-118.07089, 33.98277]]]} | Restricted Access 2 | 46585 | Katherine Edwards Middle School Park | 31922 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 12.444 | Katherine Edwards Middle School Park | 0 | Local Park 2 | 4 | |
15375 | 15375 | 15374 | {"type": "Polygon", "coordinates": [[[-118.06214, 33.99624], [-118.06143, 33.99697], [-118.06026, 33.99618], [-118.06023, 33.99613], [-118.06024, 33.99609], [-118.06036, 33.99592], [-118.06036, 33.99586], [-118.06034, 33.99581], [-118.06029, 33.99577], [-118.06042, 33.99562], [-118.06025, 33.99551], [-118.06031, 33.99544], [-118.06042, 33.99552], [-118.06068, 33.99526], [-118.06125, 33.99569], [-118.06164, 33.99594], [-118.06214, 33.99624]]]} | Restricted Access 2 | 46586 | Orange Grove Elementary School Park | 31923 | 2371 | Whittier City School District 923 | Special District 4 | School District 14 | http://www.whittiercity.k12.ca.us/ | Special District 4 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 4.112 | Orange Grove Elementary 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]);