units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
211 rows where DES_TP = 3 and MNG_AGENCY = 4 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, YR_EST
ACCESS_TYP 4
AGNCY_LEV 3 ✖
- City 209
- Special District 1
- Private 1
MNG_AG_TYP 1
- City Agency 211
MNG_AGENCY 1
- San Diego, City of · 211 ✖
DES_TP 1
- Local Recreation Area · 211 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1171 | 1171 | 1170 | {"type": "MultiPolygon", "coordinates": [[[[-117.12486, 32.71786], [-117.12437, 32.71786], [-117.12432, 32.71769], [-117.12428, 32.71748], [-117.12485, 32.71748], [-117.12486, 32.71786]]], [[[-117.12527, 32.7201], [-117.12493, 32.7201], [-117.12493, 32.71957], [-117.12459, 32.71956], [-117.12459, 32.71928], [-117.1244, 32.71927], [-117.1244, 32.71914], [-117.12521, 32.71913], [-117.12522, 32.71925], [-117.12525, 32.71926], [-117.12526, 32.71942], [-117.12527, 32.7201]]], [[[-117.1252, 32.71847], [-117.12449, 32.71847], [-117.12441, 32.71809], [-117.1252, 32.71808], [-117.1252, 32.71847]]], [[[-117.12521, 32.7189], [-117.12456, 32.71891], [-117.12452, 32.71853], [-117.12521, 32.71852], [-117.12521, 32.7189]]], [[[-117.12529, 32.72089], [-117.12494, 32.72089], [-117.12494, 32.72033], [-117.12528, 32.72032], [-117.12529, 32.72089]]], [[[-117.12597, 32.72046], [-117.12554, 32.72046], [-117.12554, 32.72028], [-117.12596, 32.72028], [-117.12597, 32.72046]]], [[[-117.12598, 32.72117], [-117.12554, 32.72117], [-117.12554, 32.72059], [-117.12597, 32.72059], [-117.12598, 32.72117]]], [[[-117.12644, 32.72134], [-117.12644, 32.72193], [-117.12597, 32.72192], [-117.12597, 32.72134], [-117.12644, 32.72134]]], [[[-117.12744, 32.72243], [-117.12743, 32.72304], [-117.12707, 32.72304], [-117.12707, 32.72292], [-117.12704, 32.72291], [-117.12704, 32.72269], [-117.12665, 32.72268], [-117.12666, 32.72243], [-117.12744, 32.72243]]], [[[-117.12744, 32.72221], [-117.12669, 32.72221], [-117.1267, 32.72179], [-117.12703, 32.7218], [-117.12704, 32.72207], [-117.12736, 32.72215], [-117.12743, 32.72215], [-117.12744, 32.72221]]], [[[-117.1283, 32.72411], [-117.12828, 32.72434], [-117.12792, 32.72434], [-117.12792, 32.72404], [-117.12829, 32.72404], [-117.1283, 32.72411]]], [[[-117.12829, 32.7239], [-117.12792, 32.72391], [-117.12792, 32.72377], [-117.12829, 32.72378], [-117.12829, 32.7239]]]]} | Open Access 1 | 7499 | 32nd Street Canyon | 15193 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.011 | 32nd Street Canyon | 0 | Local Recreation Area 3 | 4 | |
16145 | 16145 | 16144 | {"type": "Polygon", "coordinates": [[[-117.12447, 32.72612], [-117.12413, 32.72613], [-117.12412, 32.72547], [-117.12445, 32.72546], [-117.12447, 32.72612]]]} | Open Access 1 | 19921 | 34th St Canyon Open Space | 15194 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.576 | 34th St Canyon OS | 0 | Local Recreation Area 3 | 4 | |
10 | 10 | 9 | {"type": "MultiPolygon", "coordinates": [[[[-117.09436, 32.74201], [-117.09395, 32.74201], [-117.09393, 32.74146], [-117.09346, 32.74146], [-117.09345, 32.74102], [-117.09291, 32.74017], [-117.09284, 32.74016], [-117.09282, 32.73919], [-117.09236, 32.73919], [-117.09235, 32.7385], [-117.0928, 32.73849], [-117.09279, 32.73755], [-117.09339, 32.73754], [-117.09339, 32.73696], [-117.09359, 32.73697], [-117.0936, 32.73699], [-117.0938, 32.73699], [-117.09383, 32.7391], [-117.09321, 32.73912], [-117.09324, 32.74037], [-117.09385, 32.74037], [-117.09387, 32.74118], [-117.09435, 32.74118], [-117.09436, 32.74201]]], [[[-117.09277, 32.74057], [-117.0927, 32.74058], [-117.09269, 32.74084], [-117.09238, 32.74085], [-117.09238, 32.74039], [-117.09276, 32.74038], [-117.09277, 32.74057]]], [[[-117.09497, 32.74242], [-117.09456, 32.74242], [-117.09456, 32.74223], [-117.09497, 32.74222], [-117.09497, 32.74242]]], [[[-117.09603, 32.7429], [-117.09564, 32.74291], [-117.09564, 32.7427], [-117.09603, 32.7427], [-117.09603, 32.7429]]]]} | Open Access 1 | 31 | 47th Street Canyon | 15202 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.994 | 47th Street Canyon | 0 | Local Recreation Area 3 | 4 | |
6148 | 6148 | 6147 | {"type": "Polygon", "coordinates": [[[-117.0747, 32.78221], [-117.07462, 32.78225], [-117.07456, 32.78235], [-117.07453, 32.78236], [-117.07449, 32.78207], [-117.07319, 32.78207], [-117.07249, 32.782], [-117.07221, 32.78175], [-117.07188, 32.78121], [-117.07462, 32.78164], [-117.0747, 32.78221]]]} | Open Access 1 | 18932 | Adobe Falls Open Space Park | 15271 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.003 | Adobe Falls OS Park | 0 | Local Recreation Area 3 | 4 | |
2787 | 2787 | 2786 | {"type": "MultiPolygon", "coordinates": [[[[-117.1655, 32.74559], [-117.1651, 32.7456], [-117.16509, 32.74433], [-117.1655, 32.74432], [-117.1655, 32.74559]]], [[[-117.16661, 32.74404], [-117.1661, 32.74404], [-117.16611, 32.74459], [-117.16556, 32.7446], [-117.16555, 32.74405], [-117.16556, 32.74392], [-117.16661, 32.7439], [-117.16661, 32.74404]]], [[[-117.16849, 32.74062], [-117.16808, 32.74063], [-117.16809, 32.74086], [-117.16797, 32.74096], [-117.16759, 32.74142], [-117.16751, 32.74153], [-117.16669, 32.74154], [-117.16668, 32.74105], [-117.16763, 32.74103], [-117.16764, 32.74064], [-117.16763, 32.74022], [-117.16809, 32.74021], [-117.16809, 32.73983], [-117.16848, 32.73982], [-117.16849, 32.74062]]], [[[-117.16935, 32.73926], [-117.16914, 32.73957], [-117.16907, 32.7397], [-117.169, 32.73971], [-117.16899, 32.73918], [-117.16934, 32.73918], [-117.16935, 32.73926]]]]} | Open Access 1 | 18557 | Albatross Canyon Open Space | 15332 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.812 | Albatross Canyon OS | 0 | Local Recreation Area 3 | 4 | |
3556 | 3556 | 3555 | {"type": "Polygon", "coordinates": [[[-117.23771, 32.92887], [-117.23764, 32.92911], [-117.23752, 32.9294], [-117.23732, 32.92977], [-117.23735, 32.9298], [-117.23727, 32.92994], [-117.23672, 32.93067], [-117.23651, 32.93102], [-117.23436, 32.93101], [-117.23431, 32.92669], [-117.23586, 32.92657], [-117.23762, 32.92885], [-117.23771, 32.92887]]]} | Open Access 1 | 12154 | Arroyo Sorrento Open Space | 15633 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 29.661 | Arroyo Sorrento OS | 0 | Local Recreation Area 3 | 4 | |
12465 | 12465 | 12464 | {"type": "Polygon", "coordinates": [[[-117.10941, 32.7369], [-117.1094, 32.73752], [-117.10894, 32.73752], [-117.10895, 32.7369], [-117.10941, 32.7369]]]} | Open Access 1 | 28116 | Azalea Park and Lexington Canyon Open Space | 15738 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.728 | Azalea Park and Lexington Canyon OS | 0 | Local Recreation Area 3 | 4 | |
5822 | 5822 | 5821 | {"type": "Polygon", "coordinates": [[[-117.16627, 32.73925], [-117.16594, 32.73926], [-117.16593, 32.7388], [-117.16627, 32.7388], [-117.16627, 32.73925]]]} | Open Access 1 | 178 | Banker's Hill Canyon Open Space | 15796 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.393 | Banker's Hill Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15899 | 15899 | 15898 | {"type": "Polygon", "coordinates": [[[-117.16654, 32.73769], [-117.16637, 32.73802], [-117.16607, 32.73803], [-117.16607, 32.73863], [-117.16568, 32.73863], [-117.16567, 32.73843], [-117.16534, 32.73844], [-117.16534, 32.7383], [-117.1654, 32.73829], [-117.16539, 32.73764], [-117.16566, 32.73764], [-117.16567, 32.73753], [-117.16593, 32.73753], [-117.16594, 32.73769], [-117.16625, 32.73769], [-117.16624, 32.73773], [-117.16625, 32.73774], [-117.16636, 32.73774], [-117.16638, 32.73769], [-117.16654, 32.73769]]]} | Open Access 1 | 179 | Banker's Hill Canyon Open Space | 15796 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.967 | Banker's Hill Canyon OS | 0 | Local Recreation Area 3 | 4 | |
6254 | 6254 | 6253 | {"type": "MultiPolygon", "coordinates": [[[[-116.72083, 32.70426], [-116.71907, 32.7045], [-116.71873, 32.70456], [-116.7182, 32.70471], [-116.71793, 32.70482], [-116.71767, 32.70496], [-116.71735, 32.70515], [-116.71708, 32.70537], [-116.71398, 32.70808], [-116.71371, 32.70826], [-116.71349, 32.70839], [-116.71319, 32.70853], [-116.71283, 32.70866], [-116.70883, 32.70798], [-116.70426, 32.70803], [-116.70439, 32.71165], [-116.70677, 32.71163], [-116.70672, 32.71196], [-116.70667, 32.7121], [-116.70658, 32.71228], [-116.70649, 32.71241], [-116.70538, 32.71375], [-116.70517, 32.71411], [-116.70506, 32.71444], [-116.70502, 32.71464], [-116.705, 32.71489], [-116.70499, 32.71695], [-116.70495, 32.71993], [-116.7049, 32.72027], [-116.70478, 32.72064], [-116.70461, 32.72097], [-116.70444, 32.72123], [-116.70424, 32.72147], [-116.70405, 32.72166], [-116.69956, 32.72557], [-116.69966, 32.7224], [-116.69545, 32.72241], [-116.6953, 32.72599], [-116.6909, 32.726], [-116.69148, 32.71532], [-116.69577, 32.71527], [-116.69593, 32.71173], [-116.7001, 32.71169], [-116.69997, 32.7081], [-116.70112, 32.70807], [-116.70099, 32.7045], [-116.69554, 32.70453], [-116.69514, 32.69711], [-116.6819, 32.69715], [-116.68214, 32.70068], [-116.67793, 32.70075], [-116.67876, 32.71169], [-116.6786, 32.71546], [-116.68281, 32.71546], [-116.68266, 32.71901], [-116.68694, 32.71903], [-116.68659, 32.7261], [-116.67808, 32.72613], [-116.67826, 32.7226], [-116.66961, 32.72265], [-116.66984, 32.71904], [-116.67418, 32.71895], [-116.67435, 32.71542], [-116.6661, 32.71554], [-116.66639, 32.71171], [-116.66252, 32.71174], [-116.66225, 32.70812], [-116.66611, 32.70808], [-116.66584, 32.7045], [-116.66983, 32.70446], [-116.66933, 32.69723], [-116.66139, 32.69733], [-116.66126, 32.69371], [-116.65721, 32.69375], [-116.65703, 32.69021], [-116.65041, 32.68985], [-116.64504, 32.6896], [-116.64512, 32.68579], [-116.64145, 32.68553], [-116.62402, 32.686], [-116.62403, 32.68245], [-116.61982, 32.68242], [-116.61983, 32.67894], [-116.62406, 32.67895], [-116.62828, 32.67883], [-116.62843, 32.68226], [-116.64162, 32.6817], [-116.65303, 32.68272], [-116.65312, 32.68635], [-116.65685, 32.68666], [-116.66102, 32.68661], [-116.66116, 32.69017], [-116.66941, 32.69001], [-116.66943, 32.68647], [-116.66522, 32.68654], [-116.66518, 32.67936], [-116.66938, 32.67923], [-116.66936, 32.66864], [-116.67387, 32.66853], [-116.67418, 32.66477], [-116.67836, 32.6647], [-116.67912, 32.65372], [-116.68316, 32.65371], [-116.68281, 32.65012], [-116.69142, 32.65005], [-116.69107, 32.6537], [-116.68713, 32.65371], [-116.68691, 32.66092], [-116.68275, 32.66096], [-116.68232, 32.66832], [-116.67809, 32.66843], [-116.67805, 32.67191], [-116.67386, 32.67198], [-116.67382, 32.68271], [-116.68213, 32.68268], [-116.68206, 32.68638], [-116.68642, 32.68631], [-116.68641, 32.68978], [-116.69093, 32.68974], [-116.69093, 32.69145], [-116.69097, 32.69352], [-116.7085, 32.69348], [-116.70862, 32.69707], [-116.71266, 32.69772], [-116.71271, 32.7015], [-116.7208, 32.70275], [-116.72083, 32.70426]]], [[[-116.70877, 32.71161], [-116.70809, 32.72584], [-116.69953, 32.72595], [-116.69953, 32.72583], [-116.70419, 32.72176], [-116.70447, 32.72148], [-116.7047, 32.72118], [-116.70487, 32.72089], [-116.70501, 32.72058], [-116.70509, 32.7203], [-116.70515, 32.71995], [-116.70519, 32.71695], [-116.7052, 32.71484], [-116.70523, 32.71452], [-116.70534, 32.71421], [-116.70544, 32.714], [-116.70558, 32.71379], [-116.70662, 32.71254], [-116.70673, 32.71239], [-116.70683, 32.71221], [-116.7069, 32.71203], [-116.70695, 32.71184], [-116.70697, 32.71163], [-116.70877, 32.71161]]], [[[-116.71691, 32.70935], [-116.71691, 32.70935], [-116.71317, 32.70872], [-116.71348, 32.70858], [-116.71373, 32.70845], [-116.71395, 32.70831], [-116.71419, 32.70814], [-116.71683, 32.70582], [-116.71691, 32.70935]]], [[[-116.72086, 32.70635], [-116.72086, 32.70635], [-116.71693, 32.70573], [-116.71727, 32.70544], [-116.71758, 32.70521], [-116.71797, 32.705], [-116.71838, 32.70483], [-116.7187, 32.70474], [-116.719, 32.70467], [-116.72083, 32.70443], [-116.72086, 32.70635]]]]} | Restricted Access 2 | 1327 | Barrett Reservoir | 15833 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | https://www.sandiego.gov/water/recreation/reservoirs/barrett | San Diego 4 | 4177.221 | Barrett Reservoir | 0 | Local Recreation Area 3 | 4 |
16916 | 16916 | 16915 | {"type": "Polygon", "coordinates": [[[-117.07375, 33.04138], [-117.07327, 33.04204], [-117.07279, 33.04304], [-117.07254, 33.04375], [-117.07233, 33.04397], [-117.07197, 33.04569], [-117.0719, 33.04629], [-117.07097, 33.04653], [-117.07021, 33.04703], [-117.07022, 33.04733], [-117.0696, 33.04878], [-117.06934, 33.04893], [-117.06907, 33.04926], [-117.06888, 33.04942], [-117.06857, 33.04958], [-117.0682, 33.04964], [-117.06812, 33.04969], [-117.06803, 33.04981], [-117.06798, 33.04989], [-117.06731, 33.04954], [-117.06686, 33.04948], [-117.0666, 33.04907], [-117.06628, 33.04894], [-117.06615, 33.04855], [-117.06554, 33.04816], [-117.06544, 33.04817], [-117.06545, 33.04761], [-117.0655, 33.04707], [-117.06625, 33.0471], [-117.06628, 33.04681], [-117.06635, 33.04667], [-117.06636, 33.04662], [-117.06614, 33.04657], [-117.06616, 33.04646], [-117.06614, 33.04639], [-117.06618, 33.04638], [-117.06622, 33.04642], [-117.0662, 33.04654], [-117.06637, 33.04658], [-117.06659, 33.04639], [-117.06676, 33.04613], [-117.06708, 33.04615], [-117.06773, 33.04561], [-117.06828, 33.0456], [-117.06829, 33.04507], [-117.06857, 33.04425], [-117.06857, 33.0441], [-117.06848, 33.04388], [-117.06897, 33.0437], [-117.06881, 33.04342], [-117.06994, 33.04343], [-117.07008, 33.04291], [-117.07035, 33.04293], [-117.07111, 33.04291], [-117.07143, 33.04285], [-117.0716, 33.0428], [-117.07171, 33.04274], [-117.07174, 33.04274], [-117.07193, 33.04261], [-117.07211, 33.04246], [-117.07244, 33.04206], [-117.07263, 33.04187], [-117.07286, 33.0417], [-117.07344, 33.04134], [-117.07375, 33.04138]]]} | Open Access 1 | 18641 | Battle Mountain Open Space | 15868 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 69.373 | Battle Mtn. OS | 0 | Local Recreation Area 3 | 4 | |
15985 | 15985 | 15984 | {"type": "Polygon", "coordinates": [[[-117.20805, 32.81695], [-117.2059, 32.81691], [-117.2059, 32.81641], [-117.20651, 32.81639], [-117.20649, 32.81554], [-117.20588, 32.81554], [-117.20584, 32.81431], [-117.20583, 32.8143], [-117.20572, 32.81436], [-117.2056, 32.8143], [-117.2056, 32.81426], [-117.20663, 32.81393], [-117.20692, 32.81329], [-117.20795, 32.81331], [-117.20805, 32.81695]]]} | Open Access 1 | 909 | Bay Ridge Open Space | 15878 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 16.843 | Bay Ridge OS | 0 | Local Recreation Area 3 | 4 | |
5483 | 5483 | 5482 | {"type": "Polygon", "coordinates": [[[-117.23122, 32.80877], [-117.23018, 32.809], [-117.22977, 32.80866], [-117.22963, 32.80822], [-117.22948, 32.80825], [-117.22945, 32.80818], [-117.22964, 32.80821], [-117.22969, 32.80828], [-117.2298, 32.80834], [-117.22981, 32.80838], [-117.22994, 32.80835], [-117.22975, 32.80773], [-117.23019, 32.80821], [-117.23122, 32.80877]]]} | Open Access 1 | 18431 | Bayview Open Space Park | 15901 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.901 | Bayview OS Park | 0 | Local Recreation Area 3 | 4 | |
2826 | 2826 | 2825 | {"type": "Polygon", "coordinates": [[[-117.12944, 32.98294], [-117.12938, 32.98304], [-117.12928, 32.9829], [-117.12938, 32.98285], [-117.12944, 32.98294]]]} | Open Access 1 | 931 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.04 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
5111 | 5111 | 5110 | {"type": "Polygon", "coordinates": [[[-117.13475, 32.98284], [-117.13455, 32.9831], [-117.13431, 32.98334], [-117.13389, 32.98368], [-117.13372, 32.9838], [-117.13285, 32.98432], [-117.13254, 32.98445], [-117.13185, 32.98485], [-117.1318, 32.98483], [-117.13164, 32.9846], [-117.13136, 32.9841], [-117.13123, 32.98374], [-117.13116, 32.9835], [-117.1311, 32.983], [-117.1311, 32.98285], [-117.13161, 32.98284], [-117.13206, 32.98268], [-117.13301, 32.98271], [-117.13342, 32.98307], [-117.13432, 32.98273], [-117.13475, 32.98284]]]} | Open Access 1 | 1782 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 11.546 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
7846 | 7846 | 7845 | {"type": "Polygon", "coordinates": [[[-117.15919, 33.00094], [-117.15671, 33.00189], [-117.15677, 33.00261], [-117.15655, 33.00257], [-117.15662, 33.0025], [-117.15669, 33.00233], [-117.15669, 33.00219], [-117.15663, 33.00202], [-117.15653, 33.00191], [-117.1564, 33.00183], [-117.15595, 33.00167], [-117.15606, 33.00153], [-117.15628, 33.00141], [-117.15596, 33.00098], [-117.15599, 33.00093], [-117.15656, 33.00087], [-117.1567, 33.00079], [-117.15677, 33.00073], [-117.15683, 33.00065], [-117.15687, 33.00053], [-117.15687, 33.00043], [-117.15684, 33.00033], [-117.15676, 33.0002], [-117.15689, 33.00002], [-117.15693, 32.99987], [-117.15698, 32.99954], [-117.15702, 32.99947], [-117.15723, 32.9993], [-117.15729, 32.99918], [-117.15732, 32.99909], [-117.15809, 32.99871], [-117.15825, 32.99891], [-117.15839, 32.99912], [-117.1585, 32.99935], [-117.15919, 33.00094]]]} | Open Access 1 | 9590 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 14.063 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
7847 | 7847 | 7846 | {"type": "Polygon", "coordinates": [[[-117.15681, 33.0032], [-117.15678, 33.00321], [-117.15678, 33.00317], [-117.15673, 33.00305], [-117.15662, 33.00291], [-117.15655, 33.00286], [-117.1565, 33.00276], [-117.15678, 33.00276], [-117.15681, 33.0032]]]} | Open Access 1 | 9594 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 0.148 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
15964 | 15964 | 15963 | {"type": "Polygon", "coordinates": [[[-117.16989, 33.00728], [-117.15244, 33.00731], [-117.14909, 33.00658], [-117.14815, 33.00609], [-117.14731, 33.00619], [-117.14688, 33.00588], [-117.14583, 33.00575], [-117.14602, 33.00548], [-117.14626, 33.00523], [-117.14731, 33.00524], [-117.14868, 33.0039], [-117.14868, 33.00388], [-117.14782, 33.00326], [-117.14832, 33.00277], [-117.14862, 33.00252], [-117.14878, 33.0024], [-117.14931, 33.00291], [-117.14933, 33.0029], [-117.14966, 33.00268], [-117.15025, 33.00235], [-117.15007, 33.00211], [-117.15073, 33.00174], [-117.15047, 33.0014], [-117.15237, 33.00031], [-117.15243, 33.00039], [-117.15241, 33.0004], [-117.15237, 33.0005], [-117.15238, 33.0007], [-117.15244, 33.00081], [-117.1525, 33.00088], [-117.15263, 33.00097], [-117.15276, 33.00102], [-117.15295, 33.00103], [-117.15312, 33.001], [-117.15328, 33.00091], [-117.15341, 33.0009], [-117.15349, 33.00093], [-117.15355, 33.00098], [-117.15361, 33.00106], [-117.15374, 33.00115], [-117.15386, 33.0012], [-117.15396, 33.00121], [-117.15573, 33.00356], [-117.15583, 33.00365], [-117.15592, 33.00369], [-117.15604, 33.00374], [-117.15616, 33.00376], [-117.15638, 33.00374], [-117.15654, 33.00367], [-117.15671, 33.00353], [-117.1568, 33.00338], [-117.15682, 33.00322], [-117.15678, 33.00276], [-117.15686, 33.00276], [-117.15686, 33.00263], [-117.15677, 33.00261], [-117.1567, 33.0019], [-117.15919, 33.00095], [-117.15931, 33.00122], [-117.15945, 33.00148], [-117.15977, 33.00196], [-117.15996, 33.0022], [-117.16036, 33.00264], [-117.16066, 33.00291], [-117.16107, 33.00323], [-117.16151, 33.0035], [-117.16189, 33.00371], [-117.16246, 33.00397], [-117.16287, 33.00412], [-117.1638, 33.00437], [-117.16444, 33.0045], [-117.16478, 33.00456], [-117.1656, 33.00464], [-117.16627, 33.00467], [-117.16677, 33.00466], [-117.1677, 33.00668], [-117.16887, 33.00666], [-117.16887, 33.00522], [-117.16987, 33.00522], [-117.16989, 33.00728]]]} | Open Access 1 | 1409 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 232.316 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
16499 | 16499 | 16498 | {"type": "Polygon", "coordinates": [[[-117.15573, 33.0035], [-117.15571, 33.00352], [-117.15396, 33.00121], [-117.15399, 33.00121], [-117.15415, 33.00136], [-117.15432, 33.00145], [-117.15437, 33.00156], [-117.15454, 33.00172], [-117.15473, 33.00179], [-117.15493, 33.00179], [-117.15499, 33.00204], [-117.15541, 33.00231], [-117.15556, 33.0023], [-117.15559, 33.00242], [-117.15563, 33.00249], [-117.15569, 33.00257], [-117.15578, 33.00264], [-117.15585, 33.00275], [-117.15585, 33.00283], [-117.15582, 33.00288], [-117.1557, 33.00304], [-117.15564, 33.00322], [-117.15565, 33.00335], [-117.15573, 33.0035]]]} | Open Access 1 | 9591 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 2.276 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 4 |
16548 | 16548 | 16547 | {"type": "Polygon", "coordinates": [[[-117.12055, 32.97305], [-117.12037, 32.97316], [-117.12021, 32.97323], [-117.12005, 32.97329], [-117.11987, 32.97332], [-117.11874, 32.97273], [-117.11761, 32.97271], [-117.11846, 32.97196], [-117.1185, 32.97196], [-117.11855, 32.97197], [-117.12055, 32.97305]]]} | Open Access 1 | 18665 | Black Mountain Open Space Park | 10257 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/parks/osp/blackmtn/index.shtml | San Diego 4 | 3.827 | Black Mtn. OS Park | 0 | Local Recreation Area 3 | 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]);