superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
356 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 2 sorted by PARK_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 19
- Whittier, City of 19
- San Ramon, City of 15
- San Diego, City of 9
- Long Beach, City of 9
- Manhattan Beach, City of 8
- San Jose, City of 6
- Hollister, City of 6
- Pasadena, City of 6
- Modesto, City of 6
- Santa Ana, City of 5
- Fullerton, City of 5
- Carlsbad, City of 5
- San Bernardino, City of 5
- Beverly Hills, City of 5
- Arcadia, City of 5
- Lawndale, City of 5
- San Gabriel, City of 5
- Santa Cruz, City of 4
- Glendora, City of 4
- Vacaville, City of 4
- El Segundo, City of 4
- Stockton, City of 4
- Mountain View, City of 4
- Roseville, City of 4
- South El Monte, City of 4
- Watsonville, City of 3
- Oceanside, City of 3
- Pomona, City of 3
- Burbank, City of 3
- …
MNG_AG_TYP 1
- City Agency · 336 ✖
ACCESS_TYP 1
- Restricted Access · 336 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3344 | 3344 | 3343 | {"type": "Polygon", "coordinates": [[[-118.15633, 33.9544], [-118.15556, 33.95835], [-118.15532, 33.95831], [-118.15543, 33.95776], [-118.15532, 33.95757], [-118.15526, 33.95754], [-118.15527, 33.9572], [-118.15505, 33.95697], [-118.15296, 33.95675], [-118.15268, 33.95647], [-118.15483, 33.95531], [-118.15633, 33.9544]]]} | Restricted Access 2 | Bell Gardens Golf Course at Ford Park | 33117 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 12.798 | Bell Gardens GC at Ford Park | ||
307 | 307 | 306 | {"type": "Polygon", "coordinates": [[[-118.2635, 34.06257], [-118.26306, 34.06324], [-118.26301, 34.06325], [-118.26135, 34.0625], [-118.2617, 34.06184], [-118.2635, 34.06257]]]} | Restricted Access 2 | Belmont High School Park | 31940 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 3.75 | Belmont High School Park | ||
9098 | 9098 | 9097 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66228, 38.42631], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65548, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41986], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41742], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.4222], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | Bennett Valley Municipal Golf Course | 33093 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 150.959 | Bennett Valley Municipal GC | ||
169 | 169 | 168 | {"type": "MultiPolygon", "coordinates": [[[[-118.41144, 34.06052], [-118.41139, 34.0606], [-118.41084, 34.06086], [-118.41086, 34.06092], [-118.41072, 34.06099], [-118.41068, 34.06094], [-118.40952, 34.06146], [-118.40927, 34.06126], [-118.40916, 34.06114], [-118.40908, 34.061], [-118.40903, 34.06085], [-118.40902, 34.0607], [-118.40902, 34.06015], [-118.40961, 34.05987], [-118.40985, 34.05982], [-118.40998, 34.05983], [-118.41003, 34.05986], [-118.4101, 34.05989], [-118.41017, 34.05998], [-118.41025, 34.05995], [-118.4103, 34.06002], [-118.41097, 34.05971], [-118.4114, 34.06031], [-118.41144, 34.06044], [-118.41144, 34.06052]]], [[[-118.41243, 34.06254], [-118.41206, 34.06271], [-118.41213, 34.06284], [-118.41212, 34.06285], [-118.41172, 34.06272], [-118.41123, 34.06236], [-118.411, 34.06223], [-118.41066, 34.0618], [-118.41142, 34.06141], [-118.41159, 34.06162], [-118.41191, 34.06147], [-118.41231, 34.06203], [-118.41218, 34.06212], [-118.41226, 34.06224], [-118.41224, 34.06227], [-118.41243, 34.06254]]]]} | Restricted Access 2 | Beverly Hills High School Park | 31849 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 10.454 | Beverly Hills High School Park | ||
235 | 235 | 234 | {"type": "Polygon", "coordinates": [[[-118.39479, 34.06229], [-118.39479, 34.06361], [-118.39394, 34.06362], [-118.39394, 34.06229], [-118.39479, 34.06229]]]} | Restricted Access 2 | Beverly Vista Elementary School Park | 31882 | 1029 | Beverly Hills, City of 200 | City 2 | City Agency 2 | http://www.beverlyhills.org/living/recreationparks/ | City 2 | 2.838 | Beverly Vista Elementary School Park | ||
14604 | 14604 | 14603 | {"type": "Polygon", "coordinates": [[[-119.96788, 38.93696], [-119.96716, 38.93808], [-119.96692, 38.93882], [-119.96734, 38.93893], [-119.96695, 38.93973], [-119.96669, 38.94016], [-119.9666, 38.94043], [-119.9664, 38.94067], [-119.96631, 38.94081], [-119.96625, 38.94096], [-119.96611, 38.94122], [-119.96603, 38.94149], [-119.96602, 38.94177], [-119.96604, 38.94205], [-119.96572, 38.94257], [-119.96554, 38.94452], [-119.96536, 38.94453], [-119.96523, 38.94455], [-119.96498, 38.94465], [-119.96485, 38.94474], [-119.96423, 38.94526], [-119.9642, 38.94528], [-119.96415, 38.94528], [-119.964, 38.94391], [-119.96426, 38.94259], [-119.96414, 38.94251], [-119.96435, 38.94196], [-119.96434, 38.9418], [-119.96449, 38.94166], [-119.96448, 38.94092], [-119.96347, 38.94023], [-119.96245, 38.94032], [-119.96204, 38.93986], [-119.962, 38.93969], [-119.96214, 38.93955], [-119.96216, 38.93944], [-119.9634, 38.93944], [-119.96429, 38.93878], [-119.96429, 38.93697], [-119.96662, 38.93695], [-119.96788, 38.93696]]]} | Restricted Access 2 | Bijou Municipal Golf Course | 33083 | 1411 | South Lake Tahoe, City of 954 | City 2 | City Agency 2 | http://www.cityofslt.us/index.aspx?nid=196 | City 2 | 46.221 | Bijou Municipal GC | 1920 | |
308 | 308 | 307 | {"type": "Polygon", "coordinates": [[[-118.50705, 34.19144], [-118.50564, 34.19144], [-118.5056, 34.19012], [-118.50703, 34.19012], [-118.50705, 34.19144]]]} | Restricted Access 2 | Birmingham High School Park | 31941 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 4.739 | Birmingham High School Park | ||
7705 | 7705 | 7704 | {"type": "Polygon", "coordinates": [[[-122.06149, 37.31998], [-122.06122, 37.32014], [-122.061, 37.32033], [-122.06093, 37.32047], [-122.06052, 37.3209], [-122.0604, 37.32111], [-122.06035, 37.32174], [-122.06037, 37.32207], [-122.06071, 37.32234], [-122.06046, 37.32244], [-122.06041, 37.32289], [-122.05932, 37.32293], [-122.05955, 37.32208], [-122.05953, 37.32183], [-122.05959, 37.32144], [-122.05951, 37.3212], [-122.05948, 37.32082], [-122.05925, 37.32048], [-122.05923, 37.32027], [-122.05923, 37.3198], [-122.05918, 37.31953], [-122.05906, 37.31943], [-122.05906, 37.31811], [-122.05955, 37.31789], [-122.05996, 37.31769], [-122.06007, 37.31768], [-122.06043, 37.3185], [-122.06149, 37.31998]]]} | Restricted Access 2 | Blackberry Farm Golf Course | 33038 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 16.751 | Blackberry Farm GC | ||
14531 | 14531 | 14530 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.0185], [-117.02409, 33.01859], [-117.02226, 33.01869], [-117.02223, 33.01607], [-117.02353, 33.01605], [-117.02405, 33.01608], [-117.02415, 33.01631], [-117.02426, 33.01652], [-117.02438, 33.01672], [-117.02457, 33.01696], [-117.0249, 33.01729], [-117.02514, 33.01748], [-117.02536, 33.01762]]]} | Restricted Access 2 | Blue Sky Ecological Reserve | 29221 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 15.494 | Blue Sky ER | 1991 | |
14608 | 14608 | 14607 | {"type": "MultiPolygon", "coordinates": [[[[-114.63174, 33.67102], [-114.63136, 33.67121], [-114.6317, 33.67154], [-114.63029, 33.67213], [-114.63018, 33.67219], [-114.63007, 33.67228], [-114.6296, 33.67245], [-114.62855, 33.67243], [-114.62864, 33.67507], [-114.62905, 33.67656], [-114.62821, 33.67876], [-114.62699, 33.67877], [-114.62693, 33.6753], [-114.62717, 33.67528], [-114.6272, 33.67448], [-114.62636, 33.67318], [-114.62583, 33.67138], [-114.62548, 33.67142], [-114.62456, 33.67023], [-114.62454, 33.66908], [-114.62451, 33.66883], [-114.62548, 33.66835], [-114.6257, 33.66763], [-114.62713, 33.66792], [-114.62832, 33.66823], [-114.62876, 33.6679], [-114.62888, 33.66803], [-114.63117, 33.66975], [-114.63115, 33.66981], [-114.63174, 33.67102]]], [[[-114.63716, 33.67426], [-114.63696, 33.67444], [-114.63682, 33.67451], [-114.63668, 33.67455], [-114.63645, 33.67455], [-114.63559, 33.6742], [-114.63489, 33.67416], [-114.63305, 33.67433], [-114.63279, 33.67471], [-114.6315, 33.67464], [-114.63103, 33.67444], [-114.63066, 33.67398], [-114.63014, 33.67242], [-114.63027, 33.6723], [-114.63047, 33.6722], [-114.63079, 33.67252], [-114.63152, 33.67319], [-114.63294, 33.67412], [-114.63313, 33.67408], [-114.63518, 33.67316], [-114.6353, 33.67325], [-114.63554, 33.67304], [-114.63716, 33.67426]]], [[[-114.64176, 33.67399], [-114.63934, 33.6741], [-114.63888, 33.67414], [-114.63811, 33.67413], [-114.63771, 33.6741], [-114.63726, 33.67411], [-114.63626, 33.67336], [-114.6365, 33.673], [-114.63751, 33.67202], [-114.63838, 33.67164], [-114.63896, 33.67178], [-114.63921, 33.67018], [-114.63755, 33.66907], [-114.63541, 33.67002], [-114.63532, 33.6699], [-114.63508, 33.67003], [-114.63435, 33.66982], [-114.63367, 33.66935], [-114.63305, 33.6692], [-114.63206, 33.66938], [-114.63129, 33.66962], [-114.63066, 33.66915], [-114.63182, 33.66854], [-114.63309, 33.66838], [-114.63342, 33.66849], [-114.6353, 33.66929], [-114.63741, 33.66898], [-114.63762, 33.66854], [-114.63918, 33.66905], [-114.64069, 33.66844], [-114.64168, 33.6684], [-114.64171, 33.66936], [-114.64067, 33.66973], [-114.64033, 33.67008], [-114.64011, 33.6708], [-114.63953, 33.67145], [-114.63917, 33.67228], [-114.6392, 33.67231], [-114.63918, 33.67238], [-114.64052, 33.67267], [-114.64174, 33.67312], [-114.64176, 33.67399]]]]} | Restricted Access 2 | Blythe Municipal Golf Course | 33102 | 1032 | Blythe, City of 339 | City 2 | City Agency 2 | http://www.cityofblythe.ca.gov/88/Parks-Department | City 2 | 157.479 | Blythe Municipal GC | ||
2126 | 2126 | 2125 | {"type": "Polygon", "coordinates": [[[-121.97293, 37.76113], [-121.97254, 37.7613], [-121.97237, 37.76105], [-121.97216, 37.76105], [-121.97219, 37.7609], [-121.9704, 37.76037], [-121.9707, 37.75957], [-121.97077, 37.75953], [-121.97127, 37.75964], [-121.97156, 37.75969], [-121.97186, 37.75971], [-121.97215, 37.7597], [-121.97243, 37.75968], [-121.97293, 37.76113]]]} | Restricted Access 2 | Bollinger Canyon School Park | 16244 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 5.797 | Bollinger Canyon School Park | ||
14089 | 14089 | 14088 | {"type": "Polygon", "coordinates": [[[-118.34535, 33.89045], [-118.34466, 33.89053], [-118.34471, 33.89095], [-118.34436, 33.89096], [-118.34432, 33.88985], [-118.34484, 33.88984], [-118.34486, 33.88999], [-118.34528, 33.88995], [-118.34535, 33.89045]]]} | Restricted Access 2 | Bollinger Gymnasium | http://www.lawndalecity.org/ASSETS/PDF/Parks/bollinger.pdf | 32629 | 1172 | Lawndale, City of 475 | City 2 | City Agency 2 | http://www.lawndalecity.org/ | City 2 | 1.861 | Bollinger Gymnasium | |
13217 | 13217 | 13216 | {"type": "Polygon", "coordinates": [[[-122.0059, 37.9266], [-122.00588, 37.92724], [-122.00532, 37.92828], [-122.0051, 37.92889], [-122.00468, 37.92966], [-122.00455, 37.92973], [-122.00424, 37.92981], [-122.00406, 37.92996], [-122.00278, 37.93026], [-122.00219, 37.9292], [-121.99905, 37.92943], [-121.99763, 37.92762], [-121.99599, 37.92776], [-121.99374, 37.92453], [-121.99457, 37.92375], [-121.99637, 37.9236], [-121.99942, 37.92264], [-122.00486, 37.92176], [-122.00508, 37.9224], [-122.0052, 37.92451], [-122.00519, 37.92546], [-122.0054, 37.9259], [-122.00549, 37.92588], [-122.00561, 37.92605], [-122.0059, 37.9266]]]} | Restricted Access 2 | Boundary Oak Golf Course | 33081 | 1371 | Walnut Creek, City of 174 | City 2 | City Agency 2 | http://www.ci.walnut-creek.ca.us/citygov/depts/ps/openspace/default.asp | City 2 | 159.595 | Boundary Oak GC | ||
13146 | 13146 | 13145 | {"type": "MultiPolygon", "coordinates": [[[[-117.91497, 33.90831], [-117.91484, 33.90848], [-117.91467, 33.90864], [-117.91453, 33.90875], [-117.9144, 33.90883], [-117.91391, 33.90906], [-117.91312, 33.90932], [-117.91275, 33.90948], [-117.91244, 33.90963], [-117.91188, 33.90995], [-117.91038, 33.91092], [-117.90986, 33.91115], [-117.90929, 33.91152], [-117.90912, 33.91163], [-117.90869, 33.91201], [-117.90844, 33.91228], [-117.908, 33.91291], [-117.90689, 33.91291], [-117.90842, 33.91113], [-117.90921, 33.9113], [-117.90971, 33.91111], [-117.91091, 33.91015], [-117.9114, 33.90964], [-117.91173, 33.90907], [-117.91198, 33.90885], [-117.91239, 33.90854], [-117.91283, 33.90838], [-117.91293, 33.90836], [-117.91322, 33.90838], [-117.91425, 33.90836], [-117.91497, 33.90831]]], [[[-117.91559, 33.90881], [-117.91519, 33.9088], [-117.91483, 33.90887], [-117.91474, 33.90929], [-117.9144, 33.90962], [-117.91353, 33.90955], [-117.91303, 33.90979], [-117.91327, 33.91038], [-117.91303, 33.91072], [-117.912, 33.91106], [-117.91189, 33.91127], [-117.91107, 33.91127], [-117.91017, 33.91196], [-117.90906, 33.91289], [-117.90829, 33.9129], [-117.90856, 33.9125], [-117.90874, 33.91229], [-117.90888, 33.91214], [-117.90928, 33.91179], [-117.90961, 33.91157], [-117.91226, 33.90991], [-117.9127, 33.90967], [-117.91319, 33.90946], [-117.91422, 33.90912], [-117.91452, 33.90899], [-117.91468, 33.90888], [-117.91488, 33.90872], [-117.91503, 33.90857], [-117.91521, 33.90836], [-117.91559, 33.90833], [-117.91559, 33.90881]]]]} | Restricted Access 2 | Brea Creek Municipal Golf Course | 33097 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | http://www.ci.brea.ca.us/index.aspx?NID=439 | City 2 | 26.115 | Brea Creek Municipal GC | ||
2215 | 2215 | 2214 | {"type": "Polygon", "coordinates": [[[-117.89549, 33.9268], [-117.89549, 33.92741], [-117.89547, 33.92752], [-117.89199, 33.92753], [-117.89193, 33.92519], [-117.89201, 33.9251], [-117.8935, 33.92506], [-117.89355, 33.9268], [-117.89549, 33.9268]]]} | Restricted Access 2 | Brea Junior High Park | 16342 | 1033 | Brea, City of 229 | City 2 | City Agency 2 | http://www.ci.brea.ca.us/index.aspx?NID=439 | City 2 | 13.298 | Brea Junior High Park | ||
2284 | 2284 | 2283 | {"type": "Polygon", "coordinates": [[[-122.37728, 37.8995], [-122.37687, 37.90346], [-122.35982, 37.90125], [-122.3598, 37.90126], [-122.35981, 37.9018], [-122.35775, 37.90181], [-122.35773, 37.90092], [-122.35788, 37.90109], [-122.35803, 37.90098], [-122.35781, 37.90071], [-122.3576, 37.90062], [-122.3574, 37.8997], [-122.3572, 37.89911], [-122.35737, 37.89887], [-122.35772, 37.89812], [-122.35749, 37.89767], [-122.35716, 37.89727], [-122.35736, 37.89693], [-122.35721, 37.89654], [-122.3575, 37.89591], [-122.35742, 37.89557], [-122.35717, 37.89509], [-122.35687, 37.8949], [-122.3566, 37.89494], [-122.3563, 37.89461], [-122.35472, 37.89435], [-122.35458, 37.89471], [-122.35306, 37.89475], [-122.35246, 37.8945], [-122.35191, 37.89435], [-122.3514, 37.89407], [-122.35136, 37.8937], [-122.35107, 37.89356], [-122.35082, 37.89383], [-122.35146, 37.89463], [-122.35148, 37.89464], [-122.35174, 37.89554], [-122.35199, 37.89603], [-122.35227, 37.89631], [-122.35261, 37.89649], [-122.35277, 37.8969], [-122.35282, 37.89693], [-122.35286, 37.89882], [-122.34909, 37.89467], [-122.34902, 37.8918], [-122.35677, 37.89326], [-122.35962, 37.89378], [-122.35969, 37.89617], [-122.37728, 37.8995]]]} | Restricted Access 2 | Brooks Island | 16426 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 289.4 | Brooks Island | ||
14595 | 14595 | 14594 | {"type": "Polygon", "coordinates": [[[-118.17436, 34.1834], [-118.1743, 34.1834], [-118.17301, 34.18282], [-118.17291, 34.18254], [-118.17283, 34.18244], [-118.17273, 34.18235], [-118.17215, 34.18199], [-118.1718, 34.18194], [-118.17174, 34.18191], [-118.17206, 34.18149], [-118.17211, 34.18112], [-118.17243, 34.18105], [-118.1725, 34.18065], [-118.17248, 34.1804], [-118.17237, 34.18021], [-118.17204, 34.18005], [-118.17168, 34.1796], [-118.17145, 34.17966], [-118.17108, 34.17965], [-118.17031, 34.17951], [-118.17015, 34.17919], [-118.17008, 34.17898], [-118.17006, 34.17881], [-118.17008, 34.17861], [-118.17012, 34.17851], [-118.17025, 34.1783], [-118.17049, 34.17802], [-118.17066, 34.17777], [-118.17073, 34.17761], [-118.17076, 34.17745], [-118.17038, 34.17752], [-118.17042, 34.17743], [-118.17041, 34.17735], [-118.1702, 34.17699], [-118.17015, 34.17694], [-118.17006, 34.17688], [-118.16982, 34.17677], [-118.16947, 34.17648], [-118.16929, 34.17639], [-118.16911, 34.17625], [-118.16886, 34.17611], [-118.16866, 34.17587], [-118.16823, 34.17543], [-118.16806, 34.17524], [-118.16766, 34.17524], [-118.16764, 34.17511], [-118.16728, 34.17524], [-118.16725, 34.17511], [-118.16721, 34.17492], [-118.16711, 34.17363], [-118.16701, 34.17317], [-118.16699, 34.17299], [-118.16696, 34.17178], [-118.16689, 34.17152], [-118.16668, 34.17114], [-118.16661, 34.17084], [-118.16664, 34.1702], [-118.16677, 34.16956], [-118.16679, 34.16932], [-118.16678, 34.16889], [-118.16679, 34.16843], [-118.16677, 34.1682], [-118.16642, 34.1671], [-118.16651, 34.1671], [-118.16652, 34.16709], [-118.16595, 34.16498], [-118.16523, 34.16349], [-118.16589, 34.16329], [-118.16778, 34.16277], [-118.16809, 34.16276], [-118.16841, 34.16264], [-118.16857, 34.16252], [-118.1689, 34.16241], [-118.16896, 34.16226], [-118.17004, 34.16195], [-118.16999, 34.16175], [-118.17002, 34.16172], [-118.16982, 34.16115], [-118.16974, 34.16109], [-118.16967, 34.161], [-118.16928, 34.15992], [-118.16932, 34.15971], [-118.16921, 34.15946], [-118.17032, 34.15985], [-118.171, 34.16012], [-118.17142, 34.16041], [-118.17165, 34.16111], [-118.17241, 34.16315], [-118.17217, 34.16322], [-118.17235, 34.16417], [-118.17242, 34.16439], [-118.17271, 34.16507], [-118.17318, 34.16645], [-118.17352, 34.16795], [-118.17399, 34.16795], [-118.17402, 34.16806], [-118.17425, 34.16914], [-118.17427, 34.16936], [-118.17447, 34.17027], [-118.17448, 34.17049], [-118.17468, 34.17142], [-118.17469, 34.17158], [-118.1748, 34.17226], [-118.17483, 34.17256], [-118.17478, 34.17312], [-118.17472, 34.17342], [-118.17456, 34.17402], [-118.17449, 34.17411], [-118.17437, 34.17418], [-118.17432, 34.17537], [-118.17339, 34.17649], [-118.17258, 34.17743], [-118.17253, 34.17803], [-118.17322, 34.17898], [-118.17357, 34.17931], [-118.1738, 34.17968], [-118.17394, 34.17995], [-118.17402, 34.18031], [-118.17366, 34.1808], [-118.17367, 34.18082], [-118.17359, 34.18104], [-118.1734, 34.18131], [-118.17345, 34.18137], [-118.17332, 34.18178], [-118.17344, 34.18247], [-118.17391, 34.18247], [-118.17394, 34.18268], [-118.17401, 34.18287], [-118.17436, 34.1834]]]} | Restricted Access 2 | Brookside Golf Course | http://www.cityofpasadena.net/PublicWorks/brookside_golf_course/ | 29070 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 293.631 | Brookside GC | |
11957 | 11957 | 11956 | {"type": "Polygon", "coordinates": [[[-118.4631, 34.04049], [-118.4631, 34.04049], [-118.46238, 34.04081], [-118.46291, 34.04033], [-118.4631, 34.04049]]]} | Restricted Access 2 | Bundy Triangle | 28785 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.22 | Bundy Triangle | ||
2220 | 2220 | 2219 | {"type": "MultiPolygon", "coordinates": [[[[-121.44086, 38.39459], [-121.42709, 38.39468], [-121.422, 38.39492], [-121.41795, 38.39493], [-121.41795, 38.39458], [-121.42201, 38.39457], [-121.42709, 38.39433], [-121.43606, 38.39427], [-121.43607, 38.39461], [-121.43609, 38.39462], [-121.4361, 38.39461], [-121.43609, 38.39427], [-121.44034, 38.39424], [-121.44035, 38.39396], [-121.44032, 38.39394], [-121.44085, 38.39394], [-121.44086, 38.39459]]], [[[-121.43609, 38.40531], [-121.43598, 38.4086], [-121.43569, 38.4086], [-121.43577, 38.4059], [-121.43587, 38.40526], [-121.43609, 38.40531]]], [[[-121.44071, 38.4054], [-121.44048, 38.40543], [-121.43989, 38.4056], [-121.43949, 38.40567], [-121.43917, 38.40568], [-121.43887, 38.40567], [-121.43641, 38.40584], [-121.4362, 38.40594], [-121.43621, 38.40553], [-121.43635, 38.40551], [-121.43878, 38.40534], [-121.43941, 38.40533], [-121.43974, 38.40528], [-121.44034, 38.40511], [-121.44071, 38.40506], [-121.44071, 38.4054]]], [[[-121.44105, 38.38668], [-121.44097, 38.38669], [-121.44089, 38.38673], [-121.44083, 38.38679], [-121.44081, 38.38686], [-121.44084, 38.39374], [-121.44019, 38.39375], [-121.44016, 38.38659], [-121.44105, 38.38659], [-121.44105, 38.38668]]]]} | Restricted Access 2 | CITY OF ELK GROVE | 17310 | 1097 | Elk Grove, City of 931 | City 2 | City Agency 2 | http://www.elkgrovecity.org/ | City 2 | 36.986 | CITY OF ELK GROVE | ||
2464 | 2464 | 2463 | {"type": "Polygon", "coordinates": [[[-121.51769, 38.52549], [-121.51733, 38.52654], [-121.51561, 38.52607], [-121.51615, 38.52487], [-121.51653, 38.52496], [-121.51707, 38.52504], [-121.51708, 38.52545], [-121.51769, 38.52549]]]} | Restricted Access 2 | Cabrillo School Park | 16644 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.006 | Cabrillo School 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]);