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,143
- County Agency 779
- Recreation/Parks District 751
- 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 65
- Cemetery District 39
- Non Profit - Other 28
- County Agency - Other 27
- Port/Harbor District 22
- 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 362
- Los Angeles, City of 354
- California Department of Fish and Wildlife 286
- San Jose, City of 163
- California Department of Parks and Recreation 162
- San Francisco, City and County of 148
- Sacramento, City of 144
- Mountains Recreation and Conservation Authority 138
- Ventura, City of 138
- Los Angeles, County of 129
- Long Beach, City of 117
- San Diego, County of 102
- East Bay Regional Park District 101
- Roseville, City of 99
- Irvine, City of 78
- Fresno, City of 75
- Oakland, City of 72
- Consumnes Community Services District 68
- Santa Barbara, County of 65
- 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 55
- Chula Vista, City of 54
- Hayward Area Recreation and Park District 53
- Lake, County of 53
- Davis, City of 52
- Napa, City of 52
- …
ACCESS_TYP 4
- Open Access 9,326
- Restricted Access 818
- No Public Access 584
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4694 | 4694 | 4693 | {"type": "Polygon", "coordinates": [[[-121.80988, 36.70244], [-121.80939, 36.70557], [-121.80456, 36.70389], [-121.80313, 36.70304], [-121.80425, 36.70156], [-121.80449, 36.7013], [-121.80494, 36.70084], [-121.80501, 36.70057], [-121.80505, 36.70049], [-121.80988, 36.70244]]]} | Open Access 1 | Granite Rock Dunes | 19432 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 47.053 | Granite Rock Dunes | ||
4695 | 4695 | 4694 | {"type": "Polygon", "coordinates": [[[-119.78713, 36.78872], [-119.78713, 36.78889], [-119.78701, 36.78893], [-119.78669, 36.78911], [-119.78668, 36.78946], [-119.786, 36.78946], [-119.786, 36.7893], [-119.78631, 36.78913], [-119.78631, 36.78872], [-119.78713, 36.78872]]]} | Open Access 1 | Granny's Park | 19433 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1.172 | Granny's Park | ||
4696 | 4696 | 4695 | {"type": "Polygon", "coordinates": [[[-117.87117, 33.60242], [-117.87116, 33.60245], [-117.8711, 33.60256], [-117.87077, 33.60296], [-117.86933, 33.60201], [-117.86916, 33.60225], [-117.86863, 33.60202], [-117.86866, 33.60194], [-117.86798, 33.60161], [-117.86806, 33.60149], [-117.86816, 33.60138], [-117.86847, 33.60116], [-117.86847, 33.60114], [-117.86778, 33.60071], [-117.86707, 33.60032], [-117.86748, 33.5999], [-117.86751, 33.59989], [-117.86759, 33.59991], [-117.86785, 33.60009], [-117.86788, 33.60012], [-117.86788, 33.60016], [-117.86793, 33.6002], [-117.86799, 33.60018], [-117.86804, 33.6002], [-117.86886, 33.60078], [-117.869, 33.60082], [-117.86968, 33.60129], [-117.86963, 33.60133], [-117.86964, 33.60135], [-117.87103, 33.60229], [-117.87117, 33.60242]]]} | Open Access 1 | Grant Howald Park & CYC | 19435 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 9.011 | Grant Howald Park & CYC | ||
4697 | 4697 | 4696 | {"type": "Polygon", "coordinates": [[[-118.34172, 34.25537], [-118.34043, 34.2563], [-118.34044, 34.25641], [-118.34035, 34.25674], [-118.34035, 34.25683], [-118.34042, 34.25704], [-118.34042, 34.25714], [-118.34039, 34.2572], [-118.34031, 34.25726], [-118.34008, 34.25733], [-118.34002, 34.25738], [-118.3399, 34.25768], [-118.33994, 34.25797], [-118.33988, 34.25807], [-118.33974, 34.25819], [-118.3397, 34.25824], [-118.33977, 34.25865], [-118.33975, 34.25872], [-118.33969, 34.2588], [-118.33959, 34.25885], [-118.33944, 34.25885], [-118.33898, 34.2586], [-118.3389, 34.25857], [-118.33883, 34.25857], [-118.3382, 34.2587], [-118.3377, 34.25897], [-118.3376, 34.25898], [-118.33701, 34.2589], [-118.3369, 34.25893], [-118.3367, 34.25901], [-118.33652, 34.25903], [-118.33522, 34.25891], [-118.33481, 34.25879], [-118.3345, 34.25867], [-118.33443, 34.25863], [-118.33438, 34.25854], [-118.33438, 34.25848], [-118.33441, 34.25841], [-118.33441, 34.25829], [-118.33439, 34.25817], [-118.33437, 34.25814], [-118.3343, 34.2581], [-118.33423, 34.25811], [-118.33402, 34.25796], [-118.33282, 34.25776], [-118.33176, 34.25745], [-118.33175, 34.25642], [-118.33162, 34.25606], [-118.33187, 34.2553], [-118.33131, 34.25461], [-118.33174, 34.2526], [-118.33464, 34.25337], [-118.34172, 34.25537]]]} | No Public Access 3 | Green Verdugo Reservoir | 19469 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 105.013 | Green Verdugo Reservoir | ||
4698 | 4698 | 4697 | {"type": "Polygon", "coordinates": [[[-122.34306, 37.9484], [-122.34271, 37.94841], [-122.34271, 37.94814], [-122.34305, 37.94814], [-122.34306, 37.9484]]]} | Open Access 1 | Humphrey Play Lot | 20151 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 0.224 | Humphrey Play Lot | ||
4699 | 4699 | 4698 | {"type": "MultiPolygon", "coordinates": [[[[-121.18222, 38.57602], [-121.1822, 38.57611], [-121.18211, 38.57618], [-121.18207, 38.57637], [-121.18203, 38.57642], [-121.18188, 38.57649], [-121.18171, 38.57647], [-121.1816, 38.57655], [-121.18159, 38.57661], [-121.18154, 38.5767], [-121.18139, 38.57677], [-121.18137, 38.57688], [-121.18141, 38.57693], [-121.18144, 38.57702], [-121.18143, 38.57707], [-121.18139, 38.57712], [-121.18132, 38.57716], [-121.1812, 38.57716], [-121.18112, 38.57713], [-121.18105, 38.57706], [-121.18102, 38.57697], [-121.18098, 38.57692], [-121.18096, 38.57688], [-121.181, 38.57664], [-121.1809, 38.57652], [-121.18083, 38.57636], [-121.18087, 38.57622], [-121.18099, 38.57613], [-121.18107, 38.5761], [-121.18108, 38.57603], [-121.18222, 38.57602]]], [[[-121.18382, 38.57601], [-121.18377, 38.57627], [-121.18367, 38.57647], [-121.18361, 38.57654], [-121.18354, 38.57658], [-121.18346, 38.57683], [-121.18344, 38.57696], [-121.18342, 38.577], [-121.18336, 38.57704], [-121.18329, 38.57706], [-121.18328, 38.57712], [-121.18325, 38.57717], [-121.18314, 38.57724], [-121.18303, 38.57725], [-121.18291, 38.57721], [-121.18266, 38.57744], [-121.1826, 38.57751], [-121.18251, 38.57773], [-121.18252, 38.57779], [-121.18256, 38.57785], [-121.18272, 38.57799], [-121.18285, 38.57818], [-121.18296, 38.57819], [-121.18304, 38.57824], [-121.18307, 38.57831], [-121.18304, 38.57843], [-121.18306, 38.57849], [-121.1831, 38.57853], [-121.18315, 38.57855], [-121.18325, 38.57857], [-121.18331, 38.57861], [-121.18335, 38.57868], [-121.18334, 38.57875], [-121.18322, 38.57887], [-121.18315, 38.57891], [-121.18302, 38.57896], [-121.18288, 38.57896], [-121.18251, 38.57912], [-121.18242, 38.57912], [-121.18236, 38.5791], [-121.18227, 38.57903], [-121.18225, 38.57894], [-121.18231, 38.57883], [-121.18231, 38.57866], [-121.18239, 38.57857], [-121.18245, 38.57846], [-121.18225, 38.57831], [-121.18216, 38.57828], [-121.1821, 38.57824], [-121.18206, 38.57818], [-121.18205, 38.57811], [-121.18196, 38.57805], [-121.1819, 38.57798], [-121.1819, 38.57788], [-121.182, 38.57772], [-121.18203, 38.57754], [-121.18208, 38.57749], [-121.18216, 38.57745], [-121.1822, 38.57741], [-121.18228, 38.57731], [-121.18239, 38.57719], [-121.18241, 38.57712], [-121.18245, 38.57707], [-121.18252, 38.57702], [-121.18261, 38.577], [-121.18271, 38.57689], [-121.18283, 38.5768], [-121.18308, 38.57669], [-121.18312, 38.5766], [-121.18312, 38.5765], [-121.18326, 38.5763], [-121.18339, 38.57602], [-121.18382, 38.57601]]]]} | Unknown Access 4 | Grant Line Road Properties Llc | 19436 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 6.933 | Grant Line Road Properties Llc | ||
4700 | 4700 | 4699 | {"type": "Polygon", "coordinates": [[[-118.12585, 34.14252], [-118.1246, 34.14252], [-118.12459, 34.14175], [-118.12584, 34.14174], [-118.12585, 34.14252]]]} | Open Access 1 | Grant Park | 19439 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 2.458 | Grant Park | ||
4701 | 4701 | 4700 | {"type": "Polygon", "coordinates": [[[-122.6307, 38.21993], [-122.63068, 38.22035], [-122.62958, 38.22036], [-122.62935, 38.22045], [-122.6293, 38.22056], [-122.62924, 38.22066], [-122.62902, 38.22065], [-122.62899, 38.22063], [-122.62886, 38.22061], [-122.62878, 38.22063], [-122.62846, 38.22063], [-122.62846, 38.21987], [-122.62849, 38.21981], [-122.62844, 38.21951], [-122.6285, 38.21947], [-122.62939, 38.21947], [-122.62953, 38.21953], [-122.62967, 38.21953], [-122.62973, 38.21975], [-122.62987, 38.21992], [-122.6307, 38.21993]]]} | Open Access 1 | Grant Park | 19440 | 1249 | Petaluma, City of 144 | City 2 | City Agency 2 | http://cityofpetaluma.net/parksnrec/index.html | City 2 | 4.26 | Grant Park | ||
4702 | 4702 | 4701 | {"type": "Polygon", "coordinates": [[[-122.02181, 36.98457], [-122.02176, 36.98553], [-122.02056, 36.9854], [-122.0206, 36.98468], [-122.0212, 36.98477], [-122.02119, 36.98463], [-122.02181, 36.98457]]]} | Open Access 1 | Grant Park | 19441 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 2.366 | Grant Park | ||
4703 | 4703 | 4702 | {"type": "Polygon", "coordinates": [[[-119.29835, 34.28421], [-119.29758, 34.28628], [-119.2952, 34.28579], [-119.2948, 34.28615], [-119.29468, 34.28641], [-119.29454, 34.28639], [-119.28855, 34.29188], [-119.28853, 34.28519], [-119.28872, 34.28515], [-119.28879, 34.28498], [-119.28876, 34.28476], [-119.2888, 34.28459], [-119.28891, 34.28423], [-119.28896, 34.28393], [-119.28894, 34.28392], [-119.2887, 34.28401], [-119.28853, 34.28402], [-119.28853, 34.28339], [-119.29013, 34.28339], [-119.29015, 34.28334], [-119.29058, 34.28334], [-119.29059, 34.28338], [-119.29079, 34.28338], [-119.29081, 34.28334], [-119.29106, 34.28334], [-119.29108, 34.28338], [-119.29245, 34.28338], [-119.29247, 34.2833], [-119.29391, 34.28329], [-119.29393, 34.28338], [-119.29548, 34.28337], [-119.29553, 34.28325], [-119.29561, 34.28317], [-119.2962, 34.28295], [-119.29621, 34.28299], [-119.29622, 34.28299], [-119.29682, 34.28279], [-119.29696, 34.28279], [-119.29715, 34.28281], [-119.29725, 34.28281], [-119.29775, 34.28263], [-119.29797, 34.28261], [-119.29806, 34.28263], [-119.2978, 34.28408], [-119.29835, 34.28421]], [[-119.29624, 34.28499], [-119.29637, 34.28467], [-119.29628, 34.28453], [-119.29613, 34.2845], [-119.2956, 34.28481], [-119.29543, 34.28497], [-119.29557, 34.28515], [-119.29568, 34.28521], [-119.29577, 34.28518], [-119.2958, 34.28522], [-119.29591, 34.28523], [-119.29605, 34.28519], [-119.29622, 34.28505], [-119.29624, 34.28499]]]} | Open Access 1 | Grant Park | 19442 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 111.999 | Grant Park | ||
4704 | 4704 | 4703 | {"type": "Polygon", "coordinates": [[[-118.09314, 34.01453], [-118.08964, 34.01993], [-118.08947, 34.01985], [-118.08955, 34.01971], [-118.08889, 34.0192], [-118.08873, 34.01862], [-118.0887, 34.01823], [-118.08873, 34.01821], [-118.0887, 34.01785], [-118.08784, 34.01763], [-118.08773, 34.01758], [-118.08952, 34.01644], [-118.08955, 34.01646], [-118.09018, 34.01602], [-118.09165, 34.01509], [-118.09212, 34.01474], [-118.09232, 34.01465], [-118.09249, 34.01445], [-118.09264, 34.01449], [-118.09276, 34.01442], [-118.09314, 34.01453]]]} | Open Access 1 | Grant Rea Park | 19443 | 1211 | Montebello, City of 248 | City 2 | City Agency 2 | http://www.cityofmontebello.com/depts/parks/default.asp | City 2 | 24.968 | Grant Rea Park | ||
4705 | 4705 | 4704 | {"type": "Polygon", "coordinates": [[[-118.71115, 34.14166], [-118.71115, 34.14319], [-118.71031, 34.14318], [-118.71032, 34.14181], [-118.71115, 34.14166]]]} | Open Access 1 | Grape Arbor Park | 19445 | 1040 | Calabasas, City of 310 | City 2 | City Agency 2 | http://www.cityofcalabasas.com/recreation.html | City 2 | 3.055 | Grape Arbor Park | ||
4706 | 4706 | 4705 | {"type": "Polygon", "coordinates": [[[-117.08488, 33.12287], [-117.08464, 33.12304], [-117.08445, 33.12329], [-117.0846, 33.1235], [-117.08411, 33.12379], [-117.08436, 33.12439], [-117.08376, 33.12476], [-117.08317, 33.12528], [-117.08246, 33.12364], [-117.0847, 33.12257], [-117.08488, 33.12287]]]} | Open Access 1 | Grape Day Park | https://www.escondido.org/grape-day-park.aspx | 19446 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 7.667 | Grape Day Park | |
4707 | 4707 | 4706 | {"type": "Polygon", "coordinates": [[[-118.23684, 33.93818], [-118.23642, 33.93819], [-118.23642, 33.93808], [-118.23684, 33.93808], [-118.23684, 33.93818]]]} | Open Access 1 | Grape Street Pocket Park | 19447 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.115 | Grape Street PP | ||
4708 | 4708 | 4707 | {"type": "Polygon", "coordinates": [[[-117.14316, 34.04823], [-117.14313, 34.04826], [-117.13911, 34.04826], [-117.13908, 34.04823], [-117.13906, 34.04796], [-117.13897, 34.04759], [-117.13896, 34.04709], [-117.13908, 34.04709], [-117.13908, 34.0475], [-117.13911, 34.04771], [-117.13915, 34.04786], [-117.13917, 34.04788], [-117.13921, 34.04804], [-117.13933, 34.04815], [-117.1425, 34.04815], [-117.14257, 34.0482], [-117.14316, 34.04821], [-117.14316, 34.04823]]]} | Open Access 1 | Greenbelt | 19471 | 1269 | Redlands, City of 99 | City 2 | City Agency 2 | http://www.cityofredlands.org/ | City 2 | 1.377 | Greenbelt | ||
4709 | 4709 | 4708 | {"type": "Polygon", "coordinates": [[[-122.46112, 37.53913], [-122.45148, 37.539], [-122.45016, 37.52426], [-122.45518, 37.52471], [-122.45595, 37.53342], [-122.45784, 37.53575], [-122.46112, 37.53913]]]} | No Public Access 3 | Gregerson | 19499 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 205.786 | Gregerson | ||
4710 | 4710 | 4709 | {"type": "Polygon", "coordinates": [[[-118.37797, 33.86434], [-118.37796, 33.86475], [-118.37764, 33.86475], [-118.37763, 33.86434], [-118.37797, 33.86434]]]} | Open Access 1 | Gregg Parkette | 19500 | 1270 | Redondo Beach, City of 242 | City 2 | City Agency 2 | http://www.redondo.org | City 2 | 0.343 | Gregg Parkette | ||
4711 | 4711 | 4710 | {"type": "Polygon", "coordinates": [[[-121.90177, 37.31871], [-121.90143, 37.31907], [-121.90143, 37.31907], [-121.90145, 37.3187], [-121.90177, 37.31871]]]} | Open Access 1 | Gregory Plaza Tot Lot | 19501 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.146 | Gregory Plaza Tot Lot | 1998 | |
4712 | 4712 | 4711 | {"type": "Polygon", "coordinates": [[[-121.32095, 38.25247], [-121.32095, 38.25302], [-121.32042, 38.25302], [-121.32041, 38.25335], [-121.3201, 38.25359], [-121.32011, 38.25455], [-121.31912, 38.25455], [-121.31906, 38.25453], [-121.31904, 38.25449], [-121.31904, 38.2525], [-121.32095, 38.25247]]]} | Open Access 1 | Greer Basin Park | 19493 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 6.698 | Greer Basin Park | ||
4713 | 4713 | 4712 | {"type": "MultiPolygon", "coordinates": [[[[-118.00915, 33.73873], [-118.00872, 33.73874], [-118.00873, 33.73936], [-118.00767, 33.73936], [-118.00765, 33.73733], [-118.00913, 33.73732], [-118.00915, 33.73873]]], [[[-118.00929, 33.73713], [-118.00927, 33.73717], [-118.00918, 33.73721], [-118.00791, 33.73722], [-118.00788, 33.7356], [-118.00795, 33.7356], [-118.00796, 33.73588], [-118.00906, 33.73604], [-118.00909, 33.73631], [-118.00927, 33.73696], [-118.00929, 33.73713]]]]} | Open Access 1 | Greer Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/greer-park.cfm | 19494 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 11.095 | Greer 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]);