superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10,210 rows where MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- San Diego, City of 332
- Los Angeles, City of 287
- Ventura, City of 127
- San Jose, City of 107
- Sacramento, City of 100
- San Francisco, City and County of 96
- Long Beach, City of 96
- Roseville, City of 82
- Fresno, City of 56
- Poway, City of 55
- Torrance, City of 51
- Santa Cruz, City of 47
- Davis, City of 46
- Irvine, City of 42
- Rocklin, City of 41
- Oakland, City of 40
- Napa, City of 40
- Clovis, City of 39
- San Ramon, City of 36
- Stockton, City of 36
- Chula Vista, City of 35
- Santa Barbara, City of 34
- Huntington Beach, City of 34
- Santa Clarita, City of 34
- Newport Beach, City of 33
- Fremont, City of 33
- San Luis Obispo, City of 31
- Santa Rosa, City of 31
- Glendale, City of 31
- Vacaville, City of 30
- …
ACCESS_TYP 4
- Open Access 4,827
- Restricted Access 230
- No Public Access 115
- Unknown Access 20
MNG_AG_TYP 1
- City Agency · 5,192 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7335 | 7335 | 7334 | {"type": "Polygon", "coordinates": [[[-119.81988, 36.72408], [-119.81985, 36.72531], [-119.81777, 36.72532], [-119.8178, 36.7241], [-119.81988, 36.72408]]]} | Open Access 1 | Neilson Park | 22690 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 6.257 | Neilson Park | ||
7337 | 7337 | 7336 | {"type": "Polygon", "coordinates": [[[-121.36136, 37.98621], [-121.36133, 37.98643], [-121.36097, 37.98725], [-121.36089, 37.98729], [-121.36082, 37.98737], [-121.36084, 37.98748], [-121.36095, 37.9875], [-121.36103, 37.9875], [-121.36116, 37.98745], [-121.36116, 37.98823], [-121.35912, 37.98821], [-121.35913, 37.98797], [-121.3591, 37.98777], [-121.35898, 37.98745], [-121.35879, 37.98715], [-121.35854, 37.98689], [-121.35808, 37.98654], [-121.35827, 37.98636], [-121.35862, 37.98624], [-121.36004, 37.98613], [-121.36036, 37.98613], [-121.36136, 37.98621]]]} | Open Access 1 | Nelson Park | 22697 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 11.881 | Nelson Park | ||
7338 | 7338 | 7337 | {"type": "Polygon", "coordinates": [[[-121.95309, 38.34744], [-121.95188, 38.34744], [-121.95186, 38.34764], [-121.95078, 38.34765], [-121.95044, 38.34751], [-121.95006, 38.3475], [-121.94945, 38.34772], [-121.94916, 38.34773], [-121.94891, 38.34763], [-121.94871, 38.3474], [-121.94869, 38.34696], [-121.94884, 38.34673], [-121.94905, 38.34666], [-121.94932, 38.34661], [-121.94961, 38.34638], [-121.94961, 38.34618], [-121.94918, 38.34605], [-121.94937, 38.34573], [-121.95005, 38.34565], [-121.95035, 38.34515], [-121.95043, 38.34516], [-121.95084, 38.34536], [-121.9512, 38.34559], [-121.9516, 38.34597], [-121.95186, 38.3462], [-121.95216, 38.3463], [-121.95269, 38.34638], [-121.953, 38.3464], [-121.95306, 38.34646], [-121.95309, 38.34669], [-121.95309, 38.34744]]]} | Open Access 1 | Nelson Park | 22698 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 16.695 | Nelson Park | ||
7340 | 7340 | 7339 | {"type": "Polygon", "coordinates": [[[-122.27644, 37.78387], [-122.27625, 37.78369], [-122.27553, 37.78258], [-122.27515, 37.78152], [-122.27638, 37.78152], [-122.27644, 37.78387]]]} | Open Access 1 | Neptune Park | 22700 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 4.139 | Neptune Park | ||
7343 | 7343 | 7342 | {"type": "Polygon", "coordinates": [[[-121.45549, 37.74985], [-121.45549, 37.75012], [-121.45482, 37.75012], [-121.45482, 37.74986], [-121.45489, 37.7498], [-121.45542, 37.7498], [-121.45549, 37.74985]]]} | Open Access 1 | New Harmon Park | 22707 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 0.505 | New Harmon Park | ||
7344 | 7344 | 7343 | {"type": "Polygon", "coordinates": [[[-118.25416, 34.23366], [-118.25404, 34.23433], [-118.25313, 34.23376], [-118.25314, 34.23305], [-118.25416, 34.23366]]]} | Open Access 1 | New York Park | 22711 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1.78 | New York Park | ||
7345 | 7345 | 7344 | {"type": "Polygon", "coordinates": [[[-117.73254, 33.59302], [-117.73253, 33.59307], [-117.73166, 33.59479], [-117.73144, 33.59562], [-117.73133, 33.59566], [-117.73088, 33.59553], [-117.73023, 33.59525], [-117.72966, 33.59488], [-117.72903, 33.59433], [-117.72888, 33.59414], [-117.72891, 33.59404], [-117.72909, 33.59393], [-117.72931, 33.59375], [-117.72981, 33.59331], [-117.73016, 33.59294], [-117.73055, 33.59246], [-117.73066, 33.59232], [-117.7308, 33.59208], [-117.73132, 33.59105], [-117.73173, 33.59121], [-117.73157, 33.59153], [-117.73144, 33.59197], [-117.73141, 33.59256], [-117.73145, 33.5926], [-117.73154, 33.59264], [-117.73178, 33.59269], [-117.73191, 33.59274], [-117.73212, 33.59284], [-117.73242, 33.59294], [-117.73253, 33.593], [-117.73254, 33.59302]]]} | Open Access 1 | Ridgecrest Park | 24352 | 1004 | Aliso Viejo, City of 743 | City 2 | City Agency 2 | http://www.cityofalisoviejo.com/CityHall/Departments/EconomicDevelopment/InteractiveMap.aspx?category=1 | City 2 | 19.318 | Ridgecrest Park | ||
7346 | 7346 | 7345 | {"type": "Polygon", "coordinates": [[[-122.04309, 37.54756], [-122.04204, 37.54884], [-122.043, 37.54927], [-122.04271, 37.54949], [-122.04272, 37.5495], [-122.04285, 37.54956], [-122.04234, 37.54989], [-122.04175, 37.55019], [-122.04123, 37.5504], [-122.04059, 37.5506], [-122.04075, 37.55038], [-122.03993, 37.54926], [-122.04072, 37.54829], [-122.04156, 37.5465], [-122.04277, 37.54732], [-122.04309, 37.54756]]]} | Open Access 1 | Newark Community Park | 22712 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 16.332 | Newark Community Park | 1973 | |
7347 | 7347 | 7346 | {"type": "Polygon", "coordinates": [[[-122.01182, 37.51583], [-122.01166, 37.51629], [-122.01053, 37.51879], [-122.01011, 37.51977], [-122.00949, 37.51959], [-122.0089, 37.51937], [-122.00863, 37.51996], [-122.00771, 37.51964], [-122.00981, 37.51481], [-122.01051, 37.51513], [-122.01045, 37.51521], [-122.01046, 37.51523], [-122.01182, 37.51583]]]} | Open Access 1 | Newark Sportsfield Park | 22713 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 25.975 | Newark Sportsfield Park | 1984 | |
7348 | 7348 | 7347 | {"type": "Polygon", "coordinates": [[[-117.29528, 34.18298], [-117.29413, 34.18249], [-117.29299, 34.18199], [-117.29314, 34.18175], [-117.29427, 34.18224], [-117.29478, 34.18238], [-117.29482, 34.1824], [-117.29528, 34.18298]]]} | Open Access 1 | Newberry Park | 22714 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 1.653 | Newberry Park | ||
7349 | 7349 | 7348 | {"type": "Polygon", "coordinates": [[[-124.13906, 40.59247], [-124.13676, 40.59354], [-124.13602, 40.5939], [-124.13375, 40.59256], [-124.13595, 40.59061], [-124.13772, 40.59169], [-124.13906, 40.59247]]]} | Open Access 1 | Newburg Park | 22715 | 1434 | Fortuna, City of 974 | City 2 | City Agency 2 | http://friendlyfortuna.com/index.aspx?nid=95 | City 2 | 20.167 | Newburg Park | ||
7352 | 7352 | 7351 | {"type": "Polygon", "coordinates": [[[-118.03541, 34.14555], [-118.03539, 34.14633], [-118.03528, 34.14666], [-118.03358, 34.14558], [-118.03541, 34.14555]]]} | Open Access 1 | Newcastle Park | 22718 | 1009 | Arcadia, City of 299 | City 2 | City Agency 2 | http://www.ci.arcadia.ca.us/home/index.asp?page=1160 | City 2 | 2.661 | Newcastle Park | ||
7353 | 7353 | 7352 | {"type": "Polygon", "coordinates": [[[-121.14527, 37.47444], [-121.14472, 37.47469], [-121.14451, 37.47482], [-121.14451, 37.47484], [-121.14457, 37.47488], [-121.14435, 37.47509], [-121.14375, 37.47469], [-121.14375, 37.47462], [-121.14395, 37.47443], [-121.14407, 37.47433], [-121.14432, 37.47419], [-121.14487, 37.47396], [-121.14497, 37.47398], [-121.14527, 37.47444]]]} | Open Access 1 | Newcastle Park | 22719 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.055 | Newcastle Park | ||
7354 | 7354 | 7353 | {"type": "Polygon", "coordinates": [[[-117.95924, 33.74856], [-117.95924, 33.74929], [-117.95809, 33.74929], [-117.95808, 33.74857], [-117.95924, 33.74856]]]} | Open Access 1 | Newcastle Park | 22720 | 1378 | Westminster, City of 149 | City 2 | City Agency 2 | http://www.westminster-ca.gov/depts/cs/parks_n_facilities/default.asp | City 2 | 2.116 | Newcastle Park | ||
7357 | 7357 | 7356 | {"type": "Polygon", "coordinates": [[[-117.71219, 33.96046], [-117.71194, 33.96077], [-117.71215, 33.96092], [-117.70864, 33.96093], [-117.70864, 33.9609], [-117.7094, 33.96076], [-117.7099, 33.96075], [-117.71016, 33.9607], [-117.71016, 33.96007], [-117.70972, 33.95988], [-117.70972, 33.95969], [-117.70982, 33.95951], [-117.70982, 33.95944], [-117.70995, 33.9594], [-117.71007, 33.95927], [-117.71039, 33.95909], [-117.71086, 33.95968], [-117.71219, 33.96046]]]} | Open Access 1 | Rincon Park | 24368 | 1054 | Chino Hills, City of 116 | City 2 | City Agency 2 | http://www.chinohills.org/index.aspx?nid=364 | City 2 | 6.754 | Rincon Park | ||
7358 | 7358 | 7357 | {"type": "MultiPolygon", "coordinates": [[[[-121.99479, 37.96098], [-121.99442, 37.96146], [-121.99399, 37.96144], [-121.99403, 37.96088], [-121.99396, 37.96089], [-121.99183, 37.96056], [-121.99172, 37.96131], [-121.99205, 37.96149], [-121.99196, 37.96148], [-121.98214, 37.95919], [-121.98101, 37.95825], [-121.98095, 37.95832], [-121.98086, 37.95824], [-121.98071, 37.95815], [-121.97998, 37.95788], [-121.98003, 37.95778], [-121.9799, 37.95772], [-121.97958, 37.95739], [-121.97949, 37.95719], [-121.97934, 37.95713], [-121.97922, 37.95697], [-121.97906, 37.95686], [-121.97912, 37.95673], [-121.97732, 37.9551], [-121.97713, 37.95541], [-121.97633, 37.95481], [-121.97615, 37.9551], [-121.97479, 37.95388], [-121.97489, 37.9537], [-121.97495, 37.95323], [-121.9749, 37.95287], [-121.97476, 37.95274], [-121.9745, 37.95284], [-121.97436, 37.95267], [-121.97421, 37.95257], [-121.97392, 37.95245], [-121.97357, 37.9524], [-121.97354, 37.95235], [-121.97369, 37.95218], [-121.97391, 37.95198], [-121.97399, 37.95204], [-121.97428, 37.95189], [-121.9746, 37.9518], [-121.97494, 37.95177], [-121.97582, 37.95177], [-121.9762, 37.9517], [-121.97642, 37.95164], [-121.97649, 37.95166], [-121.97652, 37.95165], [-121.97747, 37.953], [-121.97842, 37.95399], [-121.97859, 37.95411], [-121.97896, 37.95432], [-121.97948, 37.95457], [-121.97963, 37.95468], [-121.97991, 37.95492], [-121.98074, 37.95585], [-121.98083, 37.95592], [-121.98101, 37.95603], [-121.98123, 37.95611], [-121.98146, 37.95614], [-121.98169, 37.95615], [-121.98192, 37.95611], [-121.98223, 37.95599], [-121.98294, 37.95557], [-121.98323, 37.95543], [-121.98337, 37.95575], [-121.98352, 37.9559], [-121.98373, 37.95599], [-121.98404, 37.95607], [-121.98443, 37.95627], [-121.98547, 37.95672], [-121.98586, 37.9568], [-121.98622, 37.95681], [-121.98672, 37.95699], [-121.98698, 37.95704], [-121.98722, 37.95706], [-121.98763, 37.95721], [-121.98795, 37.95742], [-121.98819, 37.95767], [-121.98833, 37.95779], [-121.98847, 37.95797], [-121.98886, 37.95827], [-121.9891, 37.95835], [-121.98911, 37.95883], [-121.98865, 37.95901], [-121.98865, 37.9593], [-121.98851, 37.95931], [-121.98847, 37.95932], [-121.98843, 37.95935], [-121.9884, 37.95941], [-121.98842, 37.95949], [-121.98851, 37.95954], [-121.98856, 37.95955], [-121.98863, 37.95953], [-121.98869, 37.95948], [-121.98871, 37.95968], [-121.99005, 37.95967], [-121.99025, 37.9597], [-121.9905, 37.95977], [-121.99072, 37.9598], [-121.99079, 37.95956], [-121.99101, 37.95957], [-121.99117, 37.95954], [-121.99138, 37.95947], [-121.99155, 37.95939], [-121.9918, 37.95952], [-121.99202, 37.9596], [-121.99236, 37.95965], [-121.99242, 37.95985], [-121.99256, 37.96009], [-121.99288, 37.96023], [-121.99367, 37.96017], [-121.99372, 37.96025], [-121.99382, 37.96033], [-121.99407, 37.96016], [-121.99418, 37.96025], [-121.99396, 37.96045], [-121.99409, 37.96056], [-121.99418, 37.96069], [-121.99436, 37.96084], [-121.99479, 37.96098]]], [[[-121.98862, 37.96075], [-121.9885, 37.96096], [-121.98795, 37.96077], [-121.988, 37.96068], [-121.98799, 37.96066], [-121.98784, 37.96061], [-121.9878, 37.96067], [-121.98744, 37.96049], [-121.98862, 37.96075]]]]} | Open Access 1 | Newhall Community Park | 22724 | 1066 | Concord, City of 385 | City 2 | City Agency 2 | http://www.ci.concord.ca.us/page.asp?pid=3002 | City 2 | 116.939 | Newhall Community Park | ||
7360 | 7360 | 7359 | {"type": "Polygon", "coordinates": [[[-117.9777, 33.67712], [-117.97736, 33.67712], [-117.9772, 33.67696], [-117.9771, 33.67669], [-117.97696, 33.67661], [-117.97684, 33.67658], [-117.9756, 33.67659], [-117.97544, 33.67656], [-117.97563, 33.6763], [-117.97762, 33.6763], [-117.97766, 33.67633], [-117.97769, 33.67638], [-117.9777, 33.67712]]]} | Open Access 1 | Newland Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/newland-park.cfm | 22728 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 2.248 | Newland Park | |
7361 | 7361 | 7360 | {"type": "Polygon", "coordinates": [[[-121.02895, 37.31704], [-121.02791, 37.31731], [-121.02765, 37.31665], [-121.02793, 37.31657], [-121.02778, 37.31619], [-121.02855, 37.316], [-121.02895, 37.31704]]]} | Open Access 1 | Newman holding 1 | 22729 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 2.644 | Newman holding 1 | ||
7362 | 7362 | 7361 | {"type": "MultiPolygon", "coordinates": [[[[-117.37978, 33.97615], [-117.37952, 33.97656], [-117.37949, 33.97657], [-117.37945, 33.97657], [-117.37897, 33.97634], [-117.37903, 33.97625], [-117.3794, 33.97624], [-117.37964, 33.9762], [-117.37978, 33.97615]]], [[[-117.3806, 33.97735], [-117.38008, 33.97814], [-117.37913, 33.97771], [-117.37967, 33.97692], [-117.3806, 33.97735]]]]} | Open Access 1 | Newman Park | 22730 | 1279 | Riverside, City of 185 | City 2 | City Agency 2 | http://www.riversideca.gov/park_rec/ | City 2 | 2.886 | Newman Park | ||
7364 | 7364 | 7363 | {"type": "Polygon", "coordinates": [[[-117.92126, 33.6122], [-117.92123, 33.61223], [-117.92099, 33.61213], [-117.92098, 33.61208], [-117.92101, 33.61201], [-117.92107, 33.61195], [-117.92113, 33.612], [-117.92126, 33.6122]]]} | Open Access 1 | Newport Beach holding 1 | 22733 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 0.098 | Newport Beach holding 1 |
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]);