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
- Los Angeles, City of 394
- San Diego, City of 379
- San Jose, City of 194
- San Francisco, City and County of 185
- Sacramento, City of 180
- Ventura, City of 142
- Long Beach, City of 128
- Roseville, City of 112
- Oakland, City of 96
- Irvine, City of 88
- Fresno, City of 83
- Torrance, City of 70
- Stockton, City of 69
- Huntington Beach, City of 66
- Tracy, City of 66
- Modesto, City of 64
- Santa Cruz, City of 63
- Chula Vista, City of 62
- Poway, City of 61
- Santa Rosa, City of 59
- Davis, City of 57
- Napa, City of 57
- Clovis, City of 57
- San Luis Obispo, City of 56
- Santa Barbara, City of 55
- Encinitas, City of 55
- San Ramon, City of 53
- Newport Beach, City of 51
- Rocklin, City of 51
- Manteca, City of 47
- …
ACCESS_TYP 4
- Open Access 7,956
- Restricted Access 273
- No Public Access 140
- Unknown Access 28
MNG_AG_TYP 1
- City Agency · 8,397 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3016 | 3016 | 3015 | {"type": "Polygon", "coordinates": [[[-122.46344, 37.66183], [-122.46339, 37.66197], [-122.46341, 37.6623], [-122.46328, 37.66235], [-122.46299, 37.6623], [-122.46288, 37.66226], [-122.46328, 37.66174], [-122.46344, 37.66183]]]} | Open Access 1 | Clay Avenue Park | 17396 | 1341 | South San Francisco, City of 58 | City 2 | City Agency 2 | http://www.ssf.net/377/Parks-Recreation | City 2 | 0.473 | Clay Avenue Park | ||
3017 | 3017 | 3016 | {"type": "Polygon", "coordinates": [[[-121.6595, 36.67057], [-121.65909, 36.67063], [-121.659, 36.67022], [-121.65942, 36.67016], [-121.6595, 36.67057]]]} | Open Access 1 | Clay Park | 17397 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 0.426 | Clay Park | ||
3020 | 3020 | 3019 | {"type": "Polygon", "coordinates": [[[-121.5787, 38.53965], [-121.57863, 38.53968], [-121.5782, 38.53934], [-121.57791, 38.53934], [-121.57786, 38.53936], [-121.5778, 38.5393], [-121.57794, 38.53899], [-121.57801, 38.539], [-121.57814, 38.53905], [-121.57832, 38.53903], [-121.57845, 38.53906], [-121.57835, 38.53935], [-121.5787, 38.53965]]]} | Open Access 1 | Classics Mini Park | 17393 | 1376 | West Sacramento, City of 541 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 0.506 | Classics MP | ||
3021 | 3021 | 3020 | {"type": "Polygon", "coordinates": [[[-117.1262, 32.70317], [-117.12603, 32.70317], [-117.12603, 32.70279], [-117.12619, 32.70279], [-117.1262, 32.70317]]]} | Open Access 1 | Clay Avenue Mini Park | 17395 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.166 | Clay Avenue MP | ||
3022 | 3022 | 3021 | {"type": "MultiPolygon", "coordinates": [[[[-117.9237, 33.62326], [-117.92361, 33.6234], [-117.92352, 33.62348], [-117.92347, 33.62349], [-117.92332, 33.62349], [-117.92317, 33.62339], [-117.92316, 33.62333], [-117.92317, 33.62316], [-117.92309, 33.62302], [-117.92296, 33.62292], [-117.9228, 33.62287], [-117.92264, 33.62286], [-117.92247, 33.62291], [-117.92216, 33.62314], [-117.92203, 33.62321], [-117.92177, 33.62327], [-117.92158, 33.62328], [-117.92137, 33.62325], [-117.92123, 33.6232], [-117.92119, 33.62318], [-117.92117, 33.62314], [-117.92118, 33.6231], [-117.92136, 33.62291], [-117.92148, 33.62285], [-117.92198, 33.62287], [-117.92221, 33.62285], [-117.92258, 33.62276], [-117.92295, 33.62254], [-117.92316, 33.62235], [-117.92335, 33.62213], [-117.92334, 33.62226], [-117.9237, 33.6228], [-117.9237, 33.62326]]], [[[-117.92517, 33.6225], [-117.92411, 33.62251], [-117.92393, 33.62196], [-117.92421, 33.62206], [-117.92446, 33.62211], [-117.92481, 33.6221], [-117.9251, 33.62204], [-117.92517, 33.6225]]]]} | Open Access 1 | Cliff Drive Park | 17424 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 4.15 | Cliff Drive Park | ||
3023 | 3023 | 3022 | {"type": "MultiPolygon", "coordinates": [[[[-121.79303, 38.68953], [-121.79303, 38.68978], [-121.793, 38.68976], [-121.79182, 38.68975], [-121.79135, 38.68992], [-121.79135, 38.68994], [-121.79148, 38.69015], [-121.79152, 38.69017], [-121.79134, 38.69024], [-121.79109, 38.6903], [-121.79059, 38.69035], [-121.79055, 38.69034], [-121.79052, 38.69031], [-121.79042, 38.69003], [-121.79023, 38.68971], [-121.7902, 38.68954], [-121.7902, 38.6895], [-121.79023, 38.68952], [-121.79133, 38.68953], [-121.79135, 38.6895], [-121.79136, 38.68927], [-121.79133, 38.68924], [-121.79145, 38.68925], [-121.79143, 38.68927], [-121.79142, 38.6895], [-121.79145, 38.68953], [-121.793, 38.68954], [-121.79303, 38.68953]]], [[[-121.79678, 38.69034], [-121.79678, 38.69045], [-121.79643, 38.69046], [-121.79642, 38.69086], [-121.79652, 38.69115], [-121.79652, 38.69146], [-121.79647, 38.69151], [-121.79645, 38.69156], [-121.79646, 38.69163], [-121.79652, 38.69168], [-121.79651, 38.69198], [-121.7963, 38.69198], [-121.79631, 38.6917], [-121.79622, 38.69165], [-121.79624, 38.69158], [-121.79622, 38.69151], [-121.79631, 38.69146], [-121.79631, 38.69099], [-121.79623, 38.69094], [-121.79625, 38.69086], [-121.79623, 38.69081], [-121.79619, 38.69076], [-121.79618, 38.69049], [-121.79463, 38.69047], [-121.79463, 38.69026], [-121.79458, 38.69021], [-121.79463, 38.69013], [-121.79462, 38.69006], [-121.79458, 38.69002], [-121.79463, 38.68997], [-121.79463, 38.68976], [-121.79324, 38.68975], [-121.79324, 38.68959], [-121.79463, 38.68959], [-121.79464, 38.68938], [-121.79459, 38.68934], [-121.79463, 38.6893], [-121.79464, 38.68925], [-121.79463, 38.68919], [-121.79459, 38.68914], [-121.79464, 38.68909], [-121.79465, 38.68857], [-121.79482, 38.68857], [-121.79482, 38.6891], [-121.79487, 38.68914], [-121.79483, 38.68919], [-121.79482, 38.68925], [-121.79483, 38.6893], [-121.79488, 38.68935], [-121.79488, 38.68959], [-121.79526, 38.6896], [-121.79526, 38.68985], [-121.79537, 38.6899], [-121.79536, 38.68996], [-121.79538, 38.69002], [-121.79526, 38.69009], [-121.79526, 38.69032], [-121.79678, 38.69034]]], [[[-121.7977, 38.69031], [-121.7977, 38.69039], [-121.79695, 38.69039], [-121.79695, 38.69031], [-121.7977, 38.69031]]]]} | Open Access 1 | Cline Park | 17427 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 6.798 | Cline Park | ||
3024 | 3024 | 3023 | {"type": "Polygon", "coordinates": [[[-117.71921, 33.53755], [-117.71913, 33.53757], [-117.71898, 33.53748], [-117.71843, 33.53736], [-117.71805, 33.53742], [-117.71787, 33.53751], [-117.71782, 33.53751], [-117.71759, 33.53765], [-117.71707, 33.53762], [-117.7171, 33.53747], [-117.71708, 33.53721], [-117.71702, 33.53708], [-117.71684, 33.53681], [-117.71714, 33.53673], [-117.71745, 33.53672], [-117.71795, 33.53639], [-117.71798, 33.53615], [-117.71812, 33.53628], [-117.71854, 33.53612], [-117.71862, 33.53611], [-117.71872, 33.53621], [-117.71876, 33.53627], [-117.7188, 33.53639], [-117.71879, 33.53653], [-117.71869, 33.53678], [-117.71864, 33.53698], [-117.71865, 33.5371], [-117.7187, 33.53719], [-117.71918, 33.53749], [-117.71921, 33.53755]]]} | Open Access 1 | Clipper Cove Park | 17429 | 1166 | Laguna Niguel, City of 525 | City 2 | City Agency 2 | http://www.cityoflagunaniguel.org/index.aspx?nid=12 | City 2 | 4.813 | Clipper Cove Park | ||
3025 | 3025 | 3024 | {"type": "Polygon", "coordinates": [[[-122.44339, 37.74797], [-122.44285, 37.74806], [-122.44281, 37.74805], [-122.44331, 37.74755], [-122.44337, 37.74755], [-122.44339, 37.74797]]]} | Open Access 1 | Clipper Terrace Community Garden | 17430 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 0.341 | Clipper Terrace Community Garden | ||
3026 | 3026 | 3025 | {"type": "Polygon", "coordinates": [[[-116.30786, 33.66029], [-116.30786, 33.66042], [-116.30753, 33.66042], [-116.30753, 33.65987], [-116.30781, 33.65987], [-116.30786, 33.65989], [-116.30786, 33.66029]]]} | Open Access 1 | Eisenhower Park | 18473 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 0.461 | Eisenhower Park | ||
3028 | 3028 | 3027 | {"type": "Polygon", "coordinates": [[[-117.6095, 33.88962], [-117.6076, 33.89127], [-117.6075, 33.8913], [-117.60728, 33.8913], [-117.60713, 33.89124], [-117.60607, 33.8904], [-117.60678, 33.89012], [-117.60849, 33.88949], [-117.60898, 33.88928], [-117.60903, 33.88925], [-117.60907, 33.88926], [-117.6095, 33.88962]]]} | Open Access 1 | Clearwater Park | 17416 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 7.81 | Clearwater Park | ||
3030 | 3030 | 3029 | {"type": "Polygon", "coordinates": [[[-120.86359, 35.39163], [-120.86355, 35.39175], [-120.86353, 35.39164], [-120.86351, 35.39164], [-120.86345, 35.39178], [-120.86333, 35.39125], [-120.86316, 35.39108], [-120.86239, 35.3907], [-120.86204, 35.3907], [-120.86169, 35.39087], [-120.86074, 35.39205], [-120.86053, 35.39174], [-120.86037, 35.39141], [-120.86033, 35.39126], [-120.86028, 35.39099], [-120.86026, 35.39041], [-120.86022, 35.39011], [-120.86011, 35.3896], [-120.86, 35.38931], [-120.85988, 35.38903], [-120.85973, 35.38875], [-120.85947, 35.38834], [-120.85942, 35.38818], [-120.85941, 35.38802], [-120.85943, 35.38792], [-120.85951, 35.38779], [-120.85949, 35.38759], [-120.85952, 35.38746], [-120.86024, 35.38781], [-120.86057, 35.38781], [-120.86092, 35.38766], [-120.86156, 35.38659], [-120.86147, 35.38643], [-120.86145, 35.3863], [-120.86146, 35.38617], [-120.86152, 35.38598], [-120.86152, 35.38584], [-120.86147, 35.38572], [-120.86131, 35.38547], [-120.86125, 35.38532], [-120.8612, 35.38512], [-120.86119, 35.38492], [-120.86163, 35.38487], [-120.86167, 35.38498], [-120.86164, 35.38509], [-120.86145, 35.38523], [-120.86135, 35.38534], [-120.86136, 35.38542], [-120.86151, 35.38555], [-120.86176, 35.3856], [-120.86184, 35.38563], [-120.86187, 35.38567], [-120.86188, 35.38588], [-120.8618, 35.38608], [-120.86187, 35.38621], [-120.86183, 35.38636], [-120.86185, 35.38653], [-120.86183, 35.38675], [-120.86188, 35.38695], [-120.86178, 35.38711], [-120.86176, 35.38732], [-120.86165, 35.38754], [-120.86161, 35.3877], [-120.86161, 35.38821], [-120.86144, 35.38857], [-120.86141, 35.3887], [-120.86146, 35.38922], [-120.86153, 35.38954], [-120.86165, 35.38978], [-120.86188, 35.3901], [-120.86189, 35.39019], [-120.86188, 35.39026], [-120.86183, 35.39032], [-120.86176, 35.39035], [-120.86173, 35.3904], [-120.86179, 35.39049], [-120.8621, 35.39061], [-120.8624, 35.39057], [-120.86251, 35.3906], [-120.86267, 35.39069], [-120.86318, 35.39087], [-120.8633, 35.39098], [-120.86332, 35.39098], [-120.86344, 35.39107], [-120.86347, 35.39116], [-120.86353, 35.39129], [-120.86357, 35.39144], [-120.86357, 35.39161], [-120.86359, 35.39163]]]} | Open Access 1 | Cloisters Park | 17431 | 1453 | Morro Bay, City of 638 | City 2 | City Agency 2 | http://www.morro-bay.ca.us/index.aspx?nid=292 | City 2 | 19.605 | Cloisters Park | ||
3031 | 3031 | 3030 | {"type": "Polygon", "coordinates": [[[-122.48723, 37.85269], [-122.48677, 37.85288], [-122.48659, 37.85247], [-122.48659, 37.85247], [-122.48723, 37.85269]]]} | Open Access 1 | Cloud View Park | 17433 | 1327 | Sausalito, City of 439 | City 2 | City Agency 2 | http://www.ci.sausalito.ca.us/index.aspx?page=156 | City 2 | 0.269 | Cloud View Park | ||
3032 | 3032 | 3031 | {"type": "Polygon", "coordinates": [[[-122.32107, 40.56945], [-122.32105, 40.5701], [-122.32103, 40.5702], [-122.32098, 40.57029], [-122.32093, 40.57036], [-122.32089, 40.57038], [-122.3208, 40.57037], [-122.31959, 40.56979], [-122.31959, 40.56969], [-122.32107, 40.56945]]]} | Open Access 1 | Clover Creek Park | 17435 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.875 | Clover Creek Park | ||
3033 | 3033 | 3032 | {"type": "Polygon", "coordinates": [[[-122.32205, 40.55148], [-122.32199, 40.55645], [-122.3148, 40.55648], [-122.31478, 40.55438], [-122.31469, 40.55436], [-122.31468, 40.55392], [-122.31465, 40.55367], [-122.31461, 40.55302], [-122.31457, 40.55291], [-122.3145, 40.55278], [-122.31431, 40.55258], [-122.3141, 40.55241], [-122.31391, 40.55228], [-122.31346, 40.55207], [-122.31328, 40.55193], [-122.31296, 40.55162], [-122.31212, 40.55114], [-122.31165, 40.55096], [-122.31126, 40.55071], [-122.31081, 40.55051], [-122.3106, 40.55038], [-122.30834, 40.54925], [-122.31485, 40.54923], [-122.31487, 40.54926], [-122.31508, 40.54926], [-122.31556, 40.54969], [-122.31614, 40.54982], [-122.31621, 40.54973], [-122.31576, 40.54931], [-122.31848, 40.54931], [-122.31848, 40.54976], [-122.31852, 40.54977], [-122.31852, 40.55097], [-122.31848, 40.55101], [-122.31849, 40.55103], [-122.32024, 40.55199], [-122.32066, 40.55188], [-122.32067, 40.55147], [-122.32205, 40.55148]]]} | Open Access 1 | Clover Creek Preserve | 17436 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 127.585 | Clover Creek Preserve | ||
3034 | 3034 | 3033 | {"type": "Polygon", "coordinates": [[[-118.45832, 34.01723], [-118.4583, 34.01727], [-118.45684, 34.01811], [-118.45488, 34.01578], [-118.45484, 34.01579], [-118.45475, 34.0156], [-118.45409, 34.01503], [-118.45554, 34.0138], [-118.45587, 34.01428], [-118.45629, 34.01483], [-118.45632, 34.01484], [-118.45832, 34.01723]]]} | Open Access 1 | Clover Park | 17437 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 18.672 | Clover Park | ||
3035 | 3035 | 3034 | {"type": "Polygon", "coordinates": [[[-121.24331, 38.80602], [-121.2432, 38.80631], [-121.24303, 38.80634], [-121.24295, 38.80653], [-121.24276, 38.80664], [-121.24263, 38.80694], [-121.2429, 38.80719], [-121.24268, 38.80733], [-121.24243, 38.8071], [-121.24221, 38.80711], [-121.24204, 38.80721], [-121.24158, 38.80677], [-121.2422, 38.80622], [-121.24189, 38.80598], [-121.24214, 38.8058], [-121.24244, 38.80565], [-121.24265, 38.80556], [-121.24271, 38.80556], [-121.24287, 38.80573], [-121.24303, 38.80586], [-121.24331, 38.80602]]]} | Open Access 1 | Clover Valley Park | 17439 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 3.73 | Clover Valley Park | ||
3036 | 3036 | 3035 | {"type": "Polygon", "coordinates": [[[-118.40368, 33.77234], [-118.40368, 33.7725], [-118.40332, 33.7725], [-118.40326, 33.77253], [-118.40326, 33.77231], [-118.40331, 33.77234], [-118.40368, 33.77234]]]} | Open Access 1 | Clovercliff Park | http://ca-ranchopalosverdes.civicplus.com/Facilities/Facility/Details/Clovercliff-Park-2 | 17440 | 1265 | Rancho Palos Verdes, City of 283 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 0.177 | Clovercliff Park | |
3037 | 3037 | 3036 | {"type": "Polygon", "coordinates": [[[-123.02615, 38.80458], [-123.02333, 38.80518], [-123.02292, 38.80422], [-123.02556, 38.80366], [-123.02615, 38.80458]]]} | Open Access 1 | Cloverdale City Park | 17442 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 6.77 | Cloverdale City Park | ||
3038 | 3038 | 3037 | {"type": "Polygon", "coordinates": [[[-117.96085, 33.73497], [-117.9595, 33.73555], [-117.95934, 33.73531], [-117.95943, 33.73525], [-117.95952, 33.73515], [-117.95957, 33.73499], [-117.95957, 33.73468], [-117.95962, 33.73466], [-117.96075, 33.73465], [-117.96085, 33.73497]]]} | Open Access 1 | Cloverdale Park | 17443 | 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.021 | Cloverdale Park | ||
3040 | 3040 | 3039 | {"type": "Polygon", "coordinates": [[[-123.01294, 38.81679], [-123.0129, 38.81679], [-123.01281, 38.81658], [-123.01155, 38.81652], [-123.01151, 38.81674], [-123.0114, 38.81674], [-123.01073, 38.81518], [-123.00987, 38.81458], [-123.00961, 38.81387], [-123.00919, 38.81341], [-123.00885, 38.8126], [-123.00868, 38.81232], [-123.00835, 38.81149], [-123.00794, 38.81075], [-123.00768, 38.81019], [-123.00773, 38.80922], [-123.0079, 38.8089], [-123.00898, 38.80835], [-123.00914, 38.80831], [-123.00903, 38.8088], [-123.00904, 38.80895], [-123.00917, 38.80931], [-123.00971, 38.81026], [-123.00985, 38.81038], [-123.01012, 38.81049], [-123.01041, 38.81068], [-123.01059, 38.81082], [-123.01077, 38.81103], [-123.01003, 38.81127], [-123.01, 38.8115], [-123.0103, 38.81233], [-123.01099, 38.81379], [-123.01181, 38.81356], [-123.01206, 38.81445], [-123.01294, 38.81679]]]} | Open Access 1 | Cloverdale River Park | 17445 | 1059 | Cloverdale, City of 404 | City 2 | City Agency 2 | http://www.cloverdale.net/index.aspx?nid=152 | City 2 | 33.88 | Cloverdale River 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]);