units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
663 rows where DES_TP = 14 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 46
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Salinas, City of 5
- Anaheim, City of 5
- Stockton, City of 5
- San Marcos, City of 4
- Marina, City of 4
- …
ACCESS_TYP 4
- Open Access 581
- No Public Access 60
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 663 ✖
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15528 | 15528 | 15527 | {"type": "Polygon", "coordinates": [[[-120.63297, 36.97684], [-120.63292, 36.97688], [-120.63232, 36.97688], [-120.63228, 36.97685], [-120.63228, 36.97652], [-120.63297, 36.97652], [-120.63297, 36.97684]]]} | Open Access 1 | 48941 | Unknown park - Dos Palos, City of | 33657 | 1460 | Dos Palos, City of 194 | City 2 | City Agency 2 | City 2 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | Merced 37 | 0.607 | 0 | Local Other or Unknown 14 | 4 | |||
15521 | 15521 | 15520 | {"type": "MultiPolygon", "coordinates": [[[[-118.01939, 34.15749], [-118.01937, 34.15755], [-118.01816, 34.15757], [-118.01816, 34.15725], [-118.01913, 34.15723], [-118.01924, 34.15739], [-118.01939, 34.15749]]], [[[-118.02016, 34.15812], [-118.01979, 34.15825], [-118.0197, 34.15807], [-118.02001, 34.15784], [-118.02016, 34.15812]]], [[[-117.98338, 34.16205], [-117.98326, 34.16208], [-117.9832, 34.16213], [-117.98309, 34.16208], [-117.98192, 34.16238], [-117.98193, 34.16215], [-117.9828, 34.16166], [-117.98338, 34.16205]]], [[[-118.00939, 34.16414], [-118.00938, 34.16473], [-118.00902, 34.16473], [-118.00901, 34.16475], [-118.00914, 34.1649], [-118.00889, 34.16491], [-118.00839, 34.16427], [-118.00835, 34.16403], [-118.00821, 34.16383], [-118.00821, 34.16373], [-118.00817, 34.16344], [-118.00811, 34.16316], [-118.00794, 34.1629], [-118.00799, 34.1629], [-118.00805, 34.16293], [-118.00815, 34.16288], [-118.00811, 34.16279], [-118.00853, 34.16294], [-118.00872, 34.16314], [-118.0089, 34.16355], [-118.00905, 34.16374], [-118.00909, 34.16373], [-118.00939, 34.16414]]], [[[-117.98435, 34.16349], [-117.98328, 34.16413], [-117.98317, 34.16428], [-117.98306, 34.16458], [-117.98265, 34.16423], [-117.98229, 34.16319], [-117.98272, 34.16278], [-117.98368, 34.16275], [-117.98377, 34.16278], [-117.98383, 34.16284], [-117.98386, 34.16289], [-117.98388, 34.16302], [-117.98392, 34.1631], [-117.98398, 34.16314], [-117.98414, 34.16323], [-117.98426, 34.1634], [-117.98435, 34.16349]]], [[[-117.9912, 34.16415], [-117.99116, 34.16455], [-117.99078, 34.16501], [-117.99049, 34.16493], [-117.99039, 34.16425], [-117.99055, 34.16407], [-117.9912, 34.16415]]], [[[-118.00356, 34.16545], [-118.00351, 34.1655], [-118.00328, 34.16533], [-118.00314, 34.16529], [-118.00304, 34.16529], [-118.00267, 34.16538], [-118.0026, 34.16538], [-118.0025, 34.16536], [-118.00242, 34.16533], [-118.00236, 34.16528], [-118.00225, 34.1651], [-118.00216, 34.16501], [-118.00207, 34.16496], [-118.00183, 34.16487], [-118.00187, 34.16481], [-118.00218, 34.16494], [-118.0023, 34.16505], [-118.00242, 34.16523], [-118.00253, 34.1653], [-118.00266, 34.16531], [-118.00303, 34.16523], [-118.00317, 34.16523], [-118.00332, 34.16528], [-118.00356, 34.16545]]], [[[-117.98421, 34.16761], [-117.9842, 34.16844], [-117.98323, 34.16843], [-117.98324, 34.16761], [-117.98421, 34.16761]]], [[[-117.99949, 34.1724], [-117.9963, 34.17243], [-117.99577, 34.1713], [-117.99558, 34.17054], [-117.99543, 34.1704], [-117.99543, 34.17029], [-117.99566, 34.17048], [-117.99604, 34.17063], [-117.99706, 34.16907], [-117.99659, 34.16825], [-117.99667, 34.16747], [-117.99701, 34.16747], [-117.99687, 34.16775], [-117.99688, 34.16837], [-117.99709, 34.16882], [-117.9987, 34.16882], [-117.99868, 34.1689], [-117.99869, 34.16897], [-117.99876, 34.16911], [-117.99891, 34.16902], [-117.99897, 34.1691], [-117.99946, 34.1695], [-117.99949, 34.1724]]], [[[-117.95966, 34.17231], [-117.95711, 34.17229], [-117.95687, 34.1721], [-117.95683, 34.17204], [-117.95679, 34.17191], [-117.95673, 34.17182], [-117.95637, 34.17158], [-117.95627, 34.17147], [-117.95619, 34.17134], [-117.95615, 34.17121], [-117.95614, 34.17108], [-117.9562, 34.17063], [-117.95618, 34.17051], [-117.95615, 34.17043], [-117.95609, 34.17037], [-117.95573, 34.17004], [-117.95561, 34.16985], [-117.95558, 34.16971], [-117.95555, 34.16944], [-117.95556, 34.1692], [-117.9556, 34.16891], [-117.95559, 34.16879], [-117.95552, 34.16861], [-117.95538, 34.16845], [-117.95525, 34.16836], [-117.95469, 34.1681], [-117.95426, 34.16797], [-117.95383, 34.16779], [-117.95364, 34.16779], [-117.95327, 34.16768], [-117.95306, 34.1676], [-117.95291, 34.16748], [-117.95232, 34.16717], [-117.95202, 34.16689], [-117.95176, 34.1667], [-117.95169, 34.16661], [-117.9516, 34.16652], [-117.95115, 34.16626], [-117.95086, 34.16621], [-117.95069, 34.16622], [-117.95062, 34.16614], [-117.95045, 34.16612], [-117.95037, 34.16616], [-117.94997, 34.16617], [-117.94969, 34.16616], [-117.94939, 34.16608], [-117.94922, 34.166], [-117.94896, 34.16579], [-117.94857, 34.1654], [-117.94834, 34.16521], [-117.95956, 34.16516], [-117.95953, 34.16869], [-117.95966, 34.17231]]], [[[-118.00963, 34.17433], [-118.00783, 34.17435], [-118.00782, 34.1744], [-118.00716, 34.17441], [-118.00716, 34.17381], [-118.00854, 34.17379], [-118.00855, 34.17352], [-118.00873, 34.17351], [-118.00873, 34.17359], [-118.00888, 34.17354], [-118.00889, 34.17378], [-118.00963, 34.17378], [-118.00963, 34.17433]]], [[[-117.95706, 34.17229], [-117.9511, 34.17225], [-117.95113, 34.17589], [-117.94237, 34.17584], [-117.94224, 34.16864], [-117.94228, 34.16689], [-117.94362, 34.16688], [-117.94363, 34.16524], [-117.94829, 34.16521], [-117.94855, 34.16542], [-117.94893, 34.16581], [-117.9492, 34.16603], [-117.94938, 34.1661], [-117.94968, 34.16618], [-117.94997, 34.1662], [-117.95038, 34.16619], [-117.95046, 34.16615], [-117.9506, 34.16616], [-117.95068, 34.16625], [-117.95085, 34.16624], [-117.95114, 34.16629], [-117.95157, 34.16654], [-117.95166, 34.16662], [-117.95173, 34.16671], [-117.95199, 34.16691], [-117.9523, 34.16719], [-117.95289, 34.16751], [-117.95304, 34.16763], [-117.95325, 34.1677], [-117.95363, 34.16781], [-117.95382, 34.16782], [-117.95425, 34.168], [-117.95467, 34.16812], [-117.95523, 34.16839], [-117.95536, 34.16847], [-117.95549, 34.16862], [-117.95556, 34.1688], [-117.95556, 34.1689], [-117.95552, 34.1692], [-117.95552, 34.16944], [-117.95554, 34.16971], [-117.95558, 34.16985], [-117.9557, 34.17006], [-117.95607, 34.17038], [-117.95612, 34.17045], [-117.95615, 34.17053], [-117.95616, 34.17063], [-117.9561, 34.17109], [-117.95612, 34.17122], [-117.95616, 34.17135], [-117.95624, 34.17148], [-117.95635, 34.1716], [-117.9567, 34.17183], [-117.95677, 34.17193], [-117.9568, 34.17205], [-117.95684, 34.17211], [-117.95706, 34.17229]]], [[[-117.96662, 34.18814], [-117.96455, 34.18813], [-117.96454, 34.18634], [-117.96661, 34.18634], [-117.96662, 34.18814]]]]} | Open Access 1 | 47502 | Unnamed site - Monrovia, City of | 31217 | 1209 | Monrovia, City of 312 | City 2 | City Agency 2 | http://www.cityofmonrovia.org/publicworks/page/parks | City 2 | 1209 | Monrovia, City of 309 | City 2 | City Agency 2 | Los Angeles 6 | 440.228 | 0 | Local Other or Unknown 14 | 4 | ||
15514 | 15514 | 15513 | {"type": "Polygon", "coordinates": [[[-117.71139, 34.1617], [-117.71135, 34.16535], [-117.7035, 34.16531], [-117.70367, 34.16165], [-117.70258, 34.16163], [-117.70238, 34.1653], [-117.70033, 34.16527], [-117.70038, 34.16511], [-117.70037, 34.16487], [-117.70048, 34.16454], [-117.70022, 34.16453], [-117.7001, 34.16486], [-117.70012, 34.16511], [-117.70007, 34.16527], [-117.69991, 34.16527], [-117.69997, 34.16511], [-117.69997, 34.16487], [-117.69971, 34.16486], [-117.6997, 34.16511], [-117.69965, 34.16527], [-117.69191, 34.16521], [-117.68496, 34.1652], [-117.68529, 34.15794], [-117.69832, 34.1579], [-117.69855, 34.15422], [-117.70197, 34.15426], [-117.70199, 34.1546], [-117.70203, 34.15459], [-117.70221, 34.15435], [-117.70225, 34.15426], [-117.70238, 34.15426], [-117.70234, 34.15434], [-117.70217, 34.15459], [-117.70214, 34.15477], [-117.70215, 34.15485], [-117.7024, 34.15484], [-117.70243, 34.1546], [-117.7026, 34.15436], [-117.70264, 34.15427], [-117.70291, 34.15427], [-117.70273, 34.15795], [-117.70263, 34.15953], [-117.70706, 34.1596], [-117.707, 34.16166], [-117.71139, 34.1617]], [[-117.70039, 34.16428], [-117.70027, 34.16444], [-117.70027, 34.16445], [-117.70052, 34.16445], [-117.70064, 34.1643], [-117.70039, 34.16428]], [[-117.69997, 34.16428], [-117.69992, 34.16436], [-117.70018, 34.16436], [-117.70035, 34.16413], [-117.7004, 34.16404], [-117.70016, 34.16404], [-117.69997, 34.16428]], [[-117.70023, 34.16393], [-117.70018, 34.16401], [-117.70044, 34.16401], [-117.70055, 34.16386], [-117.70029, 34.16385], [-117.70023, 34.16393]], [[-117.70097, 34.16336], [-117.70084, 34.16343], [-117.70087, 34.1636], [-117.70075, 34.16383], [-117.70075, 34.16385], [-117.70089, 34.16384], [-117.70136, 34.16337], [-117.70097, 34.16336]], [[-117.70069, 34.1636], [-117.70071, 34.16343], [-117.70046, 34.16343], [-117.70043, 34.1636], [-117.7004, 34.16367], [-117.70064, 34.16368], [-117.70069, 34.1636]], [[-117.70078, 34.16319], [-117.70053, 34.16333], [-117.70053, 34.16335], [-117.70076, 34.16335], [-117.70104, 34.16319], [-117.70114, 34.16303], [-117.70089, 34.16303], [-117.70078, 34.16319]], [[-117.70127, 34.16318], [-117.70116, 34.16326], [-117.70145, 34.16326], [-117.70154, 34.16318], [-117.70156, 34.16312], [-117.7013, 34.16311], [-117.70127, 34.16318]], [[-117.70167, 34.16294], [-117.7017, 34.16286], [-117.70145, 34.16286], [-117.70137, 34.16301], [-117.70162, 34.16302], [-117.70167, 34.16294]], [[-117.70176, 34.16286], [-117.70167, 34.16302], [-117.70193, 34.16302], [-117.70201, 34.16287], [-117.702, 34.16286], [-117.70176, 34.16286]], [[-117.70185, 34.16201], [-117.70199, 34.16178], [-117.70174, 34.16177], [-117.7016, 34.162], [-117.70167, 34.16225], [-117.7017, 34.16283], [-117.70194, 34.16282], [-117.70193, 34.16248], [-117.70185, 34.16201]], [[-117.70151, 34.16243], [-117.70125, 34.16241], [-117.70126, 34.16249], [-117.7011, 34.16274], [-117.70135, 34.16274], [-117.70152, 34.1625], [-117.70151, 34.16243]], [[-117.70149, 34.16217], [-117.70147, 34.16208], [-117.70122, 34.16208], [-117.70124, 34.16232], [-117.70149, 34.16233], [-117.70149, 34.16217]], [[-117.70126, 34.16191], [-117.70121, 34.16199], [-117.70122, 34.162], [-117.70146, 34.162], [-117.70165, 34.16168], [-117.7014, 34.16168], [-117.70126, 34.16191]], [[-117.70169, 34.16161], [-117.70176, 34.16145], [-117.7017, 34.16129], [-117.70145, 34.16129], [-117.7015, 34.16145], [-117.70145, 34.16161], [-117.70169, 34.16161]], [[-117.70208, 34.16162], [-117.70215, 34.16145], [-117.70219, 34.16121], [-117.70194, 34.16121], [-117.70189, 34.16145], [-117.70183, 34.16161], [-117.70208, 34.16162]], [[-117.70159, 34.16027], [-117.70157, 34.1602], [-117.7015, 34.1602], [-117.70147, 34.16012], [-117.70143, 34.16012], [-117.70146, 34.16003], [-117.70149, 34.16002], [-117.70152, 34.15995], [-117.70152, 34.15979], [-117.7012, 34.15978], [-117.70117, 34.16002], [-117.7012, 34.16003], [-117.70117, 34.1601], [-117.70121, 34.16011], [-117.70123, 34.16019], [-117.70129, 34.16019], [-117.70137, 34.16036], [-117.70132, 34.16036], [-117.70132, 34.16038], [-117.70134, 34.16043], [-117.7014, 34.16043], [-117.70142, 34.16052], [-117.70138, 34.1608], [-117.7014, 34.1612], [-117.70165, 34.1612], [-117.70164, 34.16079], [-117.70168, 34.16052], [-117.70167, 34.16044], [-117.70159, 34.16027]], [[-117.70214, 34.16036], [-117.7021, 34.16028], [-117.70205, 34.16028], [-117.70197, 34.16013], [-117.7021, 34.16013], [-117.70211, 34.15989], [-117.70173, 34.15956], [-117.70165, 34.15971], [-117.70164, 34.16011], [-117.70173, 34.1602], [-117.70187, 34.16044], [-117.70184, 34.16045], [-117.70185, 34.16068], [-117.7021, 34.16069], [-117.7021, 34.16044], [-117.70214, 34.16043], [-117.70214, 34.16036]], [[-117.70148, 34.15959], [-117.70126, 34.15958], [-117.70125, 34.15974], [-117.7015, 34.15974], [-117.70148, 34.15959]], [[-117.70196, 34.15941], [-117.70195, 34.1594], [-117.70173, 34.15941], [-117.70195, 34.15963], [-117.70196, 34.15941]], [[-117.70201, 34.15947], [-117.702, 34.15948], [-117.70199, 34.15966], [-117.70218, 34.15984], [-117.70218, 34.15965], [-117.70201, 34.15947]], [[-117.7024, 34.15983], [-117.70239, 34.15984], [-117.70238, 34.16005], [-117.70257, 34.16013], [-117.70258, 34.15992], [-117.7024, 34.15983]], [[-117.70309, 34.16029], [-117.70308, 34.16015], [-117.70299, 34.16002], [-117.7029, 34.15998], [-117.7029, 34.16019], [-117.70298, 34.16024], [-117.70307, 34.16035], [-117.70308, 34.16035], [-117.70309, 34.16029]], [[-117.7033, 34.16033], [-117.70328, 34.16033], [-117.70328, 34.16054], [-117.70338, 34.1606], [-117.70358, 34.16066], [-117.70371, 34.16068], [-117.7037, 34.16047], [-117.70358, 34.16045], [-117.70338, 34.16039], [-117.7033, 34.16033]], [[-117.70424, 34.16056], [-117.70423, 34.16057], [-117.70422, 34.16077], [-117.70431, 34.16082], [-117.70432, 34.16062], [-117.70424, 34.16056]], [[-117.70443, 34.16068], [-117.70441, 34.16069], [-117.70442, 34.16091], [-117.70451, 34.16097], [-117.70451, 34.16074], [-117.70443, 34.16068]], [[-117.70492, 34.16115], [-117.70511, 34.16122], [-117.70511, 34.161], [-117.70492, 34.16093], [-117.70492, 34.16115]], [[-117.70633, 34.16128], [-117.70623, 34.16125], [-117.70593, 34.16122], [-117.70574, 34.16116], [-117.70573, 34.16117], [-117.70573, 34.16137], [-117.70593, 34.16144], [-117.70632, 34.16149], [-117.70633, 34.16128]], [[-117.70643, 34.16153], [-117.70643, 34.16158], [-117.70652, 34.16162], [-117.70691, 34.16162], [-117.70691, 34.1614], [-117.70653, 34.1614], [-117.70643, 34.16136], [-117.70643, 34.16153]], [[-117.70541, 34.16145], [-117.70531, 34.1614], [-117.7052, 34.16138], [-117.70521, 34.16165], [-117.70541, 34.16165], [-117.70541, 34.16145]], [[-117.70501, 34.16131], [-117.70482, 34.16122], [-117.70481, 34.16123], [-117.70481, 34.16143], [-117.70491, 34.1615], [-117.70492, 34.16165], [-117.70501, 34.16164], [-117.70501, 34.16131]], [[-117.70432, 34.16103], [-117.70422, 34.16089], [-117.70413, 34.16084], [-117.70412, 34.16105], [-117.70422, 34.1611], [-117.70432, 34.16125], [-117.70471, 34.16139], [-117.70471, 34.16119], [-117.70461, 34.16113], [-117.70432, 34.16103]], [[-117.70186, 34.16104], [-117.70185, 34.16106], [-117.70189, 34.16112], [-117.70217, 34.16112], [-117.70215, 34.16104], [-117.70186, 34.16104]], [[-117.70181, 34.16093], [-117.7018, 34.16094], [-117.70184, 34.16102], [-117.70215, 34.16101], [-117.70212, 34.16093], [-117.70181, 34.16093]], [[-117.70336, 34.16094], [-117.70337, 34.16094], [-117.70337, 34.16074], [-117.70328, 34.16068], [-117.70328, 34.16089], [-117.70336, 34.16094]], [[-117.70178, 34.16079], [-117.70178, 34.16087], [-117.70213, 34.16086], [-117.7021, 34.16072], [-117.70185, 34.16071], [-117.70178, 34.16079]], [[-117.70284, 34.16027], [-117.70283, 34.16027], [-117.70283, 34.16045], [-117.70292, 34.16051], [-117.70292, 34.16033], [-117.70284, 34.16027]], [[-117.70239, 34.16011], [-117.70228, 34.16007], [-117.70229, 34.16037], [-117.70238, 34.16036], [-117.70239, 34.16011]], [[-117.70151, 34.15942], [-117.70152, 34.15941], [-117.70139, 34.15918], [-117.70113, 34.15919], [-117.70126, 34.15942], [-117.70151, 34.15942]], [[-117.70162, 34.15918], [-117.70188, 34.15918], [-117.70182, 34.15902], [-117.70174, 34.15866], [-117.70175, 34.15833], [-117.70172, 34.158], [-117.70147, 34.158], [-117.70148, 34.15867], [-117.70153, 34.15902], [-117.70162, 34.15918]], [[-117.7013, 34.15877], [-117.70129, 34.15869], [-117.70104, 34.15869], [-117.70103, 34.15884], [-117.70128, 34.15885], [-117.7013, 34.15877]], [[-117.70173, 34.15793], [-117.70176, 34.15777], [-117.70175, 34.15752], [-117.70155, 34.15703], [-117.7013, 34.15703], [-117.70149, 34.15752], [-117.70146, 34.15792], [-117.70173, 34.15793]], [[-117.70187, 34.15718], [-117.70193, 34.15727], [-117.70216, 34.15727], [-117.70206, 34.1571], [-117.70183, 34.1571], [-117.70182, 34.15712], [-117.70187, 34.15718]], [[-117.7015, 34.15692], [-117.70151, 34.1569], [-117.70147, 34.15666], [-117.70141, 34.15642], [-117.70146, 34.15625], [-117.70161, 34.1561], [-117.7013, 34.15609], [-117.70115, 34.15641], [-117.70124, 34.1569], [-117.7015, 34.15692]], [[-117.70062, 34.15608], [-117.70068, 34.15517], [-117.69959, 34.15515], [-117.69954, 34.15607], [-117.70062, 34.15608]], [[-117.70173, 34.15527], [-117.70169, 34.15544], [-117.70169, 34.1556], [-117.70185, 34.15561], [-117.70197, 34.15519], [-117.70196, 34.15511], [-117.70172, 34.15511], [-117.70172, 34.15519], [-117.7017, 34.1552], [-117.70168, 34.15527], [-117.70173, 34.15527]], [[-117.70206, 34.15561], [-117.70203, 34.1557], [-117.70189, 34.15593], [-117.70189, 34.15594], [-117.70214, 34.15594], [-117.7023, 34.15569], [-117.70238, 34.15537], [-117.70213, 34.15537], [-117.70206, 34.15561]], [[-117.70182, 34.15608], [-117.70172, 34.15625], [-117.70197, 34.15625], [-117.70207, 34.15609], [-117.70182, 34.15608]], [[-117.70161, 34.15667], [-117.70165, 34.15683], [-117.70191, 34.15683], [-117.70187, 34.1565], [-117.70162, 34.1565], [-117.70161, 34.15667]], [[-117.7017, 34.155], [-117.70171, 34.15508], [-117.70196, 34.15508], [-117.70194, 34.15483], [-117.70194, 34.15451], [-117.70169, 34.15451], [-117.7017, 34.155]]]} | Open Access 1 | 46340 | Unnamed Site - Claremont, City of | 29627 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | http://www.ci.claremont.ca.us/ps.leisurerecreation.cfm?ID=1709 | City 2 | 1057 | Claremont, City of 6 | City 2 | City Agency 2 | Los Angeles 6 | 443.645 | 0 | Local Other or Unknown 14 | 4 | ||
15478 | 15478 | 15477 | {"type": "Polygon", "coordinates": [[[-121.79324, 36.88092], [-121.79324, 36.88092], [-121.78808, 36.88474], [-121.78767, 36.88399], [-121.79284, 36.88016], [-121.79324, 36.88092]]]} | No Public Access 3 | 36631 | Unnamed site - Watsonville, City of | 28700 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.356 | 0 | Local Other or Unknown 14 | 4 | ||
15477 | 15477 | 15476 | {"type": "Polygon", "coordinates": [[[-121.79104, 37.01528], [-121.79097, 37.01543], [-121.791, 37.01553], [-121.7909, 37.01571], [-121.79074, 37.01585], [-121.79048, 37.01595], [-121.78977, 37.01601], [-121.78875, 37.01643], [-121.78822, 37.01683], [-121.78806, 37.01702], [-121.78779, 37.01739], [-121.78779, 37.01786], [-121.78794, 37.01826], [-121.78733, 37.0187], [-121.78722, 37.01886], [-121.78726, 37.019], [-121.78736, 37.01911], [-121.78433, 37.01909], [-121.78606, 37.01588], [-121.78619, 37.01552], [-121.7865, 37.01535], [-121.78714, 37.01517], [-121.78795, 37.01487], [-121.78952, 37.01435], [-121.79104, 37.01528]], [[-121.79089, 37.01556], [-121.79089, 37.01554], [-121.7903, 37.01553], [-121.79029, 37.01554], [-121.79045, 37.01588], [-121.79068, 37.01579], [-121.79083, 37.01566], [-121.79089, 37.01556]]]} | Open Access 1 | 36629 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 34.455 | 0 | Local Other or Unknown 14 | 4 | ||
15475 | 15475 | 15474 | {"type": "Polygon", "coordinates": [[[-121.80045, 37.04074], [-121.80028, 37.04454], [-121.80017, 37.04746], [-121.79151, 37.04743], [-121.79167, 37.0407], [-121.797, 37.04075], [-121.80045, 37.04074]]]} | Open Access 1 | 36626 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 142.753 | 0 | Local Other or Unknown 14 | 4 | ||
15460 | 15460 | 15459 | {"type": "Polygon", "coordinates": [[[-122.28949, 38.30081], [-122.28933, 38.30084], [-122.28919, 38.30061], [-122.28941, 38.3005], [-122.28949, 38.30081]]]} | Open Access 1 | 36613 | Unnamed site - Napa, City of | 28646 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.14 | 0 | Local Other or Unknown 14 | 4 | ||
15449 | 15449 | 15448 | {"type": "Polygon", "coordinates": [[[-122.30439, 38.26326], [-122.30382, 38.2634], [-122.30362, 38.26287], [-122.30419, 38.26274], [-122.30439, 38.26326]]]} | No Public Access 3 | 36595 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 0.78 | 0 | Local Other or Unknown 14 | 4 | ||
15325 | 15325 | 15324 | {"type": "Polygon", "coordinates": [[[-117.85818, 34.19361], [-117.85655, 34.19631], [-117.85599, 34.19646], [-117.85577, 34.1973], [-117.85578, 34.19593], [-117.85608, 34.19586], [-117.85744, 34.1936], [-117.85818, 34.19361]]]} | No Public Access 3 | 48970 | Unnamed Site - Pasadena Department of Water and Power | 33667 | 1720 | Pasadena Department of Water and Power 1153 | City 2 | City Agency 2 | https://ww5.cityofpasadena.net/water-and-power/ | City 2 | 1720 | Pasadena Department of Water and Power 1099 | City 2 | City Agency 2 | Los Angeles 6 | 5.621 | 0 | Local Other or Unknown 14 | 4 | ||
15141 | 15141 | 15140 | {"type": "Polygon", "coordinates": [[[-117.32181, 33.23522], [-117.32171, 33.23556], [-117.32162, 33.23557], [-117.32159, 33.23552], [-117.32146, 33.23545], [-117.32138, 33.23537], [-117.32154, 33.23522], [-117.32176, 33.23511], [-117.32181, 33.23522]]]} | Open Access 1 | 45966 | Mission Wells Historical Lot | 29115 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#9 | San Diego 4 | 0.286 | Mission Wells Historical Lot | 0 | Local Other or Unknown 14 | 4 |
15070 | 15070 | 15069 | {"type": "Polygon", "coordinates": [[[-118.56874, 34.13168], [-118.56573, 34.13332], [-118.56505, 34.13189], [-118.56459, 34.13122], [-118.56485, 34.13122], [-118.56541, 34.13042], [-118.56551, 34.13046], [-118.56558, 34.13034], [-118.56594, 34.13048], [-118.56589, 34.1306], [-118.56874, 34.13168]]]} | Open Access 1 | 45842 | Pilson Property | 28862 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 14.653 | Pilson Property | 0 | Local Other or Unknown 14 | 4 | |
15059 | 15059 | 15058 | {"type": "Polygon", "coordinates": [[[-118.20626, 34.09845], [-118.20591, 34.09868], [-118.20587, 34.09831], [-118.20587, 34.09831], [-118.20626, 34.09845]]]} | Open Access 1 | 45839 | Woodside Triangle | 28859 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.175 | Woodside Triangle | 0 | Local Other or Unknown 14 | 4 | |
15056 | 15056 | 15055 | {"type": "Polygon", "coordinates": [[[-118.46102, 33.99278], [-118.46095, 33.99287], [-118.46087, 33.99283], [-118.46093, 33.99274], [-118.46102, 33.99278]]]} | Open Access 1 | 45814 | Nowita Triangle | 28834 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.027 | Nowita Triangle | 0 | Local Other or Unknown 14 | 4 | |
15001 | 15001 | 15000 | {"type": "Polygon", "coordinates": [[[-118.45909, 33.99185], [-118.45903, 33.99195], [-118.45894, 33.99191], [-118.45901, 33.99181], [-118.45909, 33.99185]]]} | Open Access 1 | 45786 | Amoroso Triangle | 28805 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.027 | Amoroso Triangle | 0 | Local Other or Unknown 14 | 4 | |
14792 | 14792 | 14791 | {"type": "MultiPolygon", "coordinates": [[[[-117.76191, 33.57929], [-117.76163, 33.58049], [-117.76149, 33.58089], [-117.76147, 33.5809], [-117.76142, 33.58103], [-117.75978, 33.58102], [-117.75959, 33.58153], [-117.75933, 33.58154], [-117.75933, 33.58184], [-117.75557, 33.58188], [-117.75555, 33.5803], [-117.76068, 33.58024], [-117.7609, 33.5793], [-117.76191, 33.57929]]], [[[-117.7673, 33.55325], [-117.76729, 33.555], [-117.76702, 33.55501], [-117.76701, 33.55632], [-117.76386, 33.55613], [-117.76044, 33.55618], [-117.76028, 33.55599], [-117.76068, 33.55577], [-117.76068, 33.55575], [-117.7602, 33.55519], [-117.75985, 33.55474], [-117.75949, 33.55494], [-117.75947, 33.55397], [-117.76169, 33.55399], [-117.76166, 33.55024], [-117.76181, 33.55018], [-117.76202, 33.55055], [-117.76393, 33.54982], [-117.7639, 33.55324], [-117.76492, 33.55324], [-117.76493, 33.55333], [-117.76671, 33.55334], [-117.76672, 33.55325], [-117.7673, 33.55325]]], [[[-117.76318, 33.57015], [-117.76293, 33.57156], [-117.7629, 33.57183], [-117.76291, 33.57223], [-117.76301, 33.57277], [-117.76235, 33.57277], [-117.76235, 33.57238], [-117.76232, 33.57225], [-117.76225, 33.57214], [-117.76215, 33.57203], [-117.7615, 33.57156], [-117.76142, 33.57148], [-117.7614, 33.57141], [-117.76141, 33.57135], [-117.76155, 33.57102], [-117.76156, 33.5709], [-117.76154, 33.57078], [-117.7615, 33.57066], [-117.76118, 33.57007], [-117.7611, 33.57], [-117.76096, 33.56993], [-117.76133, 33.56911], [-117.76185, 33.56917], [-117.76175, 33.56974], [-117.7623, 33.56981], [-117.76227, 33.57004], [-117.76318, 33.57015]]], [[[-117.7651, 33.56301], [-117.76486, 33.56309], [-117.76452, 33.56325], [-117.76367, 33.56271], [-117.76453, 33.5622], [-117.76455, 33.56156], [-117.76467, 33.56148], [-117.76493, 33.56185], [-117.7651, 33.56301]]], [[[-117.77051, 33.56129], [-117.77037, 33.56163], [-117.77024, 33.56191], [-117.76967, 33.56213], [-117.76922, 33.56226], [-117.76926, 33.56239], [-117.76886, 33.56248], [-117.76851, 33.56239], [-117.768, 33.56218], [-117.76679, 33.56182], [-117.76727, 33.5604], [-117.76878, 33.56109], [-117.76929, 33.56067], [-117.77051, 33.56129]]]]} | Open Access 1 | 47962 | Unnamed site - Laguna Beach, City of | 32173 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | Orange 3 | 115.261 | 0 | Local Other or Unknown 14 | 4 | ||
13998 | 13998 | 13997 | {"type": "Polygon", "coordinates": [[[-117.76209, 33.85038], [-117.76198, 33.85034], [-117.76192, 33.85035], [-117.76201, 33.85075], [-117.76133, 33.85022], [-117.76105, 33.85004], [-117.76077, 33.8499], [-117.76053, 33.84979], [-117.76024, 33.84969], [-117.75984, 33.84959], [-117.75914, 33.84946], [-117.759, 33.84933], [-117.75885, 33.84913], [-117.75933, 33.84883], [-117.7595, 33.84902], [-117.76021, 33.84861], [-117.76209, 33.85038]]]} | Open Access 1 | 36682 | Anaheim holding 1 | 15466 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 5.203 | Anaheim holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13997 | 13997 | 13996 | {"type": "Polygon", "coordinates": [[[-121.2456, 38.81268], [-121.24492, 38.81284], [-121.24361, 38.81234], [-121.24371, 38.81213], [-121.24377, 38.81207], [-121.24383, 38.81206], [-121.24392, 38.81207], [-121.24399, 38.81206], [-121.24405, 38.81202], [-121.24407, 38.81195], [-121.24422, 38.81192], [-121.24438, 38.81185], [-121.24476, 38.81174], [-121.24491, 38.81171], [-121.24504, 38.81172], [-121.24516, 38.81175], [-121.24527, 38.81181], [-121.24533, 38.81185], [-121.2454, 38.81193], [-121.24543, 38.81202], [-121.2456, 38.81268]]]} | Open Access 1 | 36681 | Rocklin holding 2 | 24525 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.454 | Rocklin holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13995 | 13995 | 13994 | {"type": "Polygon", "coordinates": [[[-120.42993, 34.90438], [-120.4295, 34.90438], [-120.42947, 34.90435], [-120.42977, 34.90426], [-120.42978, 34.90425], [-120.42937, 34.90377], [-120.42935, 34.90377], [-120.42911, 34.90347], [-120.42901, 34.90343], [-120.42909, 34.90341], [-120.42993, 34.90438]]]} | Open Access 1 | 36679 | Santa Maria holding 6 | 25110 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 0.176 | Santa Maria holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13992 | 13992 | 13991 | {"type": "Polygon", "coordinates": [[[-117.02354, 33.00205], [-117.02349, 33.0021], [-117.02338, 33.0021], [-117.02348, 33.00185], [-117.02347, 33.00124], [-117.02325, 33.00034], [-117.02352, 33.00034], [-117.02356, 33.00132], [-117.02356, 33.00176], [-117.02354, 33.00205]]]} | Open Access 1 | 36674 | Poway holding 33 | 23958 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.628 | Poway holding 33 | 0 | Local Other or Unknown 14 | 4 | |
13989 | 13989 | 13988 | {"type": "Polygon", "coordinates": [[[-121.21782, 38.72076], [-121.21758, 38.7208], [-121.21734, 38.72088], [-121.21712, 38.72103], [-121.21687, 38.72108], [-121.21656, 38.72104], [-121.21655, 38.72139], [-121.21573, 38.72099], [-121.21577, 38.72075], [-121.2158, 38.72071], [-121.21586, 38.72069], [-121.21588, 38.72054], [-121.21585, 38.72053], [-121.21597, 38.72036], [-121.21628, 38.72067], [-121.21632, 38.72069], [-121.21635, 38.72067], [-121.21637, 38.71985], [-121.21634, 38.71977], [-121.21634, 38.71962], [-121.21636, 38.71954], [-121.21648, 38.71935], [-121.21642, 38.71931], [-121.21613, 38.71931], [-121.21612, 38.71922], [-121.21653, 38.71922], [-121.21654, 38.71941], [-121.21696, 38.71986], [-121.2172, 38.71964], [-121.21725, 38.71967], [-121.21702, 38.71992], [-121.21782, 38.72076]]]} | Open Access 1 | 36673 | Roseville holding 42 | 24663 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 4.488 | Roseville holding 42 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);