superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
15,638 rows
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 7,229
- County Agency 786
- Recreation/Parks District 756
- State Agency 591
- Non Profit - Land Trust 387
- Open Space District 184
- Federal Agency 171
- County Agency - Parks 164
- Water District 153
- Community Services District 134
- Home Owners Association 126
- Non Profit - Conservation 95
- Flood District 66
- Cemetery District 40
- Non Profit - Other 28
- County Agency - Other 27
- Port/Harbor District 23
- Irrigation District 16
- School District 13
- Commercial 10
- Sanitation District 8
- Special District - Other 6
- Other 5
- Joint Powers Authority 4
- Non Profit - Cemetery District 4
- Mitigation Bank 4
- Conservation District 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 363
- Los Angeles, City of 360
- California Department of Fish and Wildlife 286
- San Jose, City of 167
- California Department of Parks and Recreation 162
- San Francisco, City and County of 155
- Sacramento, City of 145
- Mountains Recreation and Conservation Authority 138
- Ventura, City of 138
- Los Angeles, County of 130
- Long Beach, City of 118
- San Diego, County of 104
- East Bay Regional Park District 101
- Roseville, City of 99
- Irvine, City of 78
- Fresno, City of 75
- Oakland, City of 73
- Consumnes Community Services District 68
- Santa Barbara, County of 67
- Orange, County of 62
- Torrance, City of 61
- Poway, City of 60
- Santa Cruz, City of 57
- Los Angeles - Department of Parks and Recreation, County of 57
- Huntington Beach, City of 56
- Chula Vista, City of 54
- Hayward Area Recreation and Park District 54
- Davis, City of 53
- Lake, County of 53
- Stockton, City of 52
- …
ACCESS_TYP 4
- Open Access 9,423
- Restricted Access 821
- No Public Access 585
- Unknown Access 217
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4593 | 4593 | 4592 | {"type": "Polygon", "coordinates": [[[-117.7209, 33.59291], [-117.72081, 33.59296], [-117.72074, 33.5929], [-117.72064, 33.59285], [-117.72052, 33.59284], [-117.72037, 33.59287], [-117.7202, 33.593], [-117.72011, 33.59314], [-117.72008, 33.59325], [-117.71995, 33.59322], [-117.7198, 33.59314], [-117.71971, 33.59316], [-117.71969, 33.59313], [-117.71965, 33.59309], [-117.71953, 33.59307], [-117.71952, 33.593], [-117.71929, 33.59291], [-117.71917, 33.59305], [-117.71916, 33.5931], [-117.71903, 33.59308], [-117.71904, 33.59299], [-117.7188, 33.59293], [-117.71866, 33.59304], [-117.71854, 33.59303], [-117.71848, 33.59291], [-117.71826, 33.59286], [-117.71824, 33.59287], [-117.71822, 33.5929], [-117.71809, 33.59288], [-117.71798, 33.59291], [-117.7178, 33.59288], [-117.71769, 33.59299], [-117.71761, 33.59296], [-117.71755, 33.59297], [-117.7175, 33.59291], [-117.71726, 33.59286], [-117.71721, 33.59287], [-117.7172, 33.5929], [-117.71706, 33.59286], [-117.71707, 33.59282], [-117.717, 33.59278], [-117.7167, 33.59287], [-117.71664, 33.59271], [-117.71648, 33.59248], [-117.7165, 33.59244], [-117.71655, 33.5924], [-117.71663, 33.59236], [-117.7177, 33.59242], [-117.7183, 33.59247], [-117.71835, 33.59246], [-117.71841, 33.59242], [-117.71844, 33.59234], [-117.71881, 33.59225], [-117.71884, 33.59231], [-117.71889, 33.59233], [-117.71917, 33.59241], [-117.71922, 33.59244], [-117.72018, 33.59272], [-117.72038, 33.59275], [-117.72061, 33.59274], [-117.72066, 33.5927], [-117.72067, 33.59267], [-117.72065, 33.59263], [-117.72068, 33.59263], [-117.7209, 33.59291]]]} | Open Access 1 | Glenbrook Park | 19326 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 5.075 | Glenbrook Park | ||
4594 | 4594 | 4593 | {"type": "Polygon", "coordinates": [[[-122.06016, 38.25216], [-122.05982, 38.25215], [-122.05981, 38.25188], [-122.06016, 38.25187], [-122.06016, 38.25216]]]} | Open Access 1 | Kentucky Street Tot Lot | 20622 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 0.235 | Kentucky Street Tot Lot | ||
4595 | 4595 | 4594 | {"type": "Polygon", "coordinates": [[[-121.39164, 38.55995], [-121.3911, 38.55993], [-121.39004, 38.55998], [-121.38947, 38.56007], [-121.38911, 38.56017], [-121.38888, 38.56026], [-121.38882, 38.56025], [-121.38841, 38.55986], [-121.38834, 38.55976], [-121.3883, 38.55966], [-121.38821, 38.55925], [-121.38817, 38.55916], [-121.3881, 38.55904], [-121.38785, 38.5588], [-121.38778, 38.55871], [-121.38776, 38.55867], [-121.38775, 38.55857], [-121.38769, 38.55851], [-121.3877, 38.55849], [-121.38762, 38.55817], [-121.38966, 38.55791], [-121.3915, 38.55772], [-121.39164, 38.55995]]]} | Open Access 1 | Glenbrook Park | 19327 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 17.876 | Glenbrook Park | ||
4596 | 4596 | 4595 | {"type": "Polygon", "coordinates": [[[-122.25774, 37.88464], [-122.25726, 37.88493], [-122.25739, 37.88519], [-122.25691, 37.88549], [-122.25685, 37.88573], [-122.25643, 37.8857], [-122.25602, 37.88557], [-122.25569, 37.88579], [-122.25532, 37.88598], [-122.25516, 37.88565], [-122.25496, 37.88537], [-122.25538, 37.88519], [-122.25545, 37.88514], [-122.25551, 37.88502], [-122.25603, 37.88507], [-122.25599, 37.88491], [-122.25603, 37.88484], [-122.25616, 37.88472], [-122.2561, 37.88432], [-122.25625, 37.88422], [-122.25663, 37.88411], [-122.25673, 37.88439], [-122.25731, 37.88446], [-122.25737, 37.88452], [-122.25744, 37.88455], [-122.25774, 37.88464]]]} | Open Access 1 | Glendale-La Loma Park | 19328 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 5.562 | Glendale-La Loma Park | ||
4597 | 4597 | 4596 | {"type": "Polygon", "coordinates": [[[-121.41718, 37.76135], [-121.41711, 37.76141], [-121.41575, 37.76141], [-121.41574, 37.76097], [-121.41599, 37.76096], [-121.41599, 37.76075], [-121.4171, 37.76075], [-121.41717, 37.7608], [-121.41718, 37.76135]]]} | Open Access 1 | Glover Park | 19351 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 2.141 | Glover Park | ||
4598 | 4598 | 4597 | {"type": "Polygon", "coordinates": [[[-118.22027, 34.20964], [-118.22026, 34.20967], [-118.22021, 34.20969], [-118.2202, 34.20972], [-118.2201, 34.20968], [-118.21992, 34.20958], [-118.21984, 34.20955], [-118.21976, 34.20955], [-118.21946, 34.2096], [-118.21944, 34.20959], [-118.2194, 34.20928], [-118.21957, 34.2092], [-118.21961, 34.20921], [-118.21986, 34.2094], [-118.22025, 34.20961], [-118.22027, 34.20964]]]} | Open Access 1 | Glenhaven Park | 19330 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks-rec | City 2 | 0.47 | Glenhaven Park | ||
4599 | 4599 | 4598 | {"type": "Polygon", "coordinates": [[[-118.25304, 34.11033], [-118.25293, 34.11038], [-118.25283, 34.11045], [-118.25249, 34.11015], [-118.25259, 34.11007], [-118.25281, 34.11003], [-118.25304, 34.11033]]]} | Open Access 1 | Glenhurst Park | 19331 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.294 | Glenhurst Park | ||
4600 | 4600 | 4599 | {"type": "Polygon", "coordinates": [[[-117.71808, 33.97952], [-117.71777, 33.9796], [-117.71778, 33.9808], [-117.71766, 33.98078], [-117.7175, 33.98069], [-117.71737, 33.98059], [-117.71712, 33.98077], [-117.71706, 33.9807], [-117.71731, 33.98053], [-117.71721, 33.98041], [-117.71713, 33.98027], [-117.71707, 33.98012], [-117.71704, 33.97997], [-117.71703, 33.97946], [-117.7167, 33.97946], [-117.7167, 33.97898], [-117.71674, 33.97883], [-117.7168, 33.97872], [-117.71684, 33.9787], [-117.71688, 33.9787], [-117.7172, 33.97887], [-117.71703, 33.97909], [-117.71703, 33.97911], [-117.71767, 33.97946], [-117.7179, 33.97927], [-117.71801, 33.97938], [-117.71808, 33.97952]]]} | Open Access 1 | Glenmeade Park | 19332 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 3.213 | Glenmeade Park | ||
4601 | 4601 | 4600 | {"type": "Polygon", "coordinates": [[[-122.64141, 38.26353], [-122.6408, 38.26421], [-122.6405, 38.26458], [-122.64055, 38.26486], [-122.64043, 38.26493], [-122.64027, 38.26506], [-122.64003, 38.26532], [-122.63981, 38.26563], [-122.63979, 38.26585], [-122.63964, 38.26588], [-122.63946, 38.26594], [-122.63922, 38.26609], [-122.63904, 38.26628], [-122.6388, 38.2667], [-122.6387, 38.2667], [-122.63854, 38.26681], [-122.63852, 38.26684], [-122.63853, 38.26687], [-122.6382, 38.26728], [-122.63762, 38.26695], [-122.63796, 38.26654], [-122.63801, 38.26646], [-122.63804, 38.26634], [-122.63804, 38.26626], [-122.63832, 38.26613], [-122.63855, 38.26595], [-122.63872, 38.26577], [-122.63896, 38.26542], [-122.6392, 38.26518], [-122.63976, 38.26453], [-122.64044, 38.26386], [-122.64042, 38.26376], [-122.64087, 38.26328], [-122.64141, 38.26353]]]} | Open Access 1 | Glennbrook Park | 19333 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 7.852 | Glennbrook Park | ||
4602 | 4602 | 4601 | {"type": "Polygon", "coordinates": [[[-118.21019, 34.15242], [-118.21018, 34.15244], [-118.2097, 34.15268], [-118.20966, 34.15269], [-118.20919, 34.15195], [-118.20912, 34.1518], [-118.20915, 34.15177], [-118.2096, 34.15154], [-118.20964, 34.15152], [-118.20969, 34.15154], [-118.20992, 34.1519], [-118.21019, 34.1524], [-118.21019, 34.15242]]]} | Open Access 1 | Glenoaks Park | 19335 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.701 | Glenoaks Park | ||
4603 | 4603 | 4602 | {"type": "Polygon", "coordinates": [[[-118.20006, 34.21812], [-118.20005, 34.21902], [-118.19995, 34.21906], [-118.19983, 34.21905], [-118.19937, 34.21906], [-118.19921, 34.21889], [-118.20006, 34.21812]]]} | Open Access 1 | Glenola Park | 19337 | 1154 | La Canada Flintridge, City of 330 | City 2 | City Agency 2 | http://www.lcf.ca.gov/parks-rec | City 2 | 1.132 | Glenola Park | ||
4604 | 4604 | 4603 | {"type": "Polygon", "coordinates": [[[-122.44181, 37.62294], [-122.44167, 37.62295], [-122.44149, 37.62283], [-122.44155, 37.62271], [-122.44171, 37.62265], [-122.44177, 37.62264], [-122.44181, 37.62294]]]} | Open Access 1 | Glenview Park | 19338 | 1294 | San Bruno, City of 434 | City 2 | City Agency 2 | http://www.sanbruno.ca.gov/parks_main.html | City 2 | 0.16 | Glenview Park | 1961 | |
4605 | 4605 | 4604 | {"type": "Polygon", "coordinates": [[[-121.85269, 37.20573], [-121.8522, 37.20607], [-121.85206, 37.20621], [-121.85199, 37.20632], [-121.85194, 37.20644], [-121.85191, 37.20656], [-121.85191, 37.20669], [-121.85177, 37.20649], [-121.85165, 37.20624], [-121.8504, 37.20636], [-121.85036, 37.20566], [-121.85037, 37.20562], [-121.85042, 37.2056], [-121.85119, 37.20557], [-121.85137, 37.20555], [-121.85163, 37.20548], [-121.85191, 37.20535], [-121.85195, 37.20536], [-121.85221, 37.20547], [-121.85251, 37.20553], [-121.8526, 37.20557], [-121.85269, 37.20568], [-121.85269, 37.20573]]]} | Open Access 1 | Glenview Park | 19339 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.002 | Glenview Park | 1987 | |
4606 | 4606 | 4605 | {"type": "Polygon", "coordinates": [[[-122.00518, 37.06849], [-122.00503, 37.06988], [-122.00425, 37.06953], [-122.00373, 37.06955], [-122.00364, 37.0695], [-122.00328, 37.06951], [-122.00311, 37.06959], [-122.00224, 37.06979], [-122.00209, 37.06974], [-122.00216, 37.06947], [-122.00214, 37.06927], [-122.00209, 37.06916], [-122.00208, 37.06909], [-122.00211, 37.06905], [-122.00343, 37.06926], [-122.00375, 37.06802], [-122.00464, 37.06816], [-122.00459, 37.06839], [-122.00518, 37.06849]]]} | Open Access 1 | Glenwood Meadows | 19340 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 7.039 | Glenwood Meadows | ||
4607 | 4607 | 4606 | {"type": "Polygon", "coordinates": [[[-118.9006, 34.27489], [-118.9006, 34.27544], [-118.90058, 34.27548], [-118.90054, 34.27551], [-118.8986, 34.27552], [-118.89844, 34.2755], [-118.89837, 34.27551], [-118.89829, 34.27555], [-118.89821, 34.27565], [-118.89788, 34.27565], [-118.89788, 34.27489], [-118.9006, 34.27489]]]} | Open Access 1 | Glenwood Park | 19341 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 4.393 | Glenwood Park | ||
4608 | 4608 | 4607 | {"type": "Polygon", "coordinates": [[[-118.486, 34.0837], [-118.48537, 34.08397], [-118.48518, 34.08368], [-118.48543, 34.08358], [-118.48547, 34.08363], [-118.48584, 34.08367], [-118.486, 34.0837]]]} | Open Access 1 | Kenter Canyon Open Space of LA | 20620 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.383 | Kenter Canyon OS of LA | ||
4609 | 4609 | 4608 | {"type": "Polygon", "coordinates": [[[-118.86726, 34.19633], [-118.86683, 34.19687], [-118.86428, 34.19547], [-118.8647, 34.19494], [-118.86726, 34.19633]]]} | Open Access 1 | Glenwood Park - CRPD | 19342 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 4.941 | Glenwood Park - CRPD | ||
4610 | 4610 | 4609 | {"type": "Polygon", "coordinates": [[[-117.16972, 32.67545], [-117.16931, 32.67587], [-117.16903, 32.67574], [-117.16873, 32.67547], [-117.16831, 32.67527], [-117.16806, 32.6752], [-117.16821, 32.67505], [-117.16781, 32.67471], [-117.16835, 32.67424], [-117.16972, 32.67545]]]} | Open Access 1 | Glorietta Bay Park | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814937 | 19347 | 1069 | Coronado, City of 102 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 3.384 | Glorietta Bay Park | |
4611 | 4611 | 4610 | {"type": "Polygon", "coordinates": [[[-118.22811, 34.18711], [-118.22787, 34.18851], [-118.22784, 34.18851], [-118.22782, 34.1886], [-118.22785, 34.18863], [-118.22759, 34.19007], [-118.22734, 34.1901], [-118.22734, 34.19001], [-118.22728, 34.18982], [-118.22722, 34.18966], [-118.22712, 34.18948], [-118.22629, 34.18849], [-118.2259, 34.18796], [-118.22585, 34.1878], [-118.22586, 34.18756], [-118.2259, 34.18751], [-118.22597, 34.18748], [-118.22697, 34.18747], [-118.22777, 34.18736], [-118.22792, 34.18729], [-118.22806, 34.18714], [-118.22811, 34.18711]]]} | Open Access 1 | Glorietta Park | 19348 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 8.61 | Glorietta Park | ||
4612 | 4612 | 4611 | {"type": "Polygon", "coordinates": [[[-121.69054, 37.92014], [-121.6899, 37.92051], [-121.68948, 37.92005], [-121.69016, 37.91969], [-121.69054, 37.92014]]]} | Open Access 1 | Glory Park | 19349 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1.072 | Glory Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);