units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14,510 rows where ACCESS_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 268
- San Diego, City of 229
- Los Angeles, City of 216
- California Department of Fish and Wildlife 213
- San Jose, City of 142
- Sacramento, City of 142
- Ventura, City of 112
- Mountains Recreation and Conservation Authority 106
- Long Beach, City of 102
- Roseville, City of 92
- Los Angeles, County of 88
- San Francisco, City and County of 88
- Consumnes Community Services District 86
- Oakland, City of 81
- East Bay Regional Park District 79
- Irvine, City of 61
- United States Forest Service 60
- California State Lands Commission 58
- Orange, County of 58
- United States Bureau of Land Management 57
- Hayward Area Recreation and Park District 55
- Davis, City of 54
- Stockton, City of 52
- Napa, City of 52
- Poway, City of 50
- United States National Park Service 48
- Chula Vista, City of 48
- Brentwood, City of 47
- Santa Barbara, County of 46
- Tracy, City of 46
- …
DES_TP >30
- Local Park 4,912
- Local Recreation Area 1,068
- Local Other or Unknown 615
- Local Conservation Area 223
- State Conservation Area 189
- State Park 159
- Private Conservation 135
- State Recreation Area 102
- State Resource Management Area 65
- National Forest 56
- State Historic or Cultural Area 48
- Local Historic or Cultural Area 39
- National Public Lands 34
- Recreation Management Area 33
- Private Recreation or Education 27
- National Recreation Area 24
- National Monument or Landmark 19
- National Wildlife Refuge 17
- National Park 13
- Resource Management Area 8
- Local Resource Management Area 7
- Federal Other or Unknown 7
- Conservation Area 4
- State Other or Unknown 4
- Historic or Cultural Area 4
- Area of Critical Environmental Concern 4
- Private Agricultural 3
- Private Other or Unknown 3
- Private Historic or Cultural 3
- Wilderness Area 1
- …
MNG_AG_TYP 28
- City Agency 5,564
- Recreation/Parks District 647
- County Agency 598
- State Agency 595
- Federal Agency 227
- Open Space District 156
- Community Services District 154
- County Agency - Parks 139
- Non Profit - Land Trust 127
- Water District 80
- Non Profit - Conservation 36
- Non Profit - Other 21
- Flood District 20
- Cemetery District 16
- Irrigation District 14
- Port/Harbor District 13
- County Agency - Other 12
- Special District - Other 12
- Sanitation District 4
- Non Profit - Cemetery District 4
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Commercial 1
- Metropolitan Planning Organization 1
- Fire District 1
- Transportation Agency 1
ACCESS_TYP 1
- Open Access · 8,451 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7022 | 7022 | 7021 | {"type": "Polygon", "coordinates": [[[-118.2842, 33.74996], [-118.28396, 33.75], [-118.28374, 33.75009], [-118.28364, 33.75019], [-118.28346, 33.75047], [-118.28311, 33.75031], [-118.28295, 33.75006], [-118.28377, 33.74976], [-118.28397, 33.74971], [-118.28417, 33.74968], [-118.2842, 33.74996]]]} | Open Access 1 | 5970 | Knoll Hill Dog Park | 29113 | 2384 | Port of Los Angeles 289 | Special District 4 | Port/Harbor District 15 | http://www.portoflosangeles.org/ | Special District 4 | 2384 | Port of Los Angeles 286 | Special District 4 | Port/Harbor District 14 | Los Angeles 6 | 1.1 | Knoll Hill Dog Park | 0 | Local Park 2 | 4 | |
7023 | 7023 | 7022 | {"type": "Polygon", "coordinates": [[[-118.29297, 33.76367], [-118.29281, 33.76368], [-118.29284, 33.76385], [-118.29229, 33.76391], [-118.29196, 33.76393], [-118.29101, 33.76368], [-118.29073, 33.76367], [-118.29048, 33.76359], [-118.28997, 33.76351], [-118.28902, 33.75979], [-118.28925, 33.75955], [-118.28937, 33.7594], [-118.28942, 33.75941], [-118.29015, 33.75848], [-118.29119, 33.75693], [-118.29125, 33.75675], [-118.2913, 33.75676], [-118.29132, 33.75674], [-118.29131, 33.75671], [-118.29127, 33.75669], [-118.29133, 33.7565], [-118.29164, 33.75627], [-118.29151, 33.75575], [-118.29156, 33.75575], [-118.29168, 33.75622], [-118.29297, 33.76367]]]} | Open Access 1 | 5972 | Field of Dreams | 18890 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 45.703 | Field of Dreams | None 575 | |||
7026 | 7026 | 7025 | {"type": "Polygon", "coordinates": [[[-122.39017, 37.73464], [-122.38977, 37.73509], [-122.38872, 37.73449], [-122.38891, 37.73427], [-122.38877, 37.73418], [-122.38898, 37.73396], [-122.39017, 37.73464]]]} | Open Access 1 | 5967 | Joseph Lee Recreation Center | 30856 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/destination/joseph-lee-rec-center/ | San Francisco 13 | 1.855 | Joseph Lee Rec. Ctr. | 0 | Local Recreation Area 3 | 4 |
7027 | 7027 | 7026 | {"type": "MultiPolygon", "coordinates": [[[[-118.38329, 33.74488], [-118.38315, 33.74489], [-118.38294, 33.74485], [-118.38222, 33.74461], [-118.38115, 33.74421], [-118.38005, 33.74376], [-118.37905, 33.74332], [-118.37857, 33.74313], [-118.37857, 33.7431], [-118.3788, 33.74316], [-118.37926, 33.74331], [-118.37949, 33.74343], [-118.38065, 33.74391], [-118.38235, 33.74457], [-118.38328, 33.74485], [-118.38329, 33.74488]]], [[[-118.38673, 33.74537], [-118.38671, 33.7454], [-118.38656, 33.7454], [-118.38635, 33.74536], [-118.38546, 33.74527], [-118.38414, 33.74512], [-118.38375, 33.74505], [-118.38368, 33.74502], [-118.38373, 33.74499], [-118.38452, 33.74507], [-118.38592, 33.74526], [-118.38636, 33.74529], [-118.38673, 33.74537]]], [[[-118.39135, 33.74487], [-118.39131, 33.74491], [-118.39016, 33.74528], [-118.38972, 33.74537], [-118.38896, 33.74547], [-118.38819, 33.74551], [-118.38753, 33.74551], [-118.38709, 33.74548], [-118.38695, 33.74545], [-118.38692, 33.7454], [-118.3883, 33.7454], [-118.38898, 33.74536], [-118.38977, 33.74525], [-118.39018, 33.74518], [-118.39059, 33.74506], [-118.39128, 33.74484], [-118.39132, 33.74483], [-118.39135, 33.74487]]], [[[-118.39643, 33.7431], [-118.39515, 33.74361], [-118.39305, 33.74435], [-118.3917, 33.74481], [-118.3916, 33.74483], [-118.39157, 33.7448], [-118.39171, 33.74474], [-118.39181, 33.74467], [-118.39643, 33.74304], [-118.39643, 33.7431]]], [[[-118.40884, 33.74303], [-118.40875, 33.74303], [-118.4085, 33.74288], [-118.40823, 33.74274], [-118.40775, 33.74259], [-118.40708, 33.74244], [-118.40633, 33.74239], [-118.40528, 33.7424], [-118.4048, 33.74236], [-118.40426, 33.74225], [-118.40358, 33.74208], [-118.40254, 33.74174], [-118.40215, 33.74165], [-118.40167, 33.74159], [-118.40134, 33.74159], [-118.40069, 33.74168], [-118.40006, 33.74187], [-118.39853, 33.74242], [-118.39673, 33.74302], [-118.39665, 33.743], [-118.39707, 33.74283], [-118.39717, 33.74277], [-118.3986, 33.74229], [-118.40009, 33.74176], [-118.40066, 33.74158], [-118.40113, 33.74149], [-118.40143, 33.74147], [-118.40177, 33.74147], [-118.40254, 33.7416], [-118.40371, 33.74197], [-118.40435, 33.74216], [-118.40486, 33.74227], [-118.40531, 33.74231], [-118.40636, 33.74231], [-118.40698, 33.74235], [-118.40741, 33.7424], [-118.40793, 33.74255], [-118.40835, 33.74272], [-118.40864, 33.74286], [-118.40884, 33.74303]]], [[[-118.40899, 33.74318], [-118.40914, 33.74336], [-118.40934, 33.7437], [-118.40944, 33.74405], [-118.40946, 33.74428], [-118.40934, 33.74483], [-118.40907, 33.74529], [-118.40758, 33.74691], [-118.40744, 33.74721], [-118.40735, 33.74754], [-118.4073, 33.74804], [-118.40728, 33.74813], [-118.40725, 33.74815], [-118.40721, 33.74812], [-118.40719, 33.74784], [-118.40723, 33.74752], [-118.40731, 33.74718], [-118.40745, 33.74691], [-118.40771, 33.74658], [-118.40897, 33.74525], [-118.40911, 33.74503], [-118.40927, 33.74471], [-118.40933, 33.74446], [-118.40935, 33.7442], [-118.40932, 33.744], [-118.40921, 33.74369], [-118.40904, 33.74338], [-118.4089, 33.74319], [-118.40892, 33.74316], [-118.40899, 33.74318]]], [[[-118.40891, 33.75149], [-118.40882, 33.75149], [-118.40872, 33.75129], [-118.4083, 33.75056], [-118.40819, 33.75033], [-118.40776, 33.74954], [-118.40781, 33.74952], [-118.40789, 33.74952], [-118.40828, 33.7503], [-118.40841, 33.75047], [-118.40891, 33.75149]]], [[[-118.41135, 33.75611], [-118.4113, 33.75612], [-118.41126, 33.75609], [-118.41097, 33.75561], [-118.40965, 33.75312], [-118.40896, 33.75176], [-118.40903, 33.75176], [-118.4092, 33.752], [-118.41016, 33.7538], [-118.41095, 33.75533], [-118.41112, 33.7556], [-118.41135, 33.75611]]], [[[-118.41472, 33.76181], [-118.41462, 33.76181], [-118.41465, 33.76146], [-118.41461, 33.76101], [-118.41458, 33.7609], [-118.41447, 33.76019], [-118.4144, 33.75994], [-118.41424, 33.75957], [-118.4141, 33.75928], [-118.41379, 33.75889], [-118.41284, 33.75802], [-118.41224, 33.75741], [-118.41171, 33.75677], [-118.4115, 33.75649], [-118.41142, 33.75633], [-118.41149, 33.75631], [-118.41155, 33.75635], [-118.41174, 33.75663], [-118.41186, 33.75674], [-118.41284, 33.75784], [-118.4139, 33.75884], [-118.41423, 33.75924], [-118.41455, 33.7599], [-118.41461, 33.76015], [-118.41467, 33.76048], [-118.41473, 33.76135], [-118.41474, 33.76176], [-118.41472, 33.76181]]], [[[-118.41473, 33.76201], [-118.41475, 33.7621], [-118.41471, 33.76246], [-118.41464, 33.7628], [-118.41448, 33.76283], [-118.41456, 33.76242], [-118.41459, 33.76197], [-118.4147, 33.76198], [-118.41473, 33.76201]]]]} | Open Access 1 | 5978 | Rancho Palos Verdes City Parkland | 24161 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | Los Angeles 6 | 13.5 | Rancho Palos Verdes City Parkland | 0 | Local Park 2 | 4 | |
7028 | 7028 | 7027 | {"type": "Polygon", "coordinates": [[[-117.91444, 34.14248], [-117.91441, 34.14341], [-117.90975, 34.14339], [-117.90975, 34.14274], [-117.91258, 34.14276], [-117.91259, 34.14205], [-117.91267, 34.14189], [-117.91298, 34.14199], [-117.91318, 34.14198], [-117.91319, 34.14095], [-117.91444, 34.14096], [-117.91442, 34.14188], [-117.91443, 34.14246], [-117.91444, 34.14248]]]} | Open Access 1 | 5980 | Northside Park | 22891 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 14.464 | Northside Park | 0 | Local Park 2 | 4 | |
7029 | 7029 | 7028 | {"type": "MultiPolygon", "coordinates": [[[[-118.32142, 33.77464], [-118.32102, 33.77473], [-118.31834, 33.77544], [-118.31832, 33.77535], [-118.32123, 33.77458], [-118.32138, 33.77457], [-118.32142, 33.77464]]], [[[-118.32635, 33.77317], [-118.32602, 33.77328], [-118.32555, 33.77349], [-118.32506, 33.77368], [-118.32436, 33.77389], [-118.3217, 33.77457], [-118.32165, 33.77444], [-118.32332, 33.77403], [-118.32405, 33.77387], [-118.32459, 33.77371], [-118.32495, 33.77357], [-118.32545, 33.77341], [-118.32634, 33.77302], [-118.32635, 33.77317]]], [[[-118.32748, 33.77267], [-118.32699, 33.77284], [-118.32693, 33.77282], [-118.32689, 33.77274], [-118.3269, 33.77269], [-118.32738, 33.77249], [-118.32748, 33.77267]]], [[[-118.33179, 33.77213], [-118.33028, 33.77212], [-118.32945, 33.77218], [-118.32863, 33.77231], [-118.32785, 33.77252], [-118.32759, 33.77261], [-118.32751, 33.77246], [-118.3283, 33.77225], [-118.32871, 33.77216], [-118.32929, 33.77206], [-118.32984, 33.77201], [-118.33067, 33.77201], [-118.33179, 33.77205], [-118.33179, 33.77213]]], [[[-118.3694, 33.79003], [-118.36941, 33.79011], [-118.36939, 33.7902], [-118.36926, 33.79047], [-118.36907, 33.79074], [-118.36884, 33.79097], [-118.36868, 33.79111], [-118.36848, 33.79124], [-118.36816, 33.79136], [-118.36793, 33.79143], [-118.36743, 33.79149], [-118.36707, 33.79147], [-118.36666, 33.79136], [-118.36603, 33.79112], [-118.36584, 33.79107], [-118.3652, 33.79095], [-118.36475, 33.79093], [-118.36394, 33.79098], [-118.36362, 33.79099], [-118.36332, 33.79102], [-118.36329, 33.79096], [-118.36461, 33.79085], [-118.36504, 33.79085], [-118.36523, 33.79086], [-118.36567, 33.79092], [-118.36602, 33.79101], [-118.36694, 33.79133], [-118.36719, 33.79137], [-118.36741, 33.79139], [-118.36772, 33.79137], [-118.36794, 33.79133], [-118.36818, 33.79125], [-118.36845, 33.79112], [-118.3687, 33.79096], [-118.36898, 33.79067], [-118.36936, 33.78999], [-118.3694, 33.79003]]], [[[-118.37239, 33.78615], [-118.37228, 33.78674], [-118.37214, 33.78729], [-118.37186, 33.78788], [-118.37168, 33.78815], [-118.37146, 33.78838], [-118.37112, 33.78864], [-118.37056, 33.78896], [-118.37047, 33.78904], [-118.37019, 33.78919], [-118.37004, 33.78935], [-118.36988, 33.78945], [-118.36978, 33.78954], [-118.36968, 33.78965], [-118.36959, 33.7898], [-118.36949, 33.78975], [-118.36981, 33.78938], [-118.37023, 33.78902], [-118.37064, 33.78875], [-118.37131, 33.78829], [-118.37145, 33.78815], [-118.37164, 33.78792], [-118.3718, 33.78768], [-118.37197, 33.78735], [-118.37233, 33.78617], [-118.37239, 33.78615]]]]} | Open Access 1 | 5981 | Rolling Hills City Parkland | 29837 | 1283 | Rolling Hills Estates, City of 270 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | Los Angeles 6 | 7.203 | Rolling Hills City Parkland | 0 | Local Park 2 | 4 | |
7030 | 7030 | 7029 | {"type": "Polygon", "coordinates": [[[-118.39442, 33.80424], [-118.39415, 33.80478], [-118.39356, 33.80601], [-118.39329, 33.807], [-118.39233, 33.81143], [-118.39218, 33.81219], [-118.39202, 33.81326], [-118.39165, 33.81528], [-118.39118, 33.81521], [-118.39079, 33.81519], [-118.39088, 33.81466], [-118.39026, 33.8146], [-118.3904, 33.81427], [-118.39047, 33.81395], [-118.39059, 33.81137], [-118.39061, 33.81117], [-118.3907, 33.81067], [-118.39071, 33.81053], [-118.39212, 33.81054], [-118.39305, 33.80631], [-118.39361, 33.8049], [-118.39394, 33.80426], [-118.39442, 33.80424]]]} | Open Access 1 | 5983 | Torrance County Beach | 26413 | 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://beaches.lacounty.gov/wps/portal/dbh/home/detail/?current=true&urile=wcm:path:/dbh+content/dbh+site/home/home+detail/torrance+1 | Los Angeles 6 | 24.571 | Torrance County Beach | 0 | Local Park 2 | 4 |
7031 | 7031 | 7030 | {"type": "Polygon", "coordinates": [[[-118.39165, 33.81528], [-118.39133, 33.81669], [-118.39115, 33.81771], [-118.39097, 33.81944], [-118.39086, 33.8208], [-118.39083, 33.82232], [-118.39085, 33.82336], [-118.3909, 33.82436], [-118.39114, 33.82755], [-118.3913, 33.82916], [-118.39022, 33.82905], [-118.39031, 33.82836], [-118.38999, 33.82833], [-118.39, 33.82826], [-118.39007, 33.82812], [-118.39009, 33.82805], [-118.39019, 33.82733], [-118.3902, 33.82686], [-118.38985, 33.81998], [-118.38989, 33.81954], [-118.39005, 33.81863], [-118.39057, 33.81536], [-118.3904, 33.81516], [-118.39061, 33.81519], [-118.39118, 33.81521], [-118.39165, 33.81528]]]} | Open Access 1 | 5990 | Redondo County Beach | 24242 | 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 | 33.32 | Redondo County Beach | 0 | Local Park 2 | 4 | |
7032 | 7032 | 7031 | {"type": "MultiPolygon", "coordinates": [[[[-122.37444, 37.73233], [-122.37423, 37.73255], [-122.37391, 37.7327], [-122.37367, 37.73284], [-122.37351, 37.73296], [-122.3734, 37.73312], [-122.37285, 37.73361], [-122.37263, 37.73387], [-122.37249, 37.73406], [-122.37234, 37.73415], [-122.3722, 37.73418], [-122.37208, 37.73417], [-122.37192, 37.7341], [-122.37168, 37.73392], [-122.37134, 37.73362], [-122.37103, 37.73337], [-122.37024, 37.73281], [-122.36977, 37.73251], [-122.36999, 37.73227], [-122.3706, 37.73242], [-122.37071, 37.73248], [-122.37079, 37.73258], [-122.37169, 37.7331], [-122.37174, 37.73322], [-122.37179, 37.73326], [-122.37186, 37.73329], [-122.37194, 37.73329], [-122.37203, 37.73328], [-122.3723, 37.73343], [-122.37263, 37.73319], [-122.37295, 37.7331], [-122.37325, 37.73272], [-122.37405, 37.73228], [-122.37416, 37.73217], [-122.37444, 37.73233]], [[-122.37211, 37.73352], [-122.37219, 37.73343], [-122.37205, 37.73334], [-122.37196, 37.73344], [-122.37211, 37.73352]]], [[[-122.37676, 37.73425], [-122.37671, 37.73431], [-122.3767, 37.73438], [-122.37652, 37.73437], [-122.37643, 37.73438], [-122.37588, 37.73505], [-122.37583, 37.73509], [-122.37573, 37.73512], [-122.3757, 37.73518], [-122.37557, 37.73524], [-122.3755, 37.73533], [-122.37536, 37.7354], [-122.37536, 37.73542], [-122.37517, 37.73534], [-122.37517, 37.73533], [-122.37507, 37.73525], [-122.37452, 37.73494], [-122.37492, 37.73449], [-122.37506, 37.73457], [-122.37501, 37.73467], [-122.37501, 37.73469], [-122.3751, 37.73463], [-122.37512, 37.73459], [-122.37514, 37.73456], [-122.37513, 37.73452], [-122.37504, 37.73445], [-122.37498, 37.73443], [-122.37494, 37.73442], [-122.37491, 37.73443], [-122.37489, 37.73442], [-122.37491, 37.73436], [-122.37486, 37.73418], [-122.37452, 37.73399], [-122.37472, 37.73377], [-122.37486, 37.73385], [-122.37506, 37.73363], [-122.37521, 37.73372], [-122.37526, 37.73356], [-122.37558, 37.73365], [-122.37598, 37.7332], [-122.3767, 37.73361], [-122.37668, 37.73366], [-122.37673, 37.73393], [-122.37643, 37.73384], [-122.37642, 37.73385], [-122.37645, 37.73392], [-122.37632, 37.73407], [-122.37668, 37.73423], [-122.37676, 37.73421], [-122.37676, 37.73425]]]]} | Open Access 1 | 6002 | India Basin Shoreline Park | 20197 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 12.79 | India Basin Shoreline Park | 0 | Local Park 2 | 4 | |
7033 | 7033 | 7032 | {"type": "Polygon", "coordinates": [[[-118.3448, 33.82554], [-118.3448, 33.82767], [-118.34478, 33.828], [-118.34478, 33.82911], [-118.34473, 33.82916], [-118.3444, 33.82916], [-118.3439, 33.82912], [-118.34363, 33.82907], [-118.34337, 33.829], [-118.34312, 33.82892], [-118.34283, 33.82878], [-118.34251, 33.8286], [-118.34055, 33.82731], [-118.34005, 33.82708], [-118.34004, 33.82705], [-118.34003, 33.82566], [-118.34, 33.82542], [-118.33991, 33.82492], [-118.33989, 33.82465], [-118.33991, 33.82444], [-118.33994, 33.82441], [-118.34001, 33.8244], [-118.34081, 33.82457], [-118.34161, 33.8247], [-118.34336, 33.82506], [-118.34421, 33.82514], [-118.34421, 33.82554], [-118.3448, 33.82554]]]} | Open Access 1 | 6005 | Madrona Marsh Preserve | 29331 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 42.371 | Madrona Marsh Preserve | 0 | Local Conservation Area 4 | 2 | |
7034 | 7034 | 7033 | {"type": "Polygon", "coordinates": [[[-118.35936, 33.81965], [-118.35935, 33.82005], [-118.35857, 33.81965], [-118.35904, 33.81964], [-118.35936, 33.81965]]]} | Open Access 1 | 6006 | La Paloma Park | 20781 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.411 | La Paloma Park | 0 | Local Park 2 | 4 | |
7035 | 7035 | 7034 | {"type": "Polygon", "coordinates": [[[-118.36495, 33.84316], [-118.36345, 33.84316], [-118.36344, 33.84143], [-118.36494, 33.84143], [-118.36495, 33.84316]]]} | Open Access 1 | 6007 | Victor Park | 27071 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 6.599 | Victor Park | 0 | Local Park 2 | 4 | |
7036 | 7036 | 7035 | {"type": "Polygon", "coordinates": [[[-118.36269, 33.85367], [-118.36202, 33.8541], [-118.36103, 33.85437], [-118.36055, 33.85448], [-118.36054, 33.85447], [-118.36051, 33.85428], [-118.36051, 33.85332], [-118.36126, 33.85332], [-118.36126, 33.85297], [-118.36158, 33.85299], [-118.36165, 33.85297], [-118.36168, 33.85295], [-118.36183, 33.85298], [-118.36216, 33.85288], [-118.36233, 33.85316], [-118.36261, 33.85354], [-118.36269, 33.85367]]]} | Open Access 1 | 6008 | La Romeria Park | 20805 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 5.591 | La Romeria Park | 0 | Local Park 2 | 4 | |
7037 | 7037 | 7036 | {"type": "Polygon", "coordinates": [[[-118.37364, 33.85464], [-118.37353, 33.85466], [-118.37302, 33.85512], [-118.37144, 33.85512], [-118.37143, 33.85544], [-118.37125, 33.85545], [-118.37124, 33.85512], [-118.37086, 33.85512], [-118.37055, 33.85389], [-118.36985, 33.85267], [-118.36996, 33.85242], [-118.36996, 33.85174], [-118.37048, 33.85173], [-118.37049, 33.85135], [-118.37067, 33.85135], [-118.37067, 33.85173], [-118.37209, 33.85173], [-118.37254, 33.85199], [-118.37294, 33.85219], [-118.37316, 33.85221], [-118.37364, 33.85464]]]} | Open Access 1 | 6009 | Entradero Park | 18687 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 25.683 | Entradero Park | 0 | Local Park 2 | 4 | |
7038 | 7038 | 7037 | {"type": "Polygon", "coordinates": [[[-118.37514, 33.85038], [-118.37394, 33.85055], [-118.37358, 33.8487], [-118.37437, 33.84871], [-118.37488, 33.84878], [-118.37492, 33.84881], [-118.37489, 33.84902], [-118.37489, 33.84913], [-118.37514, 33.85038]]]} | Open Access 1 | 6010 | Sunnyglen Park | 26006 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 5.483 | Sunnyglen Park | 0 | Local Park 2 | 4 | |
7039 | 7039 | 7038 | {"type": "Polygon", "coordinates": [[[-118.34715, 33.84786], [-118.3454, 33.84786], [-118.34539, 33.84679], [-118.34501, 33.84679], [-118.34499, 33.8467], [-118.34496, 33.84641], [-118.34497, 33.84505], [-118.34606, 33.84505], [-118.34606, 33.84678], [-118.34714, 33.84678], [-118.34715, 33.84786]]]} | Open Access 1 | 6011 | Delthorne Park | 18078 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 9.587 | Delthorne Park | 0 | Local Park 2 | 4 | |
7040 | 7040 | 7039 | {"type": "Polygon", "coordinates": [[[-118.33331, 33.83428], [-118.33231, 33.83429], [-118.3323, 33.83292], [-118.33329, 33.83291], [-118.33331, 33.83428]]]} | Open Access 1 | 6014 | Greenwood Park | 19489 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 3.437 | Greenwood Park | 0 | Local Park 2 | 4 | |
7041 | 7041 | 7040 | {"type": "Polygon", "coordinates": [[[-118.32837, 33.82753], [-118.3224, 33.82758], [-118.3212, 33.82649], [-118.32165, 33.82648], [-118.32164, 33.82567], [-118.32082, 33.82567], [-118.32011, 33.82549], [-118.31996, 33.82532], [-118.31991, 33.82531], [-118.31954, 33.82496], [-118.31917, 33.82465], [-118.31917, 33.82463], [-118.31928, 33.82473], [-118.31967, 33.82494], [-118.31984, 33.825], [-118.32017, 33.82509], [-118.32045, 33.82512], [-118.32835, 33.82506], [-118.32837, 33.82753]]]} | Open Access 1 | 6015 | Charles H. Wilson Park | 17139 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 44.163 | Charles H. Wilson Park | 0 | Local Park 2 | 4 | |
7042 | 7042 | 7041 | {"type": "Polygon", "coordinates": [[[-118.31867, 33.82175], [-118.31822, 33.82302], [-118.31708, 33.82273], [-118.31541, 33.82122], [-118.31549, 33.82097], [-118.31867, 33.82175]]]} | Open Access 1 | 6016 | Torrance Park | 26468 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 8.192 | Torrance Park | 0 | Local Park 2 | 4 | |
7043 | 7043 | 7042 | {"type": "Polygon", "coordinates": [[[-120.45049, 34.69233], [-120.44937, 34.69162], [-120.44841, 34.69135], [-120.44665, 34.69339], [-120.44259, 34.70021], [-120.44243, 34.70013], [-120.44787, 34.69066], [-120.44845, 34.69086], [-120.44961, 34.69143], [-120.45049, 34.69233]]]} | Open Access 1 | 29179 | Burton Mesa Ecological Reserve | 32070 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Burton-Mesa-ER | Santa Barbara 7 | 10.747 | Burton Mesa ER | 2004 | State Conservation Area 8 | 2 |
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]);