units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 129 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST, GAP_STS
DES_TP 10
- Local Other or Unknown 35
- Local Park 13
- Local Recreation Area 12
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 67 ✖
MNG_AGENCY 1
- Poway, City of · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16793 | 16793 | 16792 | {"type": "Polygon", "coordinates": [[[-117.02024, 33.0132], [-117.01973, 33.01329], [-117.0196, 33.01327], [-117.01881, 33.01276], [-117.018, 33.01241], [-117.01699, 33.01269], [-117.01603, 33.01335], [-117.0148, 33.01197], [-117.01092, 33.01197], [-117.01053, 33.01217], [-117.01035, 33.01452], [-117.00984, 33.01458], [-117.00983, 33.01471], [-117.00833, 33.01476], [-117.00624, 33.01481], [-117.00662, 33.00841], [-117.00447, 33.0083], [-117.0041, 33.00787], [-117.00411, 33.00748], [-117.0041, 33.00747], [-116.99613, 33.00752], [-116.99177, 33.00753], [-116.99176, 33.00754], [-116.9918, 33.01127], [-116.98318, 33.01121], [-116.98315, 33.01495], [-116.97885, 33.01493], [-116.97017, 33.01493], [-116.9702, 33.0112], [-116.9788, 33.01115], [-116.97875, 33.00754], [-116.9793, 33.00015], [-116.99639, 33.00024], [-117.00082, 33.0003], [-117.00071, 33.00386], [-117.00072, 33.00387], [-117.00323, 33.00389], [-117.00335, 33.00307], [-117.00395, 33.00205], [-117.00488, 33.00136], [-117.00515, 33.00129], [-117.0052, 33.00035], [-117.00982, 33.00045], [-117.01302, 33.00155], [-117.013, 33.0022], [-117.01471, 33.00223], [-117.01512, 33.00498], [-117.01486, 33.00487], [-117.01466, 33.00484], [-117.01433, 33.00461], [-117.01429, 33.00438], [-117.01365, 33.00411], [-117.01328, 33.00425], [-117.01277, 33.00428], [-117.0125, 33.00436], [-117.01219, 33.00453], [-117.01208, 33.00455], [-117.0117, 33.00453], [-117.01146, 33.00478], [-117.01165, 33.00521], [-117.01182, 33.00566], [-117.012, 33.006], [-117.01222, 33.00624], [-117.01252, 33.00648], [-117.01283, 33.00659], [-117.01299, 33.0066], [-117.01312, 33.00668], [-117.01322, 33.00686], [-117.01302, 33.00707], [-117.01262, 33.00736], [-117.01255, 33.00743], [-117.01258, 33.00747], [-117.01271, 33.00748], [-117.01322, 33.00711], [-117.01354, 33.0068], [-117.01373, 33.0068], [-117.01388, 33.00715], [-117.01392, 33.00721], [-117.01462, 33.00698], [-117.01499, 33.00722], [-117.01517, 33.0073], [-117.01536, 33.00733], [-117.01537, 33.00741], [-117.01711, 33.00742], [-117.01752, 33.00747], [-117.01811, 33.00749], [-117.01833, 33.00748], [-117.01751, 33.00817], [-117.01851, 33.00899], [-117.01915, 33.009], [-117.01873, 33.01011], [-117.0188, 33.01053], [-117.01946, 33.01161], [-117.01963, 33.01217], [-117.01992, 33.01273], [-117.02024, 33.0132]]]} | Open Access 1 | 5420 | Lake Poway Recreation Area | 8838 | 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 | http://poway.org/401/Lake-Poway | San Diego 4 | 1034.046 | Lake Poway Rec. Area | 0 | Local Recreation Area 3 | 4 |
16009 | 16009 | 16008 | {"type": "Polygon", "coordinates": [[[-117.08418, 32.96087], [-117.07554, 32.96077], [-117.07544, 32.95335], [-117.08186, 32.95344], [-117.0818, 32.94971], [-117.08397, 32.94974], [-117.08418, 32.96087]]]} | Open Access 1 | 1755 | Van Dam Peak Open Space | 26824 | 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 | 184.238 | Van Dam Peak OS | 0 | Local Recreation Area 3 | 4 | |
15984 | 15984 | 15983 | {"type": "MultiPolygon", "coordinates": [[[[-117.01745, 32.97317], [-117.01673, 32.97377], [-117.01616, 32.97367], [-117.0147, 32.97437], [-117.01469, 32.97117], [-117.01603, 32.9703], [-117.01612, 32.97046], [-117.01672, 32.97243], [-117.01677, 32.97256], [-117.01688, 32.97275], [-117.01705, 32.97293], [-117.01726, 32.97308], [-117.01745, 32.97317]]], [[[-117.02324, 32.97449], [-117.02117, 32.97444], [-117.0206, 32.97421], [-117.02056, 32.97425], [-117.01967, 32.97394], [-117.01919, 32.97374], [-117.01744, 32.97297], [-117.01714, 32.97277], [-117.01698, 32.97256], [-117.01694, 32.97247], [-117.01632, 32.97046], [-117.01634, 32.97023], [-117.01633, 32.97019], [-117.01676, 32.9699], [-117.01863, 32.96989], [-117.01857, 32.96994], [-117.01835, 32.97001], [-117.01819, 32.9701], [-117.0181, 32.97017], [-117.01791, 32.97039], [-117.01781, 32.97069], [-117.01781, 32.97085], [-117.01785, 32.971], [-117.01791, 32.97115], [-117.01801, 32.97128], [-117.01814, 32.9714], [-117.01829, 32.97149], [-117.01829, 32.97223], [-117.01854, 32.97243], [-117.01913, 32.97247], [-117.01989, 32.97239], [-117.02069, 32.97245], [-117.02147, 32.97268], [-117.02213, 32.97268], [-117.02273, 32.97236], [-117.02272, 32.9717], [-117.02324, 32.97153], [-117.02323, 32.9728], [-117.02324, 32.97449]]]]} | Open Access 1 | 874 | Kent Hill Open Space | 20617 | 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 | 50.693 | Kent Hill OS | 0 | Local Recreation Area 3 | 4 | |
15981 | 15981 | 15980 | {"type": "MultiPolygon", "coordinates": [[[[-117.00783, 32.9815], [-117.00555, 32.98149], [-117.001, 32.98141], [-117.00106, 32.98524], [-117.00045, 32.98523], [-117.00039, 32.98326], [-116.99861, 32.9819], [-116.99807, 32.98189], [-116.99806, 32.98292], [-116.99648, 32.98272], [-116.99645, 32.98134], [-117.00099, 32.98141], [-117.00094, 32.97758], [-117.00554, 32.97769], [-117.00565, 32.97649], [-117.00627, 32.97651], [-117.00622, 32.97771], [-117.00782, 32.97775], [-117.00783, 32.9815]]], [[[-117.00985, 32.97663], [-117.00979, 32.97779], [-117.00848, 32.97776], [-117.00855, 32.97659], [-117.00887, 32.97659], [-117.0089, 32.976], [-117.00956, 32.97602], [-117.00953, 32.97661], [-117.00985, 32.97663]]], [[[-117.01083, 32.97545], [-117.01082, 32.97665], [-117.01018, 32.97663], [-117.01024, 32.97543], [-117.01083, 32.97545]]], [[[-117.01212, 32.97608], [-117.01212, 32.97667], [-117.01147, 32.97666], [-117.01147, 32.97607], [-117.01212, 32.97608]]]]} | Open Access 1 | 871 | Rattlesnake Canyon Open Space | 24193 | 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 | http://powaytrails.com/trails/RattlesnakeCanyonTrail/ | San Diego 4 | 94.949 | Rattlesnake Canyon OS | 0 | Local Recreation Area 3 | 4 |
15638 | 15638 | 15637 | {"type": "Polygon", "coordinates": [[[-117.02536, 33.01762], [-117.0241, 33.01851], [-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 | 45140 | Blue Sky Ecological Reserve | 29221 | 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 | 15.494 | Blue Sky ER | 1991 | Local Conservation Area 4 | 2 | |
15147 | 15147 | 15146 | {"type": "Polygon", "coordinates": [[[-117.06234, 32.97546], [-117.06232, 32.97691], [-117.06225, 32.97692], [-117.06223, 32.97788], [-117.0613, 32.97786], [-117.0613, 32.97764], [-117.06135, 32.9775], [-117.06136, 32.97709], [-117.06132, 32.97698], [-117.06131, 32.97586], [-117.06151, 32.97583], [-117.06157, 32.97545], [-117.06234, 32.97546]]]} | Open Access 1 | 45981 | Arbolitos Sports Field | 29149 | 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 | http://poway.org/Facilities/Facility/Details/Arbolitos-Sports-Fields-54 | San Diego 4 | 5.82 | Arbolitos Sports Field | 0 | Local Recreation Area 3 | 4 |
15124 | 15124 | 15123 | {"type": "Polygon", "coordinates": [[[-117.04737, 32.9529], [-117.04734, 32.95404], [-117.04654, 32.95403], [-117.04656, 32.95289], [-117.04737, 32.9529]]]} | Open Access 1 | 45988 | Valley Soccer Field | 29157 | 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 | http://poway.org/Facilities/Facility/Details/Valley-Soccer-Field-56 | San Diego 4 | 2.335 | Valley Soccer Field | 0 | Local Recreation Area 3 | 4 |
14761 | 14761 | 14760 | {"type": "Polygon", "coordinates": [[[-117.04236, 32.9438], [-117.04177, 32.94509], [-117.04098, 32.94491], [-117.04098, 32.94399], [-117.03967, 32.94268], [-117.03975, 32.9425], [-117.03997, 32.94165], [-117.03999, 32.94162], [-117.04003, 32.94159], [-117.04008, 32.94159], [-117.04035, 32.94167], [-117.04281, 32.94247], [-117.04283, 32.94251], [-117.04283, 32.94256], [-117.04241, 32.94346], [-117.04238, 32.9435], [-117.04228, 32.94355], [-117.04224, 32.94361], [-117.04223, 32.94367], [-117.04225, 32.94372], [-117.0423, 32.94378], [-117.04236, 32.9438]]]} | Open Access 1 | 45142 | Poway Sportsplex | 23969 | 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 | http://www.sportsplexusa.com/content.cfm?n=poway | San Diego 4 | 15.187 | Poway Sportsplex | 0 | None 1268 | |
14760 | 14760 | 14759 | {"type": "Polygon", "coordinates": [[[-117.01594, 33.00726], [-117.01592, 33.0074], [-117.01517, 33.0073], [-117.01499, 33.00722], [-117.01462, 33.00698], [-117.01391, 33.00721], [-117.01373, 33.0068], [-117.01355, 33.0068], [-117.01322, 33.00711], [-117.01271, 33.00748], [-117.01258, 33.00747], [-117.01255, 33.00742], [-117.01302, 33.00707], [-117.01321, 33.00686], [-117.01312, 33.00668], [-117.013, 33.00661], [-117.01283, 33.00659], [-117.01252, 33.00648], [-117.01222, 33.00624], [-117.012, 33.006], [-117.01182, 33.00566], [-117.01165, 33.00521], [-117.01146, 33.00478], [-117.0117, 33.00453], [-117.01208, 33.00455], [-117.01219, 33.00453], [-117.0125, 33.00436], [-117.01277, 33.00428], [-117.01328, 33.00425], [-117.01365, 33.00411], [-117.01429, 33.00438], [-117.01433, 33.00461], [-117.01466, 33.00484], [-117.01486, 33.00487], [-117.01581, 33.00526], [-117.01583, 33.00551], [-117.01569, 33.00573], [-117.0159, 33.00639], [-117.01584, 33.00648], [-117.01594, 33.00726]]]} | Open Access 1 | 45139 | Lake Poway Park | 20962 | 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 | http://poway.org/401/Lake-Poway | San Diego 4 | 24.576 | Lake Poway Park | 0 | Local Park 2 | 4 |
14758 | 14758 | 14757 | {"type": "Polygon", "coordinates": [[[-117.06245, 32.94818], [-117.06243, 32.94856], [-117.06232, 32.94841], [-117.06194, 32.94833], [-117.06196, 32.94802], [-117.06206, 32.94804], [-117.06216, 32.948], [-117.06245, 32.94818]]]} | Open Access 1 | 45136 | Poway Oaks Neighborhood Park | 23968 | 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 | http://powaygis.poway.org/websites/CityOfPowayParks/ | San Diego 4 | 0.44 | Poway Oaks Neighborhood Park | 0 | Local Park 2 | 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 | |
13953 | 13953 | 13952 | {"type": "Polygon", "coordinates": [[[-117.01467, 32.96351], [-117.01068, 32.96361], [-117.01063, 32.96125], [-117.01119, 32.96125], [-117.01145, 32.96129], [-117.01165, 32.96145], [-117.012, 32.96202], [-117.01304, 32.96183], [-117.01339, 32.96141], [-117.01338, 32.96072], [-117.01418, 32.96145], [-117.01434, 32.96161], [-117.01464, 32.96196], [-117.01467, 32.96351]]]} | Open Access 1 | 36589 | Poway holding 36 | 23961 | 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 | 20.871 | Poway holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13573 | 13573 | 13572 | {"type": "Polygon", "coordinates": [[[-117.02693, 33.00207], [-117.02671, 33.00227], [-117.02652, 33.0025], [-117.02693, 33.00285], [-117.02677, 33.00296], [-117.0267, 33.00296], [-117.02655, 33.00283], [-117.02615, 33.00258], [-117.0265, 33.00173], [-117.02682, 33.00172], [-117.02693, 33.00207]]]} | Open Access 1 | 35892 | Poway holding 21 | 23945 | 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 | 1.303 | Poway holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13572 | 13572 | 13571 | {"type": "Polygon", "coordinates": [[[-117.02405, 33.00214], [-117.02394, 33.00214], [-117.02394, 33.00177], [-117.02401, 33.00177], [-117.02405, 33.00214]]]} | Open Access 1 | 35891 | Poway holding 22 | 23946 | 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.091 | Poway holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13571 | 13571 | 13570 | {"type": "Polygon", "coordinates": [[[-117.03068, 33.02743], [-117.03049, 33.02762], [-117.03026, 33.02759], [-117.02995, 33.02739], [-117.02999, 33.0271], [-117.0306, 33.02717], [-117.03068, 33.02743]]]} | Open Access 1 | 35890 | Poway holding 16 | 23939 | 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.701 | Poway holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13570 | 13570 | 13569 | {"type": "Polygon", "coordinates": [[[-117.02761, 33.01797], [-117.0268, 33.01789], [-117.02633, 33.01779], [-117.02581, 33.01761], [-117.02556, 33.0175], [-117.02533, 33.01736], [-117.02512, 33.01722], [-117.02493, 33.01706], [-117.02462, 33.01673], [-117.02435, 33.01626], [-117.0242, 33.01588], [-117.02413, 33.01561], [-117.02411, 33.01538], [-117.02404, 33.01406], [-117.02405, 33.00967], [-117.02421, 33.00752], [-117.02423, 33.00748], [-117.02427, 33.00746], [-117.02452, 33.00747], [-117.02444, 33.00763], [-117.02428, 33.00781], [-117.02427, 33.00824], [-117.02433, 33.00874], [-117.02453, 33.00876], [-117.02567, 33.00915], [-117.02558, 33.00927], [-117.02493, 33.00904], [-117.02432, 33.00886], [-117.02415, 33.00934], [-117.02414, 33.01027], [-117.02433, 33.01055], [-117.02416, 33.01078], [-117.02428, 33.01198], [-117.02412, 33.01289], [-117.02413, 33.0135], [-117.02423, 33.01492], [-117.02433, 33.01536], [-117.02454, 33.0158], [-117.02464, 33.01648], [-117.02518, 33.01699], [-117.02543, 33.01719], [-117.02575, 33.0174], [-117.0261, 33.01757], [-117.02641, 33.01769], [-117.02668, 33.01774], [-117.02694, 33.01776], [-117.02718, 33.01774], [-117.02748, 33.01768], [-117.02761, 33.01797]]]} | Open Access 1 | 35889 | Poway holding 19 | 23942 | 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 | 5.896 | Poway holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13567 | 13567 | 13566 | {"type": "Polygon", "coordinates": [[[-117.06327, 32.94069], [-117.06306, 32.94078], [-117.06169, 32.94128], [-117.0611, 32.94144], [-117.06072, 32.9415], [-117.06022, 32.94152], [-117.05984, 32.94149], [-117.05853, 32.94129], [-117.05793, 32.94123], [-117.05736, 32.94113], [-117.05799, 32.93991], [-117.05821, 32.93985], [-117.05851, 32.93909], [-117.0584, 32.93834], [-117.0578, 32.93806], [-117.05733, 32.93674], [-117.05925, 32.93567], [-117.05995, 32.93537], [-117.05998, 32.93542], [-117.06001, 32.93541], [-117.06008, 32.93543], [-117.0604, 32.93597], [-117.06052, 32.93624], [-117.06071, 32.93649], [-117.06182, 32.93759], [-117.0621, 32.93796], [-117.06238, 32.9384], [-117.06325, 32.94015], [-117.06327, 32.94069]]]} | Open Access 1 | 35884 | Poway holding 24 | 23948 | 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 | 60.262 | Poway holding 24 | 0 | Local Other or Unknown 14 | 4 | |
13565 | 13565 | 13564 | {"type": "Polygon", "coordinates": [[[-117.02115, 33.0368], [-117.02121, 33.03705], [-117.0212, 33.03732], [-117.02117, 33.03749], [-117.02106, 33.03778], [-117.01992, 33.03762], [-117.01916, 33.03763], [-117.01847, 33.03811], [-117.01844, 33.03675], [-117.01851, 33.03601], [-117.01863, 33.03599], [-117.01867, 33.03628], [-117.01921, 33.03685], [-117.01949, 33.03686], [-117.01956, 33.03695], [-117.01967, 33.03697], [-117.01975, 33.03695], [-117.01984, 33.03688], [-117.01992, 33.03686], [-117.02016, 33.03684], [-117.02051, 33.03686], [-117.02086, 33.03683], [-117.02109, 33.03678], [-117.02115, 33.0368]]]} | Open Access 1 | 35879 | Poway holding 23 | 23947 | 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 | 6.883 | Poway holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13562 | 13562 | 13561 | {"type": "Polygon", "coordinates": [[[-117.00336, 33.02647], [-117.00107, 33.02643], [-117.00114, 33.02272], [-117.00329, 33.02279], [-117.00336, 33.02647]]]} | Open Access 1 | 35877 | Poway holding 20 | 23944 | 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 | 21.006 | Poway holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13559 | 13559 | 13558 | {"type": "Polygon", "coordinates": [[[-117.04405, 32.94565], [-117.04344, 32.94627], [-117.0432, 32.94661], [-117.04302, 32.94695], [-117.04291, 32.94721], [-117.04284, 32.94748], [-117.04268, 32.94849], [-117.04261, 32.94875], [-117.04244, 32.94924], [-117.04222, 32.9497], [-117.04196, 32.95008], [-117.04164, 32.95046], [-117.04123, 32.95084], [-117.04107, 32.95104], [-117.04093, 32.95105], [-117.04101, 32.94915], [-117.04098, 32.94491], [-117.04177, 32.94509], [-117.04247, 32.94521], [-117.04364, 32.94544], [-117.04405, 32.94565]]]} | Open Access 1 | 35874 | Poway holding 25 | 23949 | 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 | 25.737 | Poway holding 25 | 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]);