units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 129 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, PARK_URL, LABEL_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2780 | 2780 | 2779 | {"type": "MultiPolygon", "coordinates": [[[[-116.97064, 32.98874], [-116.97048, 32.99571], [-116.97003, 32.99569], [-116.96974, 32.9957], [-116.96935, 32.99576], [-116.96907, 32.99583], [-116.96869, 32.99598], [-116.96747, 32.99662], [-116.96603, 32.99716], [-116.96572, 32.99726], [-116.96537, 32.99735], [-116.965, 32.99742], [-116.9641, 32.99752], [-116.96409, 32.99739], [-116.96193, 32.99737], [-116.96202, 32.99245], [-116.95777, 32.99241], [-116.95776, 32.9887], [-116.96204, 32.98869], [-116.97064, 32.98874]]], [[[-116.97043, 32.99718], [-116.97037, 33.00014], [-116.96611, 33.0001], [-116.96618, 32.99841], [-116.96646, 32.99827], [-116.968, 32.99778], [-116.96936, 32.99733], [-116.97043, 32.99718]]]]} | Open Access 1 | 18539 | Rock Haven Spring Open Space | 24509 | 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 | 244.004 | Rock Haven Spring 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 |
10538 | 10538 | 10537 | {"type": "MultiPolygon", "coordinates": [[[[-117.01089, 32.95821], [-117.01062, 32.95821], [-117.01045, 32.95824], [-117.00995, 32.95767], [-117.00893, 32.95625], [-117.00913, 32.95625], [-117.00913, 32.95623], [-117.00912, 32.95621], [-117.01057, 32.95622], [-117.01055, 32.95794], [-117.01064, 32.95795], [-117.01089, 32.95821]]], [[[-117.01245, 32.95986], [-117.01195, 32.95986], [-117.01144, 32.95939], [-117.01055, 32.95838], [-117.01102, 32.95836], [-117.0117, 32.95914], [-117.01245, 32.95986]]]]} | Open Access 1 | 18752 | Garden Road Neighborhood Park | 19203 | 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/Garden-Road-Neighborhood-Park-61 | San Diego 4 | 6.744 | Garden Road Neighborhood Park | 0 | Local Park 2 | 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 | |
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 | |
6080 | 6080 | 6079 | {"type": "MultiPolygon", "coordinates": [[[[-117.0469, 33.01993], [-117.04624, 33.01997], [-117.04608, 33.02002], [-117.04566, 33.0202], [-117.04544, 33.02023], [-117.04533, 33.02021], [-117.04531, 33.02017], [-117.04531, 33.01938], [-117.04538, 33.01905], [-117.0454, 33.01884], [-117.04545, 33.01881], [-117.04689, 33.01881], [-117.0469, 33.01993]]], [[[-117.04567, 33.02064], [-117.04531, 33.02064], [-117.04531, 33.02039], [-117.04566, 33.02036], [-117.04567, 33.02064]]]]} | Open Access 1 | 880 | Valle Verde Neighborhood Park | 31837 | 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/Valle-Verde-Neighborhood-Park-68 | San Diego 4 | 5.213 | Valle Verde 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 | |||
5097 | 5097 | 5096 | {"type": "Polygon", "coordinates": [[[-116.9621, 32.96655], [-116.96206, 32.97747], [-116.95777, 32.97762], [-116.95777, 32.98135], [-116.95346, 32.98146], [-116.95344, 32.9887], [-116.94488, 32.98869], [-116.94483, 32.98514], [-116.94043, 32.9852], [-116.94037, 32.97069], [-116.94486, 32.97075], [-116.95348, 32.97048], [-116.95351, 32.96324], [-116.9578, 32.9631], [-116.9578, 32.9667], [-116.9621, 32.96655]]]} | Open Access 1 | 12109 | Iron Mountain Open Space | 8834 | 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/IronMountainPeakTrail/index.html | San Diego 4 | 884.734 | Iron Mtn. OS | 0 | Local Recreation Area 3 | 4 |
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 | |||
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 | |
13502 | 13502 | 13501 | {"type": "Polygon", "coordinates": [[[-117.00549, 33.03005], [-117.00539, 33.03347], [-117.00095, 33.03353], [-117.0009, 33.0371], [-117.00526, 33.037], [-117.00533, 33.04071], [-116.99687, 33.04097], [-116.99663, 33.04096], [-116.99652, 33.0372], [-116.9965, 33.03012], [-117.00549, 33.03005]]]} | Open Access 1 | 35794 | Poway holding 38 | 23963 | 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 | 203.096 | Poway holding 38 | 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 | |
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 |
13422 | 13422 | 13421 | {"type": "Polygon", "coordinates": [[[-117.01899, 33.00326], [-117.01877, 33.0035], [-117.01828, 33.00434], [-117.01789, 33.00419], [-117.0176, 33.00404], [-117.0174, 33.00384], [-117.01723, 33.00361], [-117.01693, 33.00298], [-117.01687, 33.00254], [-117.01777, 33.00133], [-117.01774, 33.00097], [-117.01699, 33.00054], [-117.01631, 33.00005], [-117.01628, 32.99955], [-117.01612, 32.99902], [-117.01544, 32.99905], [-117.0148, 32.99905], [-117.01479, 32.99948], [-117.01474, 32.99947], [-117.01468, 32.99949], [-117.01462, 32.99951], [-117.01459, 32.99957], [-117.01463, 33.00048], [-117.01462, 33.0005], [-117.01457, 33.00053], [-117.01448, 33.00053], [-117.01441, 32.99889], [-117.01185, 32.99918], [-117.00983, 32.99975], [-117.00991, 32.9967], [-117.01443, 32.99673], [-117.01442, 32.99873], [-117.01597, 32.99816], [-117.01744, 32.99936], [-117.01835, 32.99958], [-117.01826, 33.00023], [-117.01839, 33.00069], [-117.01863, 33.00109], [-117.01899, 33.00326]]]} | Open Access 1 | 35557 | Poway holding 2 | 23943 | 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 | 53.235 | Poway holding 2 | 0 | Local Other or Unknown 14 | 4 | |
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 |
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 | |
13524 | 13524 | 13523 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.95986], [-117.02155, 32.95994], [-117.02103, 32.95994], [-117.02095, 32.96008], [-117.02096, 32.96039], [-117.02106, 32.96047], [-117.02091, 32.96064], [-117.02085, 32.96074], [-117.0208, 32.96091], [-117.0208, 32.96142], [-117.02082, 32.96161], [-117.0209, 32.96194], [-117.02088, 32.96203], [-117.02077, 32.96215], [-117.02066, 32.96219], [-117.02019, 32.96218], [-117.02019, 32.96179], [-117.02008, 32.96109], [-117.02, 32.96079], [-117.01987, 32.96057], [-117.01968, 32.96061], [-117.01969, 32.96053], [-117.01966, 32.96046], [-117.01972, 32.96042], [-117.01971, 32.95998], [-117.01905, 32.95999], [-117.01906, 32.96152], [-117.0189, 32.96152], [-117.01889, 32.95985], [-117.02155, 32.95986]]]} | Open Access 1 | 35821 | Poway holding 8 | 23967 | 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.389 | Poway holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13558 | 13558 | 13557 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.96348], [-117.01891, 32.96349], [-117.01891, 32.96168], [-117.01906, 32.96168], [-117.01907, 32.9623], [-117.0192, 32.96265], [-117.0194, 32.96284], [-117.01979, 32.96292], [-117.01991, 32.9627], [-117.02, 32.96238], [-117.02, 32.96233], [-117.02056, 32.96236], [-117.02085, 32.96229], [-117.02135, 32.96256], [-117.02155, 32.96272], [-117.02155, 32.96348]]]} | Open Access 1 | 35873 | Poway holding 26 | 23950 | 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.785 | Poway holding 26 | 0 | Local Other or Unknown 14 | 4 | |
13430 | 13430 | 13429 | {"type": "Polygon", "coordinates": [[[-117.02163, 33.04292], [-117.0212, 33.04359], [-117.02138, 33.0441], [-117.02079, 33.04412], [-117.02079, 33.04317], [-117.01906, 33.04209], [-117.01646, 33.04278], [-117.01645, 33.04412], [-117.01413, 33.04412], [-117.01409, 33.04239], [-117.01591, 33.04236], [-117.01638, 33.04216], [-117.01783, 33.04196], [-117.01829, 33.04176], [-117.01925, 33.04138], [-117.01935, 33.04108], [-117.01954, 33.0411], [-117.01974, 33.04109], [-117.0199, 33.04104], [-117.02017, 33.04092], [-117.02021, 33.04094], [-117.02042, 33.04111], [-117.02055, 33.04119], [-117.02083, 33.04128], [-117.021, 33.04138], [-117.02114, 33.04151], [-117.02127, 33.04169], [-117.02146, 33.04247], [-117.02147, 33.04256], [-117.02155, 33.04271], [-117.02156, 33.04281], [-117.02163, 33.04292]]]} | Open Access 1 | 35553 | Poway holding 6 | 23965 | 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 | 24.996 | Poway holding 6 | 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]);