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 SUID_NMA
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
10509 | 10509 | 10508 | {"type": "Polygon", "coordinates": [[[-117.06598, 32.98269], [-117.06585, 32.98274], [-117.06419, 32.9827], [-117.06299, 32.98277], [-117.06287, 32.98236], [-117.06594, 32.98244], [-117.06598, 32.98269]]]} | Open Access 1 | 18648 | Adobe Ridge Neighborhood Park | 15273 | 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/Adobe-Ridge-Neighborhood-Park-51 | San Diego 4 | 2.549 | Adobe Ridge Neighborhood Park | 0 | Local Park 2 | 4 |
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 |
1586 | 1586 | 1585 | {"type": "Polygon", "coordinates": [[[-117.06676, 32.94232], [-117.06643, 32.94283], [-117.06594, 32.94275], [-117.06601, 32.94232], [-117.06676, 32.94232]]]} | Open Access 1 | 12145 | Bette Bendixen Park | 16050 | 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/Bette-Bendixen-Park-60 | San Diego 4 | 0.774 | Bette Bendixen Park | 0 | Local Park 2 | 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 | |
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 |
1585 | 1585 | 1584 | {"type": "Polygon", "coordinates": [[[-117.04327, 32.96018], [-117.04305, 32.96054], [-117.0429, 32.96068], [-117.04276, 32.96076], [-117.04254, 32.96116], [-117.04239, 32.96125], [-117.04205, 32.96163], [-117.04186, 32.96179], [-117.04183, 32.96185], [-117.0417, 32.96187], [-117.04174, 32.96197], [-117.04159, 32.96217], [-117.04144, 32.96229], [-117.04115, 32.96273], [-117.04119, 32.96292], [-117.04117, 32.96301], [-117.041, 32.96314], [-117.04094, 32.96323], [-117.04088, 32.96365], [-117.04093, 32.96387], [-117.04068, 32.96386], [-117.04065, 32.96266], [-117.04069, 32.96108], [-117.04074, 32.96014], [-117.04327, 32.96018]]]} | Open Access 1 | 12143 | Hilleary Park | 19972 | 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/Hilleary-Park-62 | San Diego 4 | 11.021 | Hilleary 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 | |
10532 | 10532 | 10531 | {"type": "Polygon", "coordinates": [[[-117.05671, 32.95304], [-117.05614, 32.95389], [-117.05578, 32.95413], [-117.05577, 32.95408], [-117.05583, 32.954], [-117.05584, 32.95393], [-117.05578, 32.95385], [-117.05568, 32.95383], [-117.05559, 32.95385], [-117.05553, 32.95393], [-117.05553, 32.954], [-117.0556, 32.95414], [-117.05469, 32.95412], [-117.05472, 32.95331], [-117.05528, 32.95332], [-117.05529, 32.95302], [-117.05671, 32.95304]]]} | Open Access 1 | 18728 | Kumeyaay-Ipai Interpretive Center | 20730 | 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/369/Kumeyaay-Ipai-Interpretive-Center-at-Pau | San Diego 4 | 3.976 | Kumeyaay-Ipai Interpretive Ctr. | 0 | Local Recreation Area 3 | 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 |
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 | ||
8104 | 8104 | 8103 | {"type": "Polygon", "coordinates": [[[-117.04961, 32.95128], [-117.04959, 32.95259], [-117.0487, 32.95287], [-117.04862, 32.95274], [-117.04857, 32.9527], [-117.04834, 32.95276], [-117.0483, 32.95283], [-117.04836, 32.95299], [-117.04851, 32.95333], [-117.04861, 32.95344], [-117.04865, 32.95345], [-117.04875, 32.9534], [-117.04894, 32.95339], [-117.04899, 32.9534], [-117.04958, 32.95322], [-117.04955, 32.95486], [-117.04762, 32.95484], [-117.04715, 32.95525], [-117.04715, 32.95541], [-117.04684, 32.95541], [-117.04686, 32.95479], [-117.04733, 32.95478], [-117.04732, 32.95467], [-117.04737, 32.95287], [-117.04735, 32.95227], [-117.04717, 32.95207], [-117.04717, 32.95198], [-117.04733, 32.95189], [-117.04754, 32.95181], [-117.04772, 32.95176], [-117.04803, 32.95181], [-117.04818, 32.95178], [-117.0492, 32.95134], [-117.04961, 32.95128]]]} | Open Access 1 | 12144 | Poway Community Park | 23930 | 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/307/Community-Park | San Diego 4 | 17.552 | Poway Community Park | 0 | Local Park 2 | 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 | |
13540 | 13540 | 13539 | {"type": "Polygon", "coordinates": [[[-117.02815, 33.00388], [-117.02776, 33.00411], [-117.02767, 33.0045], [-117.02735, 33.00465], [-117.02745, 33.00503], [-117.02729, 33.00571], [-117.02741, 33.00617], [-117.02718, 33.00647], [-117.02748, 33.00684], [-117.02709, 33.00695], [-117.02685, 33.00632], [-117.02636, 33.00622], [-117.02635, 33.00607], [-117.02637, 33.00592], [-117.02701, 33.00604], [-117.02713, 33.00529], [-117.02715, 33.00465], [-117.02718, 33.0044], [-117.02746, 33.00417], [-117.02761, 33.00355], [-117.02726, 33.00317], [-117.02684, 33.00317], [-117.02684, 33.00313], [-117.02686, 33.00309], [-117.02727, 33.00279], [-117.02813, 33.00347], [-117.02815, 33.00388]]]} | Open Access 1 | 35849 | Poway holding 10 | 23933 | 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.566 | Poway holding 10 | 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 | |
13541 | 13541 | 13540 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.00922], [-117.02368, 33.00986], [-117.02367, 33.01319], [-117.02363, 33.01325], [-117.02347, 33.01326], [-117.02353, 33.013], [-117.02353, 33.01255], [-117.02357, 33.01119], [-117.02337, 33.01058], [-117.02331, 33.01021], [-117.02355, 33.00952], [-117.02355, 33.00938], [-117.02348, 33.00917], [-117.02366, 33.00918], [-117.02369, 33.00919], [-117.02371, 33.00922]]]} | Open Access 1 | 35853 | Poway holding 12 | 23935 | 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.944 | Poway holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13543 | 13543 | 13542 | {"type": "Polygon", "coordinates": [[[-117.05278, 33.02232], [-117.05243, 33.02356], [-117.05042, 33.02282], [-117.05057, 33.02268], [-117.05073, 33.02259], [-117.05091, 33.02252], [-117.05125, 33.02246], [-117.05136, 33.02241], [-117.05151, 33.02232], [-117.05278, 33.02232]]]} | Open Access 1 | 35855 | Poway holding 13 | 23936 | 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.433 | Poway holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13542 | 13542 | 13541 | {"type": "Polygon", "coordinates": [[[-117.02825, 33.0206], [-117.02825, 33.02204], [-117.02771, 33.02203], [-117.0277, 33.02191], [-117.02771, 33.02146], [-117.02758, 33.02145], [-117.02758, 33.02065], [-117.02643, 33.02023], [-117.02648, 33.01995], [-117.0274, 33.01995], [-117.02825, 33.0206]]]} | Open Access 1 | 35854 | Poway holding 14 | 23937 | 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.086 | Poway holding 14 | 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]);