units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
812 rows where DES_TP = 2 and MNG_AG_LEV = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY >30
- Los Angeles, County of 95
- San Diego, County of 68
- Los Angeles - Department of Parks and Recreation, County of 44
- Orange, County of 43
- El Dorado, County of 42
- Santa Barbara, County of 40
- Kern, County of 37
- Sonoma County Regional Parks Dept., County of 34
- Santa Cruz, County of 33
- Santa Clara County Parks and Recreation Dept., County of 32
- Stanislaus, County of 22
- Marin County Parks Department, County of 21
- San Luis Obispo, County of 20
- Riverside, County of 19
- Placer, County of 19
- San Mateo County Parks and Recreation Dept., County of 18
- Lake, County of 18
- San Joaquin, County of 18
- Monterey, County of 17
- Ventura, County of 15
- San Bernardino, County of 14
- Merced, County of 12
- Yolo, County of 12
- Tulare, County of 11
- Fresno, County of 11
- Humboldt, County of 10
- Sacramento, County of 7
- Contra Costa County Public Works Dept., County of 6
- Tehama, County of 6
- Mendocino, County of 6
- …
ACCESS_TYP 4
MNG_AG_TYP 3
DES_TP 1
- Local Park · 812 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11122 | 11122 | 11121 | {"type": "MultiPolygon", "coordinates": [[[[-121.52266, 38.59411], [-121.52266, 38.59411], [-121.5217, 38.59399], [-121.5217, 38.59399], [-121.52266, 38.59411]]], [[[-121.52228, 38.59583], [-121.52227, 38.59588], [-121.52195, 38.59572], [-121.52228, 38.59582], [-121.52228, 38.59583]]]]} | Open Access 1 | 21392 | Elkhorn Park | 18567 | 332 | Yolo, County of 545 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | Yolo 33 | 0.034 | Elkhorn Park | 0 | Local Park 2 | 4 | |
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | 48179 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 0.053 | Kensington PP | 0 | Local Park 2 | 4 | |
16293 | 16293 | 16292 | {"type": "MultiPolygon", "coordinates": [[[[-121.06093, 38.67132], [-121.06085, 38.67139], [-121.06073, 38.67131], [-121.06076, 38.67126], [-121.06083, 38.67125], [-121.06093, 38.67132]]], [[[-121.06114, 38.67115], [-121.06106, 38.67123], [-121.06097, 38.67114], [-121.06099, 38.6711], [-121.06103, 38.67107], [-121.06114, 38.67115]]]]} | Open Access 1 | 35747 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.07 | RP | 0 | Local Park 2 | 4 | |
15955 | 15955 | 15954 | {"type": "Polygon", "coordinates": [[[-121.07146, 38.66759], [-121.07144, 38.66762], [-121.07138, 38.66763], [-121.0708, 38.66758], [-121.07072, 38.66757], [-121.07068, 38.66754], [-121.07067, 38.66751], [-121.07146, 38.66759]]]} | Open Access 1 | 36172 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.089 | RP | 0 | Local Park 2 | 4 | |
11442 | 11442 | 11441 | {"type": "Polygon", "coordinates": [[[-118.36175, 33.93255], [-118.36175, 33.93272], [-118.36145, 33.93272], [-118.36146, 33.93255], [-118.36175, 33.93255]]]} | Open Access 1 | 48138 | Lennox Community Garden | 32666 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.127 | Lennox Community Garden | 0 | Local Park 2 | 4 | |
9804 | 9804 | 9803 | {"type": "Polygon", "coordinates": [[[-119.82652, 34.43735], [-119.82651, 34.43749], [-119.82615, 34.43748], [-119.82615, 34.43734], [-119.82652, 34.43735]]]} | Open Access 1 | 18096 | Nectarine Mini Park | 22682 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.13 | Nectarine MP | 0 | Local Park 2 | 4 | |
15092 | 15092 | 15091 | {"type": "Polygon", "coordinates": [[[-118.23999, 33.92472], [-118.23998, 33.92479], [-118.23922, 33.9248], [-118.23925, 33.92475], [-118.2393, 33.92473], [-118.23999, 33.92472]]]} | Open Access 1 | 45876 | Martin Luther King Jr. Fitness Garden | 28949 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Martin_Luther_King_Jr_Fitness_Park | Los Angeles 6 | 0.133 | Martin Luther King Jr. Fitness Garden | 0 | Local Park 2 | 4 |
9554 | 9554 | 9553 | {"type": "Polygon", "coordinates": [[[-122.51744, 38.01193], [-122.51734, 38.01202], [-122.51708, 38.01218], [-122.51696, 38.01205], [-122.51738, 38.01189], [-122.51744, 38.01193]]]} | Open Access 1 | 16105 | Candy's Park | 16799 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.134 | Candy's Park | 0 | Local Park 2 | 4 | |
12451 | 12451 | 12450 | {"type": "Polygon", "coordinates": [[[-121.85893, 37.37941], [-121.85873, 37.3795], [-121.85851, 37.37957], [-121.8585, 37.37936], [-121.85856, 37.37933], [-121.85893, 37.37941]]]} | Open Access 1 | 28092 | Penitencia Creek Park | 23582 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 0.135 | Penitencia Creek Park | 1872 | Local Park 2 | 4 | |
254 | 254 | 253 | {"type": "Polygon", "coordinates": [[[-117.30173, 33.05629], [-117.30148, 33.05638], [-117.3014, 33.05627], [-117.30138, 33.05619], [-117.30167, 33.05611], [-117.30173, 33.05629]]]} | Open Access 1 | 704 | Seaside Gardens County Park | 25250 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 0.15 | Seaside Gardens County Park | 0 | Local Park 2 | 4 | |
4342 | 4342 | 4341 | {"type": "Polygon", "coordinates": [[[-120.74524, 40.43205], [-120.7452, 40.43213], [-120.74515, 40.43217], [-120.74508, 40.43219], [-120.74501, 40.43218], [-120.74495, 40.43216], [-120.7449, 40.43211], [-120.74489, 40.43206], [-120.7449, 40.432], [-120.74494, 40.43195], [-120.745, 40.43192], [-120.74507, 40.43191], [-120.74514, 40.43193], [-120.7452, 40.43197], [-120.74524, 40.43205]]]} | Open Access 1 | 45592 | Lake Forest Park | 28418 | 354 | Lassen, County of 750 | County 3 | County Agency 3 | http://www.co.lassen.ca.us/visiting/parks_and_leisure/ | County 3 | 354 | Lassen, County of 736 | County 3 | County Agency 3 | Lassen 54 | 0.17 | Lake Forest Park | 0 | Local Park 2 | 4 | |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.181 | Ganesha Park | 0 | Local Park 2 | 4 | |
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | 45867 | Woods Avenue Park | 28914 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | Los Angeles 6 | 0.218 | Woods Avenue Park | 0 | Local Park 2 | 4 |
14869 | 14869 | 14868 | {"type": "Polygon", "coordinates": [[[-118.23121, 34.21905], [-118.23088, 34.21936], [-118.23059, 34.21958], [-118.23052, 34.21953], [-118.23111, 34.21899], [-118.23121, 34.21905]]]} | Open Access 1 | 45388 | Pickens Canyon Park | 32497 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Pickens_Canyon_Park | Los Angeles 6 | 0.22 | Pickens Canyon Park | 0 | Local Park 2 | 4 |
13926 | 13926 | 13925 | {"type": "Polygon", "coordinates": [[[-121.64339, 36.88847], [-121.64319, 36.88849], [-121.64313, 36.88847], [-121.6431, 36.88843], [-121.64306, 36.88816], [-121.64333, 36.88813], [-121.64339, 36.88847]]]} | Open Access 1 | 36553 | Aromas Community Park | 28587 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | Monterey 14 | 0.23 | Aromas Community Park | 0 | Local Park 2 | 4 | |
10043 | 10043 | 10042 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09452, 38.93839], [-121.09452, 38.93839]]]} | Open Access 1 | 49023 | Auburn Plaza Park | 33724 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | https://www.placer.ca.gov/6005/Plaza-Park | Placer 35 | 0.231 | Auburn Plaza Park | 0 | Local Park 2 | 4 |
16386 | 16386 | 16385 | {"type": "Polygon", "coordinates": [[[-121.05687, 38.66352], [-121.05668, 38.66357], [-121.05641, 38.6636], [-121.05543, 38.66361], [-121.05519, 38.66358], [-121.05513, 38.66355], [-121.05687, 38.66352]]]} | Open Access 1 | 35695 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.233 | RP | 0 | Local Park 2 | 4 | |
14953 | 14953 | 14952 | {"type": "Polygon", "coordinates": [[[-122.03078, 38.03015], [-122.03061, 38.03021], [-122.03036, 38.02969], [-122.03052, 38.02965], [-122.03078, 38.03015]]]} | Open Access 1 | 45559 | Big Oak Tree Park | 28387 | 369 | Contra Costa, County of 1106 | County 3 | County Agency 3 | http://www.co.contra-costa.ca.us/446/Parks-and-Recreation | County 3 | 369 | Contra Costa, County of 1060 | County 3 | County Agency 3 | http://www.contracosta.ca.gov/4398/Clyde | Contra Costa 12 | 0.241 | Big Oak Tree Park | 0 | Local Park 2 | 4 |
3856 | 3856 | 3855 | {"type": "Polygon", "coordinates": [[[-120.43799, 37.52002], [-120.43772, 37.5201], [-120.43759, 37.51977], [-120.43784, 37.51968], [-120.43799, 37.52002]]]} | Open Access 1 | 45506 | Snelling Courthouse Park | 28338 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 0.242 | Snelling Courthouse Park | 0 | Local Park 2 | 4 | |
15076 | 15076 | 15075 | {"type": "Polygon", "coordinates": [[[-118.23107, 34.20894], [-118.23096, 34.20934], [-118.23094, 34.20936], [-118.2309, 34.20936], [-118.23081, 34.20922], [-118.23064, 34.20904], [-118.23064, 34.20902], [-118.23066, 34.209], [-118.23091, 34.20896], [-118.23103, 34.20892], [-118.23106, 34.20892], [-118.23107, 34.20894]]]} | Open Access 1 | 45856 | Mira Vista Park | 32494 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 0.249 | Mira Vista 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]);