units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where MNG_AGENCY = 101
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 43
- Local Conservation Area 27
- Local Recreation Area 6
- Local Other or Unknown 4
- None 1
- None 1
- None 1
ACCESS_TYP 4
MNG_AG_TYP 1
MNG_AGENCY 1
- San Diego, County of · 83 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6179 | 6179 | 6178 | {"type": "Polygon", "coordinates": [[[-117.11321, 33.4123], [-117.11289, 33.41266], [-117.1124, 33.41359], [-117.11121, 33.41278], [-117.11054, 33.41298], [-117.10972, 33.4128], [-117.10938, 33.41231], [-117.10899, 33.41231], [-117.10623, 33.4129], [-117.10374, 33.41236], [-117.1033, 33.4123], [-117.10365, 33.41528], [-117.0977, 33.41534], [-117.09748, 33.41496], [-117.09743, 33.41491], [-117.09735, 33.41487], [-117.09697, 33.41478], [-117.09692, 33.41473], [-117.09693, 33.41467], [-117.09689, 33.41455], [-117.09675, 33.41441], [-117.09648, 33.41432], [-117.09612, 33.414], [-117.09606, 33.41398], [-117.09598, 33.414], [-117.09593, 33.41405], [-117.09582, 33.41435], [-117.09578, 33.41451], [-117.09559, 33.41471], [-117.09566, 33.41531], [-117.09569, 33.41535], [-117.0958, 33.41567], [-117.0958, 33.41579], [-117.09578, 33.41591], [-117.09565, 33.41619], [-117.09546, 33.41631], [-117.09512, 33.4166], [-117.09511, 33.41667], [-117.09518, 33.41676], [-117.09519, 33.41684], [-117.09516, 33.41689], [-117.09497, 33.41701], [-117.09486, 33.41713], [-117.09482, 33.41726], [-117.09484, 33.41742], [-117.09483, 33.4175], [-117.09475, 33.41763], [-117.09472, 33.41775], [-117.09473, 33.41799], [-117.09479, 33.41844], [-117.09481, 33.41855], [-117.09476, 33.41895], [-117.09476, 33.41905], [-117.09483, 33.41908], [-117.09506, 33.41908], [-117.0951, 33.4198], [-117.09514, 33.4209], [-117.09526, 33.42291], [-117.09097, 33.42296], [-117.09102, 33.42379], [-117.08878, 33.42387], [-117.08865, 33.42348], [-117.08854, 33.42301], [-117.09096, 33.42296], [-117.09042, 33.41541], [-117.09032, 33.41197], [-117.0873, 33.41198], [-117.08728, 33.40855], [-117.09023, 33.40853], [-117.09014, 33.40506], [-117.08586, 33.40504], [-117.08585, 33.40349], [-117.08401, 33.40348], [-117.08388, 33.40276], [-117.08385, 33.4021], [-117.08377, 33.40175], [-117.08584, 33.40179], [-117.10209, 33.40231], [-117.10282, 33.40838], [-117.10377, 33.40848], [-117.10378, 33.40847], [-117.10306, 33.40238], [-117.11128, 33.4029], [-117.11148, 33.40933], [-117.11249, 33.40945], [-117.11291, 33.41202], [-117.11321, 33.4123]]]} | No Public Access 3 | 1219 | Mt. Olympus Preserve | 29249 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 801.066 | Mt. Olympus Preserve | 0 | Local Conservation Area 4 | 2 | |
6239 | 6239 | 6238 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 1304 | 4S Ranch Heritage Park | 29226 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.39 | 4S Ranch Heritage Park | 0 | Local Park 2 | 4 |
6246 | 6246 | 6245 | {"type": "Polygon", "coordinates": [[[-116.94799, 32.91919], [-116.9479, 32.9194], [-116.94782, 32.91975], [-116.94779, 32.92], [-116.94773, 32.92102], [-116.94765, 32.92139], [-116.94752, 32.9217], [-116.94737, 32.92196], [-116.94723, 32.92215], [-116.94709, 32.9223], [-116.94682, 32.92256], [-116.94467, 32.92255], [-116.94468, 32.92624], [-116.94182, 32.92273], [-116.94182, 32.92266], [-116.9425, 32.92262], [-116.9425, 32.92233], [-116.9431, 32.92209], [-116.9443, 32.92249], [-116.94467, 32.92196], [-116.94372, 32.92144], [-116.94243, 32.92133], [-116.94217, 32.92151], [-116.94218, 32.92234], [-116.94182, 32.92235], [-116.94182, 32.91918], [-116.94466, 32.91917], [-116.94799, 32.91919]]]} | Open Access 1 | 1322 | Berkeley Hering Holding | 29227 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 59.032 | Berkeley Hering Holding | None 506 | |||
6269 | 6269 | 6268 | {"type": "MultiPolygon", "coordinates": [[[[-116.98966, 32.91956], [-116.98937, 32.91956], [-116.9895, 32.9339], [-116.98364, 32.93398], [-116.98356, 32.9343], [-116.98403, 32.93561], [-116.98442, 32.93603], [-116.98441, 32.93658], [-116.98424, 32.93807], [-116.98354, 32.93871], [-116.98159, 32.94012], [-116.98109, 32.94034], [-116.98048, 32.93979], [-116.98033, 32.93986], [-116.98058, 32.9412], [-116.97817, 32.94117], [-116.97813, 32.943], [-116.97815, 32.94301], [-116.97847, 32.94277], [-116.97891, 32.9428], [-116.97894, 32.94363], [-116.97912, 32.94418], [-116.97809, 32.9459], [-116.97938, 32.9459], [-116.98105, 32.94585], [-116.98105, 32.94859], [-116.97935, 32.94853], [-116.97058, 32.94833], [-116.97082, 32.94447], [-116.97099, 32.94104], [-116.96183, 32.94088], [-116.96174, 32.93343], [-116.95747, 32.93346], [-116.95777, 32.92622], [-116.96202, 32.92624], [-116.96229, 32.91927], [-116.96218, 32.91552], [-116.95771, 32.9155], [-116.95773, 32.9085], [-116.96197, 32.90851], [-116.96182, 32.9035], [-116.97162, 32.90168], [-116.97155, 32.91577], [-116.9809, 32.91574], [-116.98072, 32.90852], [-116.98503, 32.90855], [-116.98502, 32.90763], [-116.98936, 32.90765], [-116.98938, 32.90859], [-116.98504, 32.90855], [-116.98507, 32.91031], [-116.98943, 32.91034], [-116.98966, 32.91956]]], [[[-116.96655, 32.94369], [-116.9663, 32.94401], [-116.96603, 32.94429], [-116.96578, 32.9445], [-116.96516, 32.94497], [-116.96477, 32.94521], [-116.96302, 32.94614], [-116.96296, 32.94615], [-116.96292, 32.94612], [-116.96269, 32.94584], [-116.96241, 32.94553], [-116.96213, 32.94526], [-116.96188, 32.94506], [-116.96187, 32.94452], [-116.96109, 32.94453], [-116.96052, 32.94424], [-116.959, 32.94362], [-116.95841, 32.94333], [-116.95808, 32.94313], [-116.95775, 32.94291], [-116.95774, 32.94223], [-116.961, 32.94226], [-116.96099, 32.94127], [-116.96649, 32.9413], [-116.96655, 32.94369]]], [[[-116.9654, 32.94517], [-116.96539, 32.94575], [-116.96341, 32.94681], [-116.96315, 32.94645], [-116.96315, 32.94639], [-116.96318, 32.94636], [-116.965, 32.94542], [-116.9654, 32.94517]]], [[[-116.98432, 32.90496], [-116.98062, 32.90494], [-116.98042, 32.90307], [-116.9843, 32.90304], [-116.98432, 32.90496]]], [[[-116.98934, 32.90675], [-116.98501, 32.90674], [-116.98498, 32.90496], [-116.98929, 32.90498], [-116.98934, 32.90675]]]]} | Open Access 1 | 1358 | Goodan Ranch Sycamore Canyon Preserve | 29238 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/GoodanSycamore.html | San Diego 4 | 2571.686 | Goodan Ranch Sycamore Canyon Preserve | 0 | Local Conservation Area 4 | 2 |
6279 | 6279 | 6278 | {"type": "MultiPolygon", "coordinates": [[[[-116.5945, 33.07228], [-116.59436, 33.07252], [-116.59429, 33.0727], [-116.59418, 33.07323], [-116.5941, 33.07322], [-116.59199, 33.07255], [-116.59212, 33.07111], [-116.59258, 33.07138], [-116.59266, 33.07128], [-116.59267, 33.07125], [-116.5945, 33.07228]]], [[[-116.59395, 33.07136], [-116.59383, 33.07151], [-116.59306, 33.07107], [-116.59317, 33.07094], [-116.59335, 33.07099], [-116.59352, 33.071], [-116.59365, 33.07102], [-116.59376, 33.07108], [-116.59385, 33.07115], [-116.5939, 33.07122], [-116.59395, 33.07136]]]]} | Open Access 1 | 1401 | Jess Martin Park | 20404 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/JessMartin.html | San Diego 4 | 8.398 | Jess Martin Park | 0 | Local Park 2 | 4 |
6287 | 6287 | 6286 | {"type": "Polygon", "coordinates": [[[-116.95334, 32.9409], [-116.94892, 32.94093], [-116.94889, 32.93688], [-116.95331, 32.93686], [-116.95334, 32.9409]]]} | Open Access 1 | 1379 | Iron Mountain | 20235 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 45.811 | Iron Mtn. | None 510 | |||
6543 | 6543 | 6542 | {"type": "MultiPolygon", "coordinates": [[[[-116.91618, 32.84986], [-116.9158, 32.84995], [-116.91515, 32.85059], [-116.91472, 32.8507], [-116.91484, 32.85107], [-116.91525, 32.85324], [-116.914, 32.85341], [-116.91334, 32.84972], [-116.91177, 32.85009], [-116.91176, 32.8484], [-116.91061, 32.84865], [-116.91064, 32.84184], [-116.91071, 32.84181], [-116.91116, 32.84154], [-116.91129, 32.84149], [-116.91356, 32.84095], [-116.91405, 32.84103], [-116.91448, 32.84114], [-116.91479, 32.84146], [-116.915, 32.84173], [-116.91513, 32.84194], [-116.91535, 32.84238], [-116.91387, 32.84275], [-116.91387, 32.8431], [-116.91389, 32.84327], [-116.91385, 32.84344], [-116.91387, 32.84357], [-116.91404, 32.84404], [-116.91344, 32.84419], [-116.91364, 32.84485], [-116.91326, 32.84494], [-116.91351, 32.84573], [-116.9139, 32.84565], [-116.91406, 32.84614], [-116.91209, 32.84661], [-116.91189, 32.84834], [-116.9119, 32.84835], [-116.91259, 32.8482], [-116.91322, 32.84866], [-116.91397, 32.84868], [-116.91489, 32.84935], [-116.91522, 32.84928], [-116.91542, 32.84981], [-116.91562, 32.84978], [-116.91611, 32.84965], [-116.91618, 32.84986]]], [[[-116.91703, 32.84504], [-116.91654, 32.84516], [-116.91648, 32.845], [-116.91697, 32.84488], [-116.91703, 32.84504]]], [[[-116.92242, 32.84101], [-116.92235, 32.84257], [-116.92092, 32.84275], [-116.92092, 32.84281], [-116.9208, 32.84282], [-116.92081, 32.84283], [-116.92096, 32.84286], [-116.91974, 32.84281], [-116.9197, 32.84288], [-116.91955, 32.84329], [-116.91951, 32.84385], [-116.91966, 32.84457], [-116.92002, 32.84461], [-116.92028, 32.84451], [-116.92094, 32.84452], [-116.92115, 32.84448], [-116.92125, 32.84507], [-116.92138, 32.84613], [-116.91821, 32.84687], [-116.91757, 32.84492], [-116.91719, 32.845], [-116.91704, 32.84458], [-116.91742, 32.84449], [-116.91717, 32.8437], [-116.91815, 32.84346], [-116.918, 32.84236], [-116.92076, 32.84171], [-116.92055, 32.84013], [-116.9205, 32.83964], [-116.92053, 32.83965], [-116.92219, 32.83949], [-116.92242, 32.84101]]]]} | Open Access 1 | 5015 | Lakeside Archipelago Open Space | 20975 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 122.828 | Lakeside Archipelago OS | 0 | Local Recreation Area 3 | 4 | |
6604 | 6604 | 6603 | {"type": "Polygon", "coordinates": [[[-116.53259, 32.82597], [-116.53029, 32.82583], [-116.52923, 32.82339], [-116.52988, 32.82262], [-116.53041, 32.82294], [-116.53063, 32.82271], [-116.5311, 32.82315], [-116.53135, 32.82342], [-116.53176, 32.82398], [-116.53193, 32.82426], [-116.53209, 32.82458], [-116.53231, 32.82509], [-116.53259, 32.82597]]]} | Open Access 1 | 4165 | Pine Valley Park | 23685 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/PineValley.html | San Diego 4 | 17.146 | Pine Valley Park | 0 | Local Park 2 | 4 |
6687 | 6687 | 6686 | {"type": "Polygon", "coordinates": [[[-116.92088, 32.85993], [-116.9178, 32.86035], [-116.91751, 32.86037], [-116.91746, 32.86039], [-116.91742, 32.86035], [-116.91622, 32.8598], [-116.91318, 32.85833], [-116.91254, 32.85841], [-116.91224, 32.85676], [-116.91305, 32.85644], [-116.91363, 32.85637], [-116.91375, 32.85656], [-116.91402, 32.85653], [-116.91407, 32.8568], [-116.91465, 32.85672], [-116.91468, 32.85685], [-116.91509, 32.85681], [-116.91526, 32.85677], [-116.91592, 32.85668], [-116.91599, 32.85711], [-116.9161, 32.85721], [-116.91627, 32.85723], [-116.91776, 32.85703], [-116.91824, 32.85695], [-116.9183, 32.8569], [-116.91832, 32.85684], [-116.91826, 32.85653], [-116.91907, 32.85643], [-116.91937, 32.85652], [-116.91959, 32.85772], [-116.92044, 32.8576], [-116.92088, 32.85993]]]} | Open Access 1 | 4881 | Lindo Lake Park | 29244 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LindoLake.html | San Diego 4 | 57.094 | Lindo Lake Park | 0 | Local Park 2 | 4 |
6692 | 6692 | 6691 | {"type": "Polygon", "coordinates": [[[-116.92544, 32.74521], [-116.92529, 32.74527], [-116.92388, 32.74556], [-116.92186, 32.74538], [-116.92193, 32.7451], [-116.92209, 32.74475], [-116.92224, 32.74452], [-116.9224, 32.74436], [-116.92264, 32.74419], [-116.9229, 32.74407], [-116.92313, 32.74401], [-116.92344, 32.74397], [-116.92381, 32.744], [-116.92395, 32.74404], [-116.92412, 32.74409], [-116.92441, 32.74424], [-116.92459, 32.74438], [-116.92544, 32.74521]]]} | Open Access 1 | 4972 | Hilton Head Park | 19997 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/HiltonHead.html | San Diego 4 | 9.882 | Hilton Head Park | 0 | Local Park 2 | 4 |
6696 | 6696 | 6695 | {"type": "Polygon", "coordinates": [[[-116.95847, 32.74943], [-116.95847, 32.75121], [-116.95732, 32.75118], [-116.95732, 32.74942], [-116.95847, 32.74943]]]} | Open Access 1 | 4976 | Lonny Brewer Park | 29245 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LonnyBrewer.html | San Diego 4 | 5.232 | Lonny Brewer Park | 0 | Local Park 2 | 4 |
6699 | 6699 | 6698 | {"type": "Polygon", "coordinates": [[[-116.91331, 32.73733], [-116.9132, 32.73762], [-116.91318, 32.73772], [-116.91317, 32.73796], [-116.91319, 32.7381], [-116.91135, 32.7385], [-116.91054, 32.73884], [-116.91055, 32.73722], [-116.91319, 32.73724], [-116.91331, 32.73733]]]} | Open Access 1 | 4984 | Steele Canyon Park | 25819 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SteeleCanyon.html | San Diego 4 | 8.122 | Steele Canyon Park | 0 | Local Park 2 | 4 |
6700 | 6700 | 6699 | {"type": "Polygon", "coordinates": [[[-116.91742, 32.75157], [-116.91715, 32.75181], [-116.9163, 32.75233], [-116.91649, 32.75258], [-116.91616, 32.75277], [-116.91612, 32.75277], [-116.91608, 32.75275], [-116.91571, 32.75227], [-116.9156, 32.75217], [-116.91491, 32.75174], [-116.9151, 32.75147], [-116.91522, 32.75105], [-116.91702, 32.75139], [-116.91725, 32.75147], [-116.91742, 32.75157]]]} | Open Access 1 | 4985 | Cottonwood County Park | 29270 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cottonwood.html | San Diego 4 | 5.47 | Cottonwood County Park | 0 | Local Park 2 | 4 |
6703 | 6703 | 6702 | {"type": "Polygon", "coordinates": [[[-116.94512, 32.75532], [-116.94511, 32.75706], [-116.94501, 32.75707], [-116.94501, 32.75859], [-116.94202, 32.75855], [-116.94197, 32.75818], [-116.94278, 32.7581], [-116.94286, 32.75813], [-116.94295, 32.75812], [-116.94301, 32.75808], [-116.94303, 32.75805], [-116.94303, 32.758], [-116.94301, 32.75794], [-116.94294, 32.75789], [-116.94297, 32.75783], [-116.94254, 32.75687], [-116.94212, 32.75672], [-116.94171, 32.75665], [-116.94122, 32.7557], [-116.94096, 32.75447], [-116.94109, 32.75444], [-116.94116, 32.75429], [-116.94127, 32.75428], [-116.94133, 32.75425], [-116.94136, 32.7542], [-116.94165, 32.75423], [-116.94281, 32.75501], [-116.94287, 32.75503], [-116.94512, 32.75532]]]} | Open Access 1 | 5000 | Damon Lane Park | 17902 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DamonLane.html | San Diego 4 | 29.5 | Damon Lane Park | 0 | Local Park 2 | 4 |
6705 | 6705 | 6704 | {"type": "Polygon", "coordinates": [[[-117.00204, 32.76133], [-117.00199, 32.76124], [-117.00192, 32.76106], [-117.00179, 32.76094], [-117.00165, 32.76087], [-117.00111, 32.76077], [-117.00098, 32.76071], [-117.00094, 32.76067], [-117.0009, 32.76055], [-117.00109, 32.76047], [-117.00102, 32.76025], [-117.00045, 32.75882], [-117.00166, 32.75882], [-117.00223, 32.76019], [-117.00229, 32.76049], [-117.00228, 32.76074], [-117.00221, 32.76103], [-117.0021, 32.76124], [-117.00204, 32.76133]]]} | Open Access 1 | 5007 | Eucalyptus Park | 18739 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Eucalyptus.html | San Diego 4 | 6.737 | Eucalyptus Park | 0 | Local Park 2 | 4 |
6707 | 6707 | 6706 | {"type": "Polygon", "coordinates": [[[-116.91296, 32.75687], [-116.91276, 32.75701], [-116.91261, 32.75719], [-116.91188, 32.75864], [-116.91182, 32.75873], [-116.9117, 32.75885], [-116.91165, 32.7589], [-116.91152, 32.75896], [-116.9113, 32.75902], [-116.91117, 32.75904], [-116.91059, 32.75906], [-116.91052, 32.75901], [-116.91047, 32.75878], [-116.91034, 32.75853], [-116.91033, 32.75848], [-116.91058, 32.75828], [-116.91181, 32.75682], [-116.91193, 32.7567], [-116.91216, 32.75651], [-116.91231, 32.75641], [-116.91258, 32.75627], [-116.91296, 32.75687]]]} | Open Access 1 | 5011 | Woodhaven Park | 27713 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Woodhaven.html | San Diego 4 | 8.241 | Woodhaven Park | 0 | Local Park 2 | 4 |
6709 | 6709 | 6708 | {"type": "MultiPolygon", "coordinates": [[[[-116.91484, 32.86884], [-116.91485, 32.87034], [-116.91482, 32.87063], [-116.91469, 32.87097], [-116.91454, 32.87121], [-116.91438, 32.87142], [-116.91412, 32.87164], [-116.91342, 32.87076], [-116.91262, 32.87037], [-116.91096, 32.87045], [-116.91023, 32.86652], [-116.91402, 32.86599], [-116.91456, 32.86881], [-116.91484, 32.86884]]], [[[-116.91825, 32.86993], [-116.91733, 32.87197], [-116.91627, 32.87239], [-116.91504, 32.87239], [-116.91426, 32.87179], [-116.91425, 32.87177], [-116.91446, 32.87159], [-116.91462, 32.87141], [-116.91477, 32.8712], [-116.91487, 32.87103], [-116.91497, 32.87078], [-116.91502, 32.87058], [-116.91505, 32.87035], [-116.91505, 32.8701], [-116.91599, 32.87019], [-116.91531, 32.87033], [-116.91536, 32.87052], [-116.91825, 32.86993]]]]} | Open Access 1 | 5036 | Cactus Park | 16651 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cactus.html | San Diego 4 | 61.039 | Cactus Park | 0 | Local Park 2 | 4 |
6710 | 6710 | 6709 | {"type": "MultiPolygon", "coordinates": [[[[-116.90763, 32.87806], [-116.90721, 32.87867], [-116.90721, 32.87871], [-116.90698, 32.879], [-116.90668, 32.87927], [-116.90649, 32.87941], [-116.90432, 32.88052], [-116.90174, 32.88203], [-116.90134, 32.8822], [-116.90115, 32.88225], [-116.89874, 32.88282], [-116.89861, 32.88285], [-116.89823, 32.88287], [-116.89801, 32.88292], [-116.89772, 32.88301], [-116.89763, 32.88306], [-116.89755, 32.88308], [-116.89746, 32.88313], [-116.89712, 32.88341], [-116.89643, 32.88418], [-116.89602, 32.8847], [-116.8937, 32.88526], [-116.89377, 32.88553], [-116.89326, 32.88568], [-116.89333, 32.87228], [-116.89461, 32.87253], [-116.89385, 32.87529], [-116.90763, 32.87806]]], [[[-116.91612, 32.8798], [-116.91533, 32.88], [-116.91443, 32.88025], [-116.91461, 32.88611], [-116.91193, 32.8861], [-116.91275, 32.88473], [-116.91275, 32.88472], [-116.90853, 32.88469], [-116.91044, 32.88128], [-116.91044, 32.88126], [-116.89608, 32.88496], [-116.89638, 32.88452], [-116.89673, 32.88412], [-116.89734, 32.88345], [-116.89756, 32.88328], [-116.89769, 32.88321], [-116.89795, 32.8831], [-116.89825, 32.88304], [-116.89878, 32.88298], [-116.90121, 32.88242], [-116.90161, 32.88228], [-116.90183, 32.88218], [-116.90438, 32.88069], [-116.90646, 32.87962], [-116.90693, 32.87931], [-116.9073, 32.87891], [-116.90782, 32.8781], [-116.90806, 32.87814], [-116.90832, 32.87735], [-116.90834, 32.87732], [-116.90847, 32.87721], [-116.90859, 32.87714], [-116.90928, 32.87684], [-116.90946, 32.87672], [-116.90948, 32.87671], [-116.90903, 32.87835], [-116.91612, 32.8798]]]]} | Open Access 1 | 5026 | Louis Stelzer County Park | 28941 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LouisStelzer.html | San Diego 4 | 367.724 | Louis Stelzer County Park | 0 | Local Park 2 | 4 |
6722 | 6722 | 6721 | {"type": "Polygon", "coordinates": [[[-116.86518, 32.80929], [-116.86498, 32.80983], [-116.8637, 32.80982], [-116.86371, 32.80929], [-116.86518, 32.80929]]]} | Open Access 1 | 5038 | Nancy Jane County Park | 22624 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/NancyJane.html | San Diego 4 | 1.898 | Nancy Jane County Park | 0 | Local Park 2 | 4 |
6725 | 6725 | 6724 | {"type": "Polygon", "coordinates": [[[-116.86746, 32.80088], [-116.86746, 32.80106], [-116.86742, 32.80116], [-116.86697, 32.8015], [-116.86692, 32.80156], [-116.86688, 32.80166], [-116.86692, 32.80185], [-116.86669, 32.80238], [-116.86667, 32.80345], [-116.86669, 32.80397], [-116.86572, 32.80394], [-116.86574, 32.80243], [-116.86574, 32.80071], [-116.86746, 32.80088]]]} | Open Access 1 | 5047 | South Lane Park | 25663 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SouthLane.html | San Diego 4 | 9.208 | South Lane Park | 0 | Local Park 2 | 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]);