units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where AGNCY_LEV = 2 and MNG_AGENCY = 129 sorted by UNIT_ID descending
This data as json, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5282 | 5282 | 5281 | {"type": "Polygon", "coordinates": [[[-116.9986, 32.96095], [-116.99776, 32.96117], [-116.99758, 32.96085], [-116.99794, 32.96067], [-116.9981, 32.96063], [-116.99835, 32.96059], [-116.99841, 32.96063], [-116.9985, 32.96081], [-116.9986, 32.96095]]]} | Open Access 1 | 47639 | Sycamore Creek Neighborhood Park - East | 31380 | 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.91 | Sycamore Creek Neighborhood Park - East | None 426 | |||
7623 | 7623 | 7622 | {"type": "Polygon", "coordinates": [[[-117.00188, 32.95969], [-117.0015, 32.95981], [-117.00141, 32.95964], [-117.00186, 32.95949], [-117.00188, 32.95969]]]} | Open Access 1 | 47638 | Sycamore Creek Neighborhood Park - West | 31379 | 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.215 | Sycamore Creek Neighborhood Park - West | None 636 | |||
4390 | 4390 | 4389 | {"type": "Polygon", "coordinates": [[[-117.036, 32.97054], [-117.03563, 32.97054], [-117.03563, 32.9703], [-117.036, 32.9703], [-117.036, 32.97054]]]} | Open Access 1 | 45989 | Veteran's Park | 29158 | 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/538/Veterans-Park | San Diego 4 | 0.229 | Veteran's Park | 0 | Local Park 2 | 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 |
4389 | 4389 | 4388 | {"type": "Polygon", "coordinates": [[[-117.06741, 32.94582], [-117.06611, 32.94579], [-117.06614, 32.94569], [-117.06613, 32.94558], [-117.06599, 32.94508], [-117.066, 32.94497], [-117.06604, 32.94487], [-117.0661, 32.94481], [-117.06617, 32.94477], [-117.06647, 32.94467], [-117.06665, 32.94462], [-117.06687, 32.94461], [-117.06698, 32.94458], [-117.06741, 32.94582]]]} | Open Access 1 | 45987 | The Pond | 29156 | 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 | 3.291 | The Pond | None 391 | |||
8112 | 8112 | 8111 | {"type": "Polygon", "coordinates": [[[-117.06078, 32.97858], [-117.06075, 32.97861], [-117.06059, 32.97867], [-117.06062, 32.9786], [-117.06061, 32.97846], [-117.06058, 32.97832], [-117.06048, 32.97802], [-117.06045, 32.97768], [-117.0605, 32.9775], [-117.06054, 32.97747], [-117.06059, 32.97744], [-117.06071, 32.97746], [-117.06076, 32.9775], [-117.06085, 32.97754], [-117.06088, 32.97759], [-117.06089, 32.97768], [-117.06085, 32.97788], [-117.06086, 32.97808], [-117.0608, 32.97822], [-117.06076, 32.97827], [-117.06079, 32.97845], [-117.06078, 32.97858]]]} | Open Access 1 | 45982 | Arbolitos Mini Park | 29150 | 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-Mini-Park-59 | San Diego 4 | 0.904 | Arbolitos MP | 0 | Local Park 2 | 4 |
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 |
7819 | 7819 | 7818 | {"type": "Polygon", "coordinates": [[[-117.03972, 33.04402], [-117.03943, 33.0444], [-117.03888, 33.04486], [-117.03845, 33.04501], [-117.03841, 33.04513], [-117.03859, 33.04512], [-117.03865, 33.04535], [-117.03844, 33.04562], [-117.03814, 33.04572], [-117.03826, 33.04578], [-117.03836, 33.04591], [-117.03828, 33.04624], [-117.03818, 33.04641], [-117.03827, 33.04668], [-117.03823, 33.04682], [-117.03792, 33.04698], [-117.03759, 33.047], [-117.03783, 33.04722], [-117.03797, 33.04745], [-117.03789, 33.048], [-117.03771, 33.04806], [-117.0377, 33.04816], [-117.03778, 33.04815], [-117.03782, 33.04825], [-117.03805, 33.04818], [-117.03825, 33.0486], [-117.03828, 33.04894], [-117.03825, 33.04912], [-117.03773, 33.05005], [-117.03685, 33.05007], [-117.03641, 33.0508], [-117.03551, 33.05159], [-117.03526, 33.05167], [-117.03535, 33.05175], [-117.03535, 33.05196], [-117.03492, 33.05207], [-117.03493, 33.05208], [-117.03535, 33.05209], [-117.03564, 33.05265], [-117.03564, 33.05294], [-117.03546, 33.0533], [-117.03525, 33.05341], [-117.03491, 33.05349], [-117.03449, 33.05379], [-117.03405, 33.05399], [-117.03372, 33.05402], [-117.03355, 33.05395], [-117.0332, 33.0535], [-117.03299, 33.0536], [-117.03251, 33.05366], [-117.0322, 33.05358], [-117.0319, 33.05323], [-117.0317, 33.05276], [-117.03172, 33.0526], [-117.03161, 33.05254], [-117.03152, 33.05235], [-117.03142, 33.05222], [-117.03121, 33.05205], [-117.03118, 33.05189], [-117.031, 33.05176], [-117.03082, 33.05168], [-117.03078, 33.05199], [-117.03021, 33.05221], [-117.03018, 33.05235], [-117.03005, 33.05247], [-117.0298, 33.05251], [-117.02974, 33.05266], [-117.02965, 33.05275], [-117.02977, 33.05283], [-117.02994, 33.05303], [-117.02985, 33.05319], [-117.03003, 33.0532], [-117.03029, 33.05356], [-117.02997, 33.05366], [-117.03029, 33.05384], [-117.03015, 33.05422], [-117.02991, 33.05429], [-117.03009, 33.05449], [-117.0301, 33.0548], [-117.02958, 33.05524], [-117.02954, 33.05553], [-117.02843, 33.05665], [-117.02719, 33.05498], [-117.02941, 33.05187], [-117.02865, 33.05038], [-117.02823, 33.05039], [-117.02836, 33.05023], [-117.0285, 33.04996], [-117.02865, 33.04978], [-117.03273, 33.04973], [-117.03274, 33.04972], [-117.0327, 33.04686], [-117.03187, 33.04596], [-117.03187, 33.04407], [-117.0268, 33.04408], [-117.02681, 33.04403], [-117.02936, 33.04402], [-117.02925, 33.04297], [-117.02982, 33.0424], [-117.03205, 33.04177], [-117.03183, 33.03683], [-117.03128, 33.03703], [-117.03115, 33.03705], [-117.03105, 33.03702], [-117.03078, 33.03701], [-117.03029, 33.03705], [-117.03004, 33.03693], [-117.03, 33.03687], [-117.02993, 33.03669], [-117.02962, 33.03636], [-117.0295, 33.03605], [-117.02942, 33.03576], [-117.02934, 33.03565], [-117.02929, 33.03539], [-117.02918, 33.03537], [-117.0287, 33.03495], [-117.02858, 33.03483], [-117.02838, 33.03472], [-117.02919, 33.03406], [-117.02919, 33.03422], [-117.02916, 33.03453], [-117.02944, 33.03467], [-117.03002, 33.03461], [-117.03033, 33.03469], [-117.03025, 33.03518], [-117.02965, 33.03624], [-117.03035, 33.03686], [-117.03087, 33.03678], [-117.03125, 33.0362], [-117.03135, 33.03618], [-117.0315, 33.03609], [-117.03161, 33.03599], [-117.03171, 33.03587], [-117.03179, 33.03561], [-117.03179, 33.03547], [-117.03175, 33.03535], [-117.03168, 33.0352], [-117.03157, 33.03508], [-117.03066, 33.03436], [-117.03054, 33.03421], [-117.03048, 33.03405], [-117.03071, 33.034], [-117.03078, 33.03386], [-117.0313, 33.03387], [-117.03106, 33.03315], [-117.03106, 33.03288], [-117.03202, 33.03289], [-117.03187, 33.03648], [-117.03222, 33.04407], [-117.03972, 33.04402]]]} | No Public Access 3 | 45249 | City of Poway Open Space | 17327 | 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 | 193.801 | City of Poway OS | 0 | Local Recreation Area 3 | 4 | |
7816 | 7816 | 7815 | {"type": "MultiPolygon", "coordinates": [[[[-117.0238, 32.94716], [-117.02334, 32.94716], [-117.02334, 32.94677], [-117.0238, 32.94716], [-117.0238, 32.94716]]], [[[-117.02744, 32.94658], [-117.02719, 32.94638], [-117.02698, 32.94607], [-117.02686, 32.94597], [-117.02666, 32.94591], [-117.02635, 32.94586], [-117.02634, 32.94595], [-117.02591, 32.94584], [-117.02519, 32.94576], [-117.02518, 32.94566], [-117.02466, 32.94565], [-117.02465, 32.94555], [-117.02432, 32.94554], [-117.0241, 32.94551], [-117.02409, 32.94572], [-117.02373, 32.94561], [-117.02335, 32.94552], [-117.02335, 32.94532], [-117.02743, 32.94536], [-117.02744, 32.94658]]]]} | Open Access 1 | 45218 | City of Poway Open Space | 17328 | 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.096 | City of Poway OS | 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 | |
4239 | 4239 | 4238 | {"type": "Polygon", "coordinates": [[[-117.03828, 32.97303], [-117.03824, 32.97304], [-117.03825, 32.97329], [-117.03774, 32.97329], [-117.03773, 32.9732], [-117.03628, 32.9732], [-117.03627, 32.97203], [-117.03699, 32.97203], [-117.03699, 32.97174], [-117.03723, 32.97173], [-117.03723, 32.97121], [-117.03822, 32.97121], [-117.03824, 32.97285], [-117.03827, 32.97286], [-117.03828, 32.97303]]]} | Open Access 1 | 45141 | Aubrey Park | 15683 | 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/Aubrey-Park-58 | San Diego 4 | 8.287 | Aubrey Park | 0 | Local Park 2 | 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 | |
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 |
4183 | 4183 | 4182 | {"type": "MultiPolygon", "coordinates": [[[[-117.06172, 32.93278], [-117.06122, 32.93336], [-117.06087, 32.93316], [-117.06071, 32.9331], [-117.06052, 32.93306], [-117.06016, 32.93303], [-117.05996, 32.93305], [-117.05974, 32.9331], [-117.05968, 32.93308], [-117.05965, 32.93305], [-117.05923, 32.93194], [-117.05911, 32.93166], [-117.05887, 32.93122], [-117.05859, 32.93084], [-117.05859, 32.93079], [-117.05882, 32.93064], [-117.05916, 32.93101], [-117.0608, 32.93016], [-117.06098, 32.93018], [-117.0599, 32.93081], [-117.05979, 32.93128], [-117.06026, 32.93172], [-117.0606, 32.93182], [-117.06093, 32.93184], [-117.06127, 32.93176], [-117.0615, 32.93172], [-117.06153, 32.93243], [-117.06172, 32.93278]]], [[[-117.06669, 32.93294], [-117.06648, 32.93266], [-117.06644, 32.93238], [-117.06648, 32.93208], [-117.06625, 32.932], [-117.06608, 32.9318], [-117.06621, 32.93138], [-117.06616, 32.93133], [-117.06597, 32.93138], [-117.06552, 32.93156], [-117.06489, 32.93141], [-117.06501, 32.93102], [-117.06506, 32.93069], [-117.06543, 32.93045], [-117.06548, 32.93009], [-117.0652, 32.92941], [-117.06497, 32.92918], [-117.06473, 32.929], [-117.06367, 32.92871], [-117.06354, 32.92923], [-117.0635, 32.92922], [-117.06361, 32.9287], [-117.06028, 32.92779], [-117.06534, 32.92774], [-117.06556, 32.928], [-117.06579, 32.92819], [-117.06596, 32.92829], [-117.06668, 32.92866], [-117.06669, 32.93294]]], [[[-117.06581, 32.93938], [-117.06576, 32.93969], [-117.06569, 32.93966], [-117.06569, 32.93963], [-117.06539, 32.93946], [-117.06532, 32.93947], [-117.06505, 32.93936], [-117.06446, 32.93929], [-117.06429, 32.9389], [-117.06405, 32.93887], [-117.0639, 32.93843], [-117.063, 32.93833], [-117.06287, 32.93795], [-117.06274, 32.93769], [-117.06286, 32.93761], [-117.06308, 32.93783], [-117.06349, 32.93754], [-117.06399, 32.93805], [-117.06412, 32.93807], [-117.06478, 32.93895], [-117.06507, 32.93898], [-117.06505, 32.93915], [-117.06581, 32.93938]]], [[[-117.06668, 32.92848], [-117.06592, 32.92807], [-117.06573, 32.92792], [-117.06557, 32.92774], [-117.06668, 32.92773], [-117.06668, 32.92848]]]]} | No Public Access 3 | 44864 | South Poway Cornerstone | 25675 | 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 | 37.928 | South Poway Cornerstone | None 364 | |||
3581 | 3581 | 3580 | {"type": "Polygon", "coordinates": [[[-117.06669, 32.93389], [-117.06669, 32.93424], [-117.06636, 32.93423], [-117.06575, 32.93426], [-117.06303, 32.93451], [-117.06295, 32.93426], [-117.06337, 32.93406], [-117.06374, 32.93381], [-117.06492, 32.93381], [-117.06669, 32.93389]]]} | Open Access 1 | 36687 | Poway holding 30 | 23955 | 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 | 4.51 | Poway holding 30 | 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 | |
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 |
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]);