units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where COUNTY = 4 and MNG_AGENCY = 129 sorted by DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |||
6084 | 6084 | 6083 | {"type": "Polygon", "coordinates": [[[-117.03743, 32.96938], [-117.03742, 32.97105], [-117.03627, 32.97104], [-117.03628, 32.96938], [-117.03743, 32.96938]]]} | Open Access 1 | 890 | Old Poway Park and Railroad | 23098 | 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/452/Old-Poway-Park | San Diego 4 | 4.928 | Old Poway Park and Railroad | None 491 | ||
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 | |||
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 | |||
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 | |
7830 | 7830 | 7829 | {"type": "Polygon", "coordinates": [[[-117.05962, 32.93512], [-117.05625, 32.93698], [-117.05427, 32.93557], [-117.05391, 32.93515], [-117.05962, 32.93512]]]} | Open Access 1 | 35850 | Poway holding 11 | 23934 | 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 | 13.923 | Poway holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13400 | 13400 | 13399 | {"type": "Polygon", "coordinates": [[[-117.02894, 33.01149], [-117.02839, 33.01226], [-117.02831, 33.01206], [-117.0279, 33.01182], [-117.02767, 33.01162], [-117.02781, 33.01138], [-117.02765, 33.01079], [-117.02712, 33.01022], [-117.0267, 33.00993], [-117.02621, 33.00987], [-117.02595, 33.00955], [-117.02569, 33.00944], [-117.02576, 33.00932], [-117.0259, 33.00914], [-117.02663, 33.00952], [-117.02678, 33.00925], [-117.0269, 33.00896], [-117.02702, 33.00866], [-117.02713, 33.00822], [-117.02757, 33.00777], [-117.02751, 33.00701], [-117.02768, 33.00696], [-117.02795, 33.00752], [-117.02735, 33.00867], [-117.02731, 33.00986], [-117.02804, 33.01051], [-117.02894, 33.01149]]]} | Open Access 1 | 35512 | Poway holding 29 | 23953 | 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 | 8.564 | Poway holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13401 | 13401 | 13400 | {"type": "Polygon", "coordinates": [[[-117.06276, 32.93262], [-117.06259, 32.93285], [-117.06243, 32.93294], [-117.06232, 32.93308], [-117.06211, 32.93322], [-117.06207, 32.93368], [-117.06184, 32.93365], [-117.06165, 32.93359], [-117.06148, 32.93352], [-117.06123, 32.93336], [-117.06172, 32.93277], [-117.06228, 32.93288], [-117.06276, 32.93262]]]} | Open Access 1 | 35513 | Poway holding 27 | 23951 | 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.662 | Poway holding 27 | 0 | Local Other or Unknown 14 | 4 | |
13409 | 13409 | 13408 | {"type": "Polygon", "coordinates": [[[-117.02379, 33.00511], [-117.02377, 33.00515], [-117.02368, 33.00518], [-117.02366, 33.00476], [-117.02327, 33.00289], [-117.02341, 33.00257], [-117.0234, 33.00228], [-117.02348, 33.00229], [-117.02352, 33.00233], [-117.02348, 33.00314], [-117.0235, 33.00363], [-117.02379, 33.00511]]]} | Open Access 1 | 35556 | Poway holding 1 | 23932 | 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.739 | Poway holding 1 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
13431 | 13431 | 13430 | {"type": "Polygon", "coordinates": [[[-117.06328, 32.94091], [-117.06329, 32.94167], [-117.06327, 32.94175], [-117.06322, 32.9418], [-117.06314, 32.94186], [-117.06307, 32.94188], [-117.0623, 32.94191], [-117.06217, 32.94194], [-117.06206, 32.94199], [-117.06198, 32.94207], [-117.06193, 32.94217], [-117.06192, 32.94228], [-117.06135, 32.94229], [-117.06146, 32.94309], [-117.06154, 32.94327], [-117.06148, 32.94368], [-117.06178, 32.94378], [-117.06159, 32.94404], [-117.06156, 32.94419], [-117.06017, 32.94606], [-117.05968, 32.94581], [-117.05959, 32.945], [-117.05574, 32.94526], [-117.05385, 32.94458], [-117.05495, 32.94345], [-117.05483, 32.94322], [-117.05478, 32.94321], [-117.05458, 32.9416], [-117.05491, 32.94153], [-117.05495, 32.94165], [-117.05706, 32.9425], [-117.05721, 32.94244], [-117.05859, 32.94298], [-117.05881, 32.94152], [-117.06002, 32.9417], [-117.06041, 32.9417], [-117.06087, 32.94166], [-117.06127, 32.9416], [-117.06164, 32.9415], [-117.06328, 32.94091]]]} | Open Access 1 | 35554 | Poway holding 3 | 23954 | 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 | 59.873 | Poway holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13432 | 13432 | 13431 | {"type": "Polygon", "coordinates": [[[-117.02617, 33.00623], [-117.02578, 33.00626], [-117.0255, 33.0061], [-117.02516, 33.00568], [-117.02487, 33.00565], [-117.02439, 33.00576], [-117.0243, 33.00716], [-117.02459, 33.0073], [-117.02428, 33.0073], [-117.02425, 33.00729], [-117.02423, 33.00725], [-117.02422, 33.00722], [-117.02427, 33.00658], [-117.02428, 33.00627], [-117.02427, 33.00577], [-117.02425, 33.00555], [-117.02388, 33.00376], [-117.02386, 33.00356], [-117.02384, 33.0031], [-117.02388, 33.00235], [-117.0239, 33.00232], [-117.02394, 33.0023], [-117.02404, 33.00229], [-117.02402, 33.00268], [-117.0247, 33.00289], [-117.02451, 33.00337], [-117.02431, 33.00428], [-117.02428, 33.00459], [-117.02444, 33.00473], [-117.02482, 33.00514], [-117.02562, 33.00557], [-117.02562, 33.00588], [-117.02572, 33.00598], [-117.02616, 33.00603], [-117.02617, 33.00623]]]} | Open Access 1 | 35555 | Poway holding 4 | 23964 | 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.991 | Poway holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13433 | 13433 | 13432 | {"type": "Polygon", "coordinates": [[[-117.02384, 33.00745], [-117.02372, 33.00902], [-117.0237, 33.00904], [-117.02343, 33.00903], [-117.0236, 33.00877], [-117.02364, 33.0079], [-117.02322, 33.00746], [-117.02384, 33.00745]]]} | Open Access 1 | 35558 | Poway holding 7 | 23966 | 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.96 | Poway holding 7 | 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 | |
13507 | 13507 | 13506 | {"type": "Polygon", "coordinates": [[[-117.02323, 33.03387], [-117.02274, 33.03451], [-117.02253, 33.03474], [-117.02131, 33.03575], [-117.02116, 33.03585], [-117.02103, 33.03592], [-117.02086, 33.03597], [-117.0205, 33.03603], [-117.02019, 33.03599], [-117.01962, 33.03585], [-117.01922, 33.0358], [-117.01917, 33.03576], [-117.01909, 33.03566], [-117.01898, 33.03562], [-117.01887, 33.03564], [-117.0188, 33.0357], [-117.01876, 33.03578], [-117.01872, 33.03582], [-117.01852, 33.03584], [-117.0187, 33.03328], [-117.02247, 33.03317], [-117.02249, 33.03358], [-117.02232, 33.03364], [-117.02187, 33.03382], [-117.0216, 33.03389], [-117.02024, 33.03403], [-117.02005, 33.03407], [-117.0199, 33.03413], [-117.01975, 33.03422], [-117.01953, 33.03442], [-117.0195, 33.0345], [-117.01919, 33.03449], [-117.01889, 33.03529], [-117.01998, 33.03546], [-117.02089, 33.03505], [-117.02144, 33.03483], [-117.02276, 33.03424], [-117.02286, 33.03373], [-117.02303, 33.03376], [-117.02318, 33.03382], [-117.02323, 33.03387]]]} | Open Access 1 | 35792 | Poway holding 17 | 23940 | 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 | 16.135 | Poway holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13508 | 13508 | 13507 | {"type": "Polygon", "coordinates": [[[-117.05244, 32.94534], [-117.05245, 32.946], [-117.05201, 32.94727], [-117.05199, 32.94823], [-117.0518, 32.94822], [-117.0513, 32.94828], [-117.05087, 32.94837], [-117.0503, 32.94854], [-117.04966, 32.94861], [-117.04965, 32.94884], [-117.04926, 32.94898], [-117.04886, 32.94908], [-117.04851, 32.94913], [-117.04806, 32.94914], [-117.04719, 32.94914], [-117.04497, 32.94911], [-117.04457, 32.94908], [-117.04435, 32.94902], [-117.04404, 32.94897], [-117.04387, 32.94896], [-117.04333, 32.94899], [-117.04283, 32.94892], [-117.0429, 32.94867], [-117.04306, 32.9476], [-117.0431, 32.94741], [-117.04319, 32.94716], [-117.04332, 32.94688], [-117.04347, 32.94663], [-117.04365, 32.94638], [-117.04443, 32.94544], [-117.04458, 32.94519], [-117.04473, 32.94493], [-117.04484, 32.94468], [-117.04501, 32.94413], [-117.0461, 32.94432], [-117.04752, 32.94427], [-117.04807, 32.94422], [-117.04918, 32.94464], [-117.05211, 32.94535], [-117.05244, 32.94534]]]} | Open Access 1 | 35793 | Poway holding 18 | 23941 | 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 | 94.222 | Poway holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13522 | 13522 | 13521 | {"type": "Polygon", "coordinates": [[[-117.0667, 32.93509], [-117.06608, 32.93509], [-117.06608, 32.93563], [-117.06586, 32.93563], [-117.06584, 32.93509], [-117.06421, 32.9351], [-117.06356, 32.93482], [-117.06295, 32.9351], [-117.06222, 32.93511], [-117.06222, 32.93513], [-117.06232, 32.93522], [-117.06227, 32.93524], [-117.06225, 32.93528], [-117.06224, 32.93532], [-117.06225, 32.93536], [-117.06196, 32.93565], [-117.06156, 32.9357], [-117.06157, 32.93563], [-117.06154, 32.93558], [-117.06149, 32.93553], [-117.06141, 32.93552], [-117.06141, 32.93511], [-117.06204, 32.93511], [-117.06205, 32.93509], [-117.06188, 32.93492], [-117.06198, 32.93491], [-117.06198, 32.9349], [-117.06196, 32.93488], [-117.06267, 32.93479], [-117.06298, 32.93478], [-117.06579, 32.93453], [-117.06636, 32.9345], [-117.06669, 32.93451], [-117.0667, 32.93509]]]} | Open Access 1 | 35819 | Poway holding 34 | 23959 | 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.144 | Poway holding 34 | 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]);