units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
123 rows where MNG_AGENCY = 101 and MNG_AG_TYP = 3 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 60
- Local Conservation Area 30
- Local Recreation Area 6
- Local Other or Unknown 4
- None 1
- None 1
- None 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 103 ✖
MNG_AGENCY 1
- San Diego, County of · 103 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
6739 | 6739 | 6738 | {"type": "Polygon", "coordinates": [[[-116.1145, 32.65367], [-116.10581, 32.65366], [-116.10581, 32.64737], [-116.10624, 32.6465], [-116.11446, 32.64653], [-116.1145, 32.65367]]]} | Open Access 1 | 5151 | County Open Space | 29240 | 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 | 158.984 | County OS | 0 | Local Recreation Area 3 | 4 | |
6830 | 6830 | 6829 | {"type": "Polygon", "coordinates": [[[-117.18338, 33.25274], [-117.18272, 33.25297], [-117.18189, 33.25323], [-117.18125, 33.25339], [-117.18097, 33.25343], [-117.18104, 33.24925], [-117.18302, 33.24925], [-117.18305, 33.2493], [-117.18316, 33.24949], [-117.18322, 33.24967], [-117.1836, 33.25208], [-117.18366, 33.2523], [-117.18378, 33.25255], [-117.18377, 33.25259], [-117.18374, 33.25261], [-117.18338, 33.25274]]]} | Open Access 1 | 5437 | Gopher Canyon Reserve | 19407 | 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 | 23.859 | Gopher Canyon Reserve | 0 | Local Conservation Area 4 | 2 | |
7361 | 7361 | 7360 | {"type": "Polygon", "coordinates": [[[-116.80495, 32.6658], [-116.7972, 32.66593], [-116.79691, 32.66573], [-116.79678, 32.66565], [-116.79554, 32.66464], [-116.7957, 32.65742], [-116.78827, 32.65749], [-116.78821, 32.65701], [-116.77957, 32.65689], [-116.77935, 32.64654], [-116.78382, 32.64644], [-116.78381, 32.64588], [-116.78409, 32.64598], [-116.78439, 32.64605], [-116.78463, 32.64607], [-116.78512, 32.64609], [-116.7853, 32.64611], [-116.78551, 32.64618], [-116.78574, 32.64629], [-116.78584, 32.64636], [-116.78591, 32.64644], [-116.78597, 32.64653], [-116.786, 32.64664], [-116.78603, 32.64794], [-116.78609, 32.64813], [-116.78635, 32.64851], [-116.78641, 32.64863], [-116.78641, 32.64876], [-116.78636, 32.64911], [-116.78634, 32.64918], [-116.78636, 32.64927], [-116.78685, 32.65008], [-116.78694, 32.65019], [-116.78706, 32.65029], [-116.78722, 32.65038], [-116.7874, 32.65043], [-116.78819, 32.65052], [-116.78833, 32.65059], [-116.78845, 32.65071], [-116.7885, 32.65082], [-116.78869, 32.65163], [-116.7887, 32.65178], [-116.78869, 32.65209], [-116.78872, 32.65231], [-116.78884, 32.65264], [-116.78898, 32.65285], [-116.78902, 32.65304], [-116.78907, 32.65314], [-116.78921, 32.65323], [-116.78954, 32.65329], [-116.78969, 32.65328], [-116.78976, 32.65325], [-116.78984, 32.6532], [-116.79019, 32.65284], [-116.79056, 32.65268], [-116.7907, 32.65263], [-116.79084, 32.65261], [-116.791, 32.65262], [-116.79115, 32.65265], [-116.79157, 32.6528], [-116.79173, 32.6529], [-116.79181, 32.65303], [-116.79189, 32.65332], [-116.79204, 32.65374], [-116.79201, 32.65377], [-116.79204, 32.65382], [-116.79217, 32.65396], [-116.79232, 32.65409], [-116.79251, 32.6542], [-116.7927, 32.65427], [-116.79413, 32.65454], [-116.79453, 32.65443], [-116.79454, 32.65439], [-116.79458, 32.65438], [-116.79479, 32.65439], [-116.79609, 32.65457], [-116.79742, 32.65446], [-116.79772, 32.65438], [-116.798, 32.65424], [-116.79813, 32.65414], [-116.7988, 32.65358], [-116.79906, 32.65342], [-116.79963, 32.65313], [-116.79982, 32.65306], [-116.80012, 32.65298], [-116.80041, 32.65296], [-116.80065, 32.65297], [-116.8009, 32.65301], [-116.80291, 32.6536], [-116.80322, 32.65367], [-116.80397, 32.6538], [-116.80484, 32.65407], [-116.80495, 32.6658]]]} | No Public Access 3 | 47588 | Lawrence and Barbara Daley Preserve | 31315 | 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 | 580.873 | Lawrence and Barbara Daley Preserve | 0 | Local Conservation Area 4 | 2 | |
7405 | 7405 | 7404 | {"type": "MultiPolygon", "coordinates": [[[[-117.23498, 33.26852], [-117.23496, 33.27233], [-117.23359, 33.27235], [-117.23078, 33.27536], [-117.2318, 33.27604], [-117.23496, 33.27267], [-117.23495, 33.27324], [-117.23464, 33.27384], [-117.23427, 33.27442], [-117.23398, 33.27479], [-117.2335, 33.27532], [-117.23297, 33.2758], [-117.23238, 33.27624], [-117.23175, 33.27664], [-117.23131, 33.27687], [-117.2296, 33.27764], [-117.22894, 33.27798], [-117.22851, 33.27823], [-117.22812, 33.2785], [-117.22775, 33.27877], [-117.2274, 33.27907], [-117.22706, 33.27938], [-117.2263, 33.28031], [-117.22556, 33.28144], [-117.22523, 33.28242], [-117.22503, 33.28174], [-117.22578, 33.27963], [-117.22622, 33.27921], [-117.22623, 33.2761], [-117.22649, 33.2759], [-117.22668, 33.27572], [-117.22705, 33.27529], [-117.22744, 33.27491], [-117.22765, 33.27474], [-117.22792, 33.27457], [-117.22842, 33.27429], [-117.22867, 33.27417], [-117.22899, 33.27408], [-117.22942, 33.27402], [-117.22972, 33.27394], [-117.22985, 33.2739], [-117.23058, 33.27357], [-117.23079, 33.27345], [-117.23183, 33.27282], [-117.23212, 33.27261], [-117.23234, 33.27239], [-117.23282, 33.27179], [-117.23295, 33.27157], [-117.23302, 33.27139], [-117.23305, 33.27113], [-117.23304, 33.27089], [-117.23312, 33.27088], [-117.23313, 33.26857], [-117.23498, 33.26852]]], [[[-117.22101, 33.29299], [-117.22101, 33.29463], [-117.22047, 33.29505], [-117.2195, 33.29631], [-117.21933, 33.29663], [-117.21973, 33.29664], [-117.21935, 33.29772], [-117.21915, 33.29819], [-117.21898, 33.29849], [-117.21878, 33.29877], [-117.21791, 33.29973], [-117.21752, 33.30024], [-117.21752, 33.30028], [-117.21746, 33.30029], [-117.2171, 33.30092], [-117.21714, 33.30094], [-117.21679, 33.30156], [-117.2167, 33.30187], [-117.21659, 33.3021], [-117.21638, 33.30236], [-117.21613, 33.30257], [-117.21582, 33.30273], [-117.21461, 33.3032], [-117.21433, 33.30334], [-117.21402, 33.30354], [-117.21369, 33.3032], [-117.21166, 33.30492], [-117.20899, 33.30653], [-117.20816, 33.30681], [-117.20803, 33.30738], [-117.20798, 33.3074], [-117.208, 33.30742], [-117.20575, 33.30789], [-117.1988, 33.30926], [-117.19536, 33.30995], [-117.19489, 33.31006], [-117.19476, 33.3096], [-117.19539, 33.30858], [-117.19637, 33.308], [-117.19704, 33.30771], [-117.19751, 33.30765], [-117.19807, 33.30773], [-117.19838, 33.30772], [-117.19871, 33.30758], [-117.19925, 33.30719], [-117.1994, 33.30701], [-117.19949, 33.30671], [-117.2, 33.30637], [-117.2002, 33.30614], [-117.20024, 33.30599], [-117.20274, 33.30505], [-117.20322, 33.30471], [-117.20374, 33.30425], [-117.20445, 33.3039], [-117.20626, 33.30282], [-117.20718, 33.30208], [-117.20829, 33.30028], [-117.21061, 33.29909], [-117.21174, 33.29842], [-117.21174, 33.2984], [-117.21162, 33.29828], [-117.2121, 33.29803], [-117.21283, 33.2976], [-117.21304, 33.29744], [-117.21387, 33.29677], [-117.21415, 33.29663], [-117.21459, 33.29651], [-117.21472, 33.29646], [-117.21484, 33.29639], [-117.21517, 33.29616], [-117.21526, 33.29608], [-117.21533, 33.29599], [-117.2154, 33.29588], [-117.21543, 33.29577], [-117.21555, 33.29434], [-117.21563, 33.29409], [-117.21572, 33.29395], [-117.21588, 33.2938], [-117.21658, 33.29325], [-117.2167, 33.29311], [-117.21677, 33.29298], [-117.22101, 33.29299]]], [[[-117.17733, 33.31358], [-117.17383, 33.31428], [-117.16985, 33.3143], [-117.16983, 33.31791], [-117.16585, 33.31793], [-117.16581, 33.31518], [-117.16597, 33.31501], [-117.1661, 33.31492], [-117.16631, 33.31513], [-117.16754, 33.31432], [-117.16932, 33.31297], [-117.17072, 33.31254], [-117.17158, 33.31259], [-117.17432, 33.31214], [-117.17474, 33.31238], [-117.17529, 33.3124], [-117.17733, 33.31358]]]]} | No Public Access 3 | 47590 | San Luis Rey River Park | 31317 | 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 | 473.331 | San Luis Rey River Park | 0 | Local Park 2 | 4 | |
7407 | 7407 | 7406 | {"type": "MultiPolygon", "coordinates": [[[[-116.92757, 33.0656], [-116.92344, 33.06562], [-116.92331, 33.06922], [-116.92324, 33.0692], [-116.91503, 33.0691], [-116.91516, 33.06562], [-116.91502, 33.06561], [-116.91536, 33.05416], [-116.91053, 33.05147], [-116.91053, 33.04782], [-116.90649, 33.04778], [-116.90482, 33.04779], [-116.90481, 33.04762], [-116.90634, 33.04761], [-116.9063, 33.04319], [-116.91054, 33.0432], [-116.91057, 33.04412], [-116.92332, 33.04382], [-116.9233, 33.04181], [-116.92753, 33.04244], [-116.92754, 33.04372], [-116.92749, 33.04509], [-116.92746, 33.04986], [-116.92755, 33.05108], [-116.92763, 33.05833], [-116.92756, 33.06196], [-116.92757, 33.0656]]], [[[-116.93601, 33.03652], [-116.93073, 33.03647], [-116.92754, 33.03643], [-116.92752, 33.03644], [-116.92731, 33.03645], [-116.92737, 33.03962], [-116.91043, 33.03711], [-116.9102, 33.0296], [-116.91019, 33.02797], [-116.91012, 33.02594], [-116.91323, 33.02589], [-116.91342, 33.02951], [-116.91449, 33.02948], [-116.9146, 33.03312], [-116.91887, 33.033], [-116.91878, 33.02936], [-116.92752, 33.02912], [-116.92753, 33.02855], [-116.93283, 33.0301], [-116.9334, 33.03109], [-116.93182, 33.03106], [-116.93182, 33.03196], [-116.93601, 33.03206], [-116.93601, 33.03652]]], [[[-116.9673, 33.07317], [-116.96318, 33.07321], [-116.96246, 33.0732], [-116.95431, 33.07292], [-116.94985, 33.0728], [-116.95008, 33.0765], [-116.94558, 33.07649], [-116.94537, 33.07261], [-116.94514, 33.06916], [-116.93635, 33.06921], [-116.93206, 33.06931], [-116.93207, 33.06563], [-116.9449, 33.0657], [-116.94481, 33.05845], [-116.93614, 33.05838], [-116.93609, 33.0511], [-116.94461, 33.05108], [-116.9569, 33.05119], [-116.95686, 33.04913], [-116.94648, 33.04762], [-116.94656, 33.04718], [-116.94955, 33.04471], [-116.94864, 33.04308], [-116.94486, 33.04306], [-116.94209, 33.04308], [-116.94205, 33.04096], [-116.94204, 33.03821], [-116.93764, 33.03588], [-116.9362, 33.03588], [-116.93619, 33.03301], [-116.94553, 33.03316], [-116.95749, 33.03329], [-116.95744, 33.0405], [-116.95735, 33.04765], [-116.96188, 33.04771], [-116.96191, 33.05133], [-116.96208, 33.05497], [-116.96668, 33.055], [-116.96674, 33.05881], [-116.96679, 33.06251], [-116.96243, 33.06256], [-116.96237, 33.06154], [-116.95791, 33.06161], [-116.95798, 33.06557], [-116.96257, 33.06566], [-116.96715, 33.0657], [-116.9673, 33.07317]]]]} | Open Access 1 | 47592 | Ramona Grasslands Preserve | 31319 | 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 | 3490.938 | Ramona Grasslands Preserve | 0 | Local Conservation Area 4 | 2 | |
7421 | 7421 | 7420 | {"type": "MultiPolygon", "coordinates": [[[[-117.03935, 32.56205], [-117.03896, 32.56244], [-117.03867, 32.56267], [-117.0382, 32.563], [-117.03798, 32.56312], [-117.03799, 32.56315], [-117.03687, 32.56394], [-117.03653, 32.56411], [-117.03624, 32.56419], [-117.03603, 32.56422], [-117.0356, 32.56422], [-117.03527, 32.56414], [-117.03507, 32.56405], [-117.03489, 32.56394], [-117.03478, 32.56389], [-117.03462, 32.56384], [-117.03447, 32.56381], [-117.03419, 32.56381], [-117.0341, 32.56383], [-117.03301, 32.56389], [-117.03268, 32.56395], [-117.03246, 32.56402], [-117.03233, 32.56408], [-117.03243, 32.56189], [-117.03219, 32.55451], [-117.03357, 32.55452], [-117.03369, 32.55819], [-117.03658, 32.55822], [-117.03665, 32.56184], [-117.03935, 32.56184], [-117.03935, 32.56205]], [[-117.03532, 32.56185], [-117.03521, 32.56166], [-117.03511, 32.5616], [-117.03493, 32.56161], [-117.03517, 32.56209], [-117.03524, 32.56207], [-117.0353, 32.56197], [-117.03527, 32.56192], [-117.03532, 32.56185]]], [[[-117.03934, 32.56405], [-117.03934, 32.56405], [-117.03714, 32.56405], [-117.0382, 32.56327], [-117.03934, 32.56308], [-117.03934, 32.56405]]], [[[-117.03935, 32.56227], [-117.03935, 32.56266], [-117.03899, 32.56267], [-117.03898, 32.56259], [-117.03935, 32.56227]]]]} | No Public Access 3 | 47593 | Furby-North Property | 31320 | 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 | 89.107 | Furby-North Property | 0 | Local Other or Unknown 14 | 4 | |
7619 | 7619 | 7618 | {"type": "Polygon", "coordinates": [[[-116.82786, 32.82212], [-116.82777, 32.82238], [-116.82768, 32.82304], [-116.82756, 32.82342], [-116.82751, 32.82344], [-116.82696, 32.82328], [-116.82688, 32.82324], [-116.82678, 32.8231], [-116.82662, 32.82264], [-116.8266, 32.82253], [-116.82663, 32.82209], [-116.82665, 32.82201], [-116.82738, 32.82222], [-116.82739, 32.82221], [-116.82738, 32.82197], [-116.82786, 32.82212]]]} | Open Access 1 | 47633 | Old Ironsides County Park | 31372 | 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 | 3.365 | Old Ironsides County Park | 0 | Local Park 2 | 4 | |
12242 | 12242 | 12241 | {"type": "MultiPolygon", "coordinates": [[[[-117.18634, 33.08768], [-117.18422, 33.08768], [-117.18424, 33.08862], [-117.1842, 33.09134], [-117.18211, 33.09133], [-117.18197, 33.09493], [-117.17742, 33.09493], [-117.17755, 33.08762], [-117.17527, 33.08759], [-117.17541, 33.08587], [-117.17429, 33.08585], [-117.17445, 33.08402], [-117.17778, 33.08404], [-117.17803, 33.08039], [-117.17905, 33.08039], [-117.18143, 33.08206], [-117.18122, 33.08316], [-117.17997, 33.08494], [-117.1802, 33.08476], [-117.18126, 33.08458], [-117.18138, 33.08479], [-117.18209, 33.08429], [-117.1826, 33.08426], [-117.1827, 33.08451], [-117.18264, 33.08506], [-117.18284, 33.08558], [-117.18309, 33.08538], [-117.18327, 33.08488], [-117.18313, 33.08447], [-117.18316, 33.08417], [-117.18324, 33.08408], [-117.18445, 33.08407], [-117.18504, 33.08445], [-117.18538, 33.08469], [-117.18565, 33.08491], [-117.18581, 33.08507], [-117.18633, 33.08568], [-117.18634, 33.08768]]], [[[-117.18635, 33.08529], [-117.186, 33.08489], [-117.18581, 33.08472], [-117.18524, 33.08429], [-117.18491, 33.08407], [-117.18633, 33.08407], [-117.18635, 33.08529]]]]} | No Public Access 3 | 25447 | Sage Hill Preserve | 29254 | 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 | 231.523 | Sage Hill Preserve | 0 | Local Conservation Area 4 | 2 | |
13225 | 13225 | 13224 | {"type": "Polygon", "coordinates": [[[-117.12022, 33.25594], [-117.11798, 33.25608], [-117.11133, 33.25648], [-117.11148, 33.25634], [-117.11161, 33.25629], [-117.11177, 33.25622], [-117.11191, 33.25612], [-117.11201, 33.25602], [-117.11211, 33.256], [-117.11224, 33.25577], [-117.11221, 33.25567], [-117.11279, 33.25455], [-117.11293, 33.25435], [-117.11314, 33.25414], [-117.11321, 33.25417], [-117.11343, 33.25402], [-117.11339, 33.25397], [-117.11357, 33.25388], [-117.11582, 33.25311], [-117.1161, 33.25299], [-117.11637, 33.25284], [-117.12005, 33.2528], [-117.12022, 33.25594]]]} | No Public Access 3 | 45242 | Old Castle Mitigation Area | 23082 | 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 | 58.565 | Old Castle Mitigation Area | 0 | Local Other or Unknown 14 | 4 | |
14553 | 14553 | 14552 | {"type": "Polygon", "coordinates": [[[-117.142, 33.36266], [-117.14183, 33.36576], [-117.13969, 33.36579], [-117.13986, 33.36259], [-117.142, 33.36266]]]} | No Public Access 3 | 45226 | Pala Mesa Mitigation Property | 29252 | 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 | 17.191 | Pala Mesa Mitigation Property | 0 | Local Other or Unknown 14 | 4 | |
14610 | 14610 | 14609 | {"type": "MultiPolygon", "coordinates": [[[[-117.18723, 33.06546], [-117.18548, 33.06687], [-117.18548, 33.06687], [-117.1855, 33.06545], [-117.18723, 33.06546]]], [[[-117.19071, 33.0655], [-117.18965, 33.06846], [-117.18937, 33.06842], [-117.18924, 33.06843], [-117.18905, 33.06849], [-117.18895, 33.06856], [-117.18842, 33.06661], [-117.18836, 33.06649], [-117.18808, 33.06547], [-117.19071, 33.0655]]], [[[-117.18728, 33.0727], [-117.1848, 33.07266], [-117.18489, 33.07234], [-117.18501, 33.07155], [-117.18506, 33.0713], [-117.18494, 33.07096], [-117.18482, 33.07042], [-117.18453, 33.06973], [-117.18441, 33.06953], [-117.18417, 33.06924], [-117.18403, 33.06917], [-117.18387, 33.06916], [-117.18385, 33.0691], [-117.18541, 33.06911], [-117.18638, 33.06908], [-117.18726, 33.06908], [-117.18728, 33.0727]]], [[[-117.17423, 33.07671], [-117.17417, 33.0784], [-117.17415, 33.07845], [-117.17348, 33.07833], [-117.17312, 33.0783], [-117.17248, 33.07829], [-117.17227, 33.07826], [-117.17207, 33.0782], [-117.17154, 33.07797], [-117.17111, 33.07773], [-117.17073, 33.07743], [-117.16999, 33.07663], [-117.17001, 33.07636], [-117.17294, 33.07642], [-117.17294, 33.0767], [-117.17423, 33.07671]]], [[[-117.19572, 33.07672], [-117.1957, 33.0794], [-117.19324, 33.07923], [-117.19334, 33.07904], [-117.19314, 33.07854], [-117.19205, 33.07829], [-117.19191, 33.07822], [-117.19179, 33.07814], [-117.19161, 33.07794], [-117.19153, 33.07779], [-117.19149, 33.07761], [-117.19143, 33.0776], [-117.19146, 33.07717], [-117.19145, 33.07663], [-117.18855, 33.07658], [-117.18857, 33.07545], [-117.19146, 33.07551], [-117.19146, 33.07663], [-117.19572, 33.07672]]], [[[-117.17416, 33.07869], [-117.17408, 33.08036], [-117.16976, 33.08034], [-117.16984, 33.07885], [-117.16998, 33.07701], [-117.17052, 33.07759], [-117.17088, 33.07786], [-117.17113, 33.07803], [-117.1714, 33.07817], [-117.17195, 33.07841], [-117.17216, 33.07848], [-117.17237, 33.07851], [-117.17326, 33.07855], [-117.1736, 33.07859], [-117.17416, 33.07869]]], [[[-117.15319, 33.08571], [-117.15294, 33.08582], [-117.15251, 33.08596], [-117.15219, 33.08602], [-117.15183, 33.08606], [-117.15133, 33.08605], [-117.14956, 33.08587], [-117.14844, 33.0858], [-117.14823, 33.0858], [-117.14805, 33.08584], [-117.14803, 33.08027], [-117.15231, 33.08034], [-117.15223, 33.08571], [-117.15319, 33.08571]]], [[[-117.14475, 33.08745], [-117.1439, 33.08753], [-117.1439, 33.08753], [-117.1439, 33.08751], [-117.14394, 33.08751], [-117.14414, 33.08745], [-117.14475, 33.08745]]], [[[-117.15649, 33.08564], [-117.15649, 33.08741], [-117.15009, 33.08746], [-117.15012, 33.08937], [-117.14806, 33.0894], [-117.14808, 33.09109], [-117.1522, 33.09107], [-117.15221, 33.09471], [-117.1507, 33.09472], [-117.15069, 33.09473], [-117.1529, 33.09685], [-117.1533, 33.09789], [-117.15372, 33.09849], [-117.15353, 33.09873], [-117.15287, 33.09997], [-117.15245, 33.10051], [-117.15247, 33.10086], [-117.15329, 33.10166], [-117.15378, 33.10215], [-117.15386, 33.10237], [-117.15388, 33.10252], [-117.15386, 33.10266], [-117.15379, 33.10284], [-117.15365, 33.10304], [-117.15361, 33.10318], [-117.15363, 33.10332], [-117.15381, 33.10356], [-117.15382, 33.10365], [-117.15376, 33.10382], [-117.15357, 33.10398], [-117.15352, 33.10411], [-117.15351, 33.10421], [-117.15356, 33.10433], [-117.1537, 33.10449], [-117.15383, 33.10459], [-117.15398, 33.10468], [-117.15435, 33.10482], [-117.15455, 33.10504], [-117.15475, 33.10519], [-117.15482, 33.1053], [-117.15484, 33.10539], [-117.15488, 33.10548], [-117.15495, 33.10555], [-117.15522, 33.10568], [-117.15528, 33.10574], [-117.15536, 33.10597], [-117.15542, 33.10607], [-117.15567, 33.10631], [-117.15573, 33.10641], [-117.1558, 33.10661], [-117.15591, 33.10672], [-117.156, 33.10677], [-117.15617, 33.10681], [-117.15621, 33.10686], [-117.15622, 33.10691], [-117.1562, 33.10696], [-117.15615, 33.10699], [-117.15615, 33.10711], [-117.15609, 33.10712], [-117.15602, 33.10951], [-117.15534, 33.10922], [-117.15424, 33.10859], [-117.15415, 33.1086], [-117.15418, 33.10894], [-117.15418, 33.11015], [-117.15412, 33.11003], [-117.15402, 33.10997], [-117.15375, 33.1091], [-117.15355, 33.10862], [-117.1534, 33.10836], [-117.15337, 33.10821], [-117.1534, 33.10809], [-117.15344, 33.10805], [-117.15356, 33.10797], [-117.15383, 33.10784], [-117.15404, 33.10777], [-117.15451, 33.10766], [-117.15487, 33.10749], [-117.15514, 33.10743], [-117.15544, 33.10728], [-117.15566, 33.10722], [-117.15596, 33.10708], [-117.15596, 33.10706], [-117.15425, 33.10641], [-117.15282, 33.10651], [-117.15056, 33.10608], [-117.14915, 33.10526], [-117.14816, 33.10531], [-117.14802, 33.09843], [-117.13961, 33.09842], [-117.13962, 33.09474], [-117.14391, 33.09473], [-117.14393, 33.09378], [-117.1439, 33.09109], [-117.1396, 33.09109], [-117.13961, 33.09282], [-117.13652, 33.09281], [-117.13649, 33.0927], [-117.13649, 33.09251], [-117.13651, 33.0923], [-117.13645, 33.09202], [-117.13643, 33.09161], [-117.13651, 33.09136], [-117.13665, 33.0911], [-117.13685, 33.09077], [-117.13738, 33.09003], [-117.13755, 33.08972], [-117.13766, 33.08945], [-117.13778, 33.08925], [-117.13793, 33.08906], [-117.13802, 33.08897], [-117.13817, 33.08887], [-117.13835, 33.08879], [-117.13851, 33.08877], [-117.1387, 33.08878], [-117.13924, 33.08898], [-117.13943, 33.08902], [-117.13959, 33.08903], [-117.1396, 33.08909], [-117.14002, 33.08903], [-117.1404, 33.08901], [-117.14066, 33.08897], [-117.14123, 33.08882], [-117.14372, 33.08787], [-117.14407, 33.08772], [-117.14433, 33.08764], [-117.14518, 33.08757], [-117.14537, 33.08753], [-117.14561, 33.08744], [-117.148, 33.08744], [-117.14801, 33.08748], [-117.14803, 33.08747], [-117.14806, 33.08608], [-117.14818, 33.08605], [-117.1483, 33.08603], [-117.14876, 33.08605], [-117.14953, 33.08611], [-117.1514, 33.0863], [-117.15187, 33.08631], [-117.15239, 33.08624], [-117.15292, 33.0861], [-117.15339, 33.08588], [-117.15366, 33.0857], [-117.15649, 33.08564]]]]} | No Public Access 3 | 44822 | Escondido Creek Preserve | 29232 | 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 | 625.018 | Escondido Creek Preserve | 0 | Local Conservation Area 4 | 2 | |
14635 | 14635 | 14634 | {"type": "Polygon", "coordinates": [[[-117.10501, 33.01145], [-117.10485, 33.01158], [-117.10476, 33.01169], [-117.10473, 33.01183], [-117.10471, 33.01203], [-117.10476, 33.01243], [-117.10474, 33.01289], [-117.1046, 33.01309], [-117.1044, 33.01313], [-117.10431, 33.01325], [-117.1041, 33.01314], [-117.10388, 33.01304], [-117.10297, 33.01276], [-117.10268, 33.01265], [-117.10215, 33.01241], [-117.10125, 33.01195], [-117.09931, 33.01118], [-117.09888, 33.011], [-117.09844, 33.0108], [-117.09802, 33.01057], [-117.09748, 33.01024], [-117.09709, 33.00997], [-117.09672, 33.00969], [-117.0966, 33.00959], [-117.09698, 33.00811], [-117.1048, 33.00837], [-117.10477, 33.00869], [-117.10481, 33.00874], [-117.10454, 33.00943], [-117.10481, 33.00975], [-117.10482, 33.01], [-117.10492, 33.01018], [-117.10484, 33.01029], [-117.1048, 33.01076], [-117.1047, 33.01099], [-117.10468, 33.01115], [-117.10469, 33.01122], [-117.10471, 33.01127], [-117.10475, 33.01131], [-117.105, 33.01142], [-117.10501, 33.01145]], [[-117.10204, 33.01004], [-117.10213, 33.01005], [-117.10226, 33.01004], [-117.10237, 33.01001], [-117.10247, 33.00996], [-117.10255, 33.00989], [-117.10262, 33.0098], [-117.10265, 33.0097], [-117.10266, 33.0096], [-117.10261, 33.00944], [-117.10255, 33.00937], [-117.10247, 33.0093], [-117.10235, 33.00924], [-117.10222, 33.00922], [-117.10207, 33.00922], [-117.10198, 33.00925], [-117.10193, 33.00914], [-117.10174, 33.00924], [-117.10161, 33.00939], [-117.10154, 33.00955], [-117.10153, 33.0098], [-117.10156, 33.00992], [-117.10162, 33.01005], [-117.10168, 33.01013], [-117.10183, 33.01027], [-117.10191, 33.01037], [-117.10192, 33.01036], [-117.10204, 33.01004]]]} | Open Access 1 | 44867 | Christopher Hill Holding | 29230 | 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 | 69.353 | Christopher Hill Holding | None 1248 | |||
14716 | 14716 | 14715 | {"type": "Polygon", "coordinates": [[[-116.38556, 32.97589], [-116.38485, 32.97959], [-116.38064, 32.97968], [-116.37621, 32.97986], [-116.37679, 32.97617], [-116.3768, 32.9758], [-116.38134, 32.97552], [-116.38136, 32.97593], [-116.38556, 32.97589]]]} | Unknown Access 4 | 47814 | Unnamed site - San Diego, County of | 31715 | 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 | 87.174 | 0 | Local Other or Unknown 14 | 4 | ||
14809 | 14809 | 14808 | {"type": "Polygon", "coordinates": [[[-117.14066, 33.25449], [-117.14028, 33.2546], [-117.14032, 33.2547], [-117.14037, 33.25475], [-117.14057, 33.25543], [-117.1406, 33.25571], [-117.14058, 33.2559], [-117.14028, 33.25665], [-117.14037, 33.25683], [-117.13807, 33.25672], [-117.13802, 33.25307], [-117.13827, 33.25307], [-117.13853, 33.25318], [-117.13868, 33.25322], [-117.13897, 33.25337], [-117.13918, 33.25314], [-117.13955, 33.25349], [-117.14011, 33.25382], [-117.14025, 33.25392], [-117.14035, 33.25403], [-117.14066, 33.25449]]]} | Restricted Access 2 | 45227 | Knollwood Preserve | 31493 | 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 | 20.712 | Knollwood Preserve | 0 | Local Conservation Area 4 | 2 | |
15152 | 15152 | 15151 | {"type": "Polygon", "coordinates": [[[-117.02397, 33.1489], [-117.0239, 33.14891], [-117.0239, 33.1525], [-117.02365, 33.15577], [-117.02352, 33.15771], [-117.02307, 33.16317], [-117.01963, 33.16302], [-117.01956, 33.16279], [-117.01479, 33.16263], [-117.01268, 33.16299], [-117.00684, 33.16413], [-117.00685, 33.16376], [-117.00731, 33.16309], [-117.00787, 33.16232], [-117.00813, 33.16193], [-117.00823, 33.1618], [-117.00842, 33.16163], [-117.00899, 33.16133], [-117.0092, 33.16115], [-117.00963, 33.16057], [-117.01, 33.16016], [-117.0109, 33.15901], [-117.011, 33.15891], [-117.01118, 33.15879], [-117.01141, 33.15874], [-117.01164, 33.15874], [-117.01189, 33.15882], [-117.01208, 33.15849], [-117.01212, 33.15834], [-117.01213, 33.1582], [-117.01201, 33.15618], [-117.01198, 33.15605], [-117.01192, 33.15593], [-117.01179, 33.15576], [-117.01168, 33.15567], [-117.01173, 33.15501], [-117.01431, 33.15464], [-117.01429, 33.15444], [-117.01429, 33.15428], [-117.0145, 33.15332], [-117.01455, 33.15225], [-117.01465, 33.15223], [-117.01927, 33.15236], [-117.01936, 33.14882], [-117.02397, 33.1489]]]} | Open Access 1 | 45997 | Bottle Peak Preserve | 29192 | 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 | 373.609 | Bottle Peak Preserve | 0 | Local Conservation Area 4 | 2 | |
15953 | 15953 | 15952 | {"type": "MultiPolygon", "coordinates": [[[[-117.124, 33.02413], [-117.12257, 33.02413], [-117.12257, 33.02322], [-117.124, 33.02355], [-117.124, 33.02413]]], [[[-117.13535, 33.02536], [-117.13525, 33.02933], [-117.13012, 33.02935], [-117.13012, 33.02888], [-117.12976, 33.02888], [-117.12976, 33.02694], [-117.12954, 33.02684], [-117.12933, 33.02663], [-117.12881, 33.02639], [-117.12849, 33.0263], [-117.12825, 33.02611], [-117.12803, 33.02617], [-117.12759, 33.02615], [-117.12683, 33.02594], [-117.12697, 33.02576], [-117.12691, 33.02569], [-117.12678, 33.02585], [-117.12597, 33.02557], [-117.12573, 33.02631], [-117.12505, 33.02622], [-117.12441, 33.02566], [-117.12413, 33.02585], [-117.12413, 33.02513], [-117.12463, 33.02513], [-117.12549, 33.02508], [-117.12609, 33.02509], [-117.1261, 33.02455], [-117.12475, 33.0242], [-117.12512, 33.02389], [-117.12563, 33.02406], [-117.12575, 33.02402], [-117.1259, 33.02408], [-117.12601, 33.02406], [-117.12607, 33.02423], [-117.1261, 33.02424], [-117.12689, 33.02403], [-117.12791, 33.02407], [-117.12785, 33.02453], [-117.12792, 33.02502], [-117.12834, 33.02606], [-117.12851, 33.02619], [-117.12893, 33.02618], [-117.12934, 33.02647], [-117.12986, 33.02668], [-117.13013, 33.02675], [-117.13114, 33.02674], [-117.1319, 33.02662], [-117.1321, 33.02653], [-117.13217, 33.02657], [-117.13251, 33.02641], [-117.13264, 33.02673], [-117.13301, 33.027], [-117.13325, 33.02706], [-117.13334, 33.02696], [-117.13342, 33.0267], [-117.13415, 33.02595], [-117.13498, 33.02538], [-117.13535, 33.02536]]], [[[-117.13541, 33.02216], [-117.13536, 33.02509], [-117.13519, 33.02509], [-117.13423, 33.02439], [-117.13423, 33.02404], [-117.13391, 33.02364], [-117.13391, 33.02355], [-117.13422, 33.02335], [-117.13425, 33.02292], [-117.13427, 33.02218], [-117.13541, 33.02216]]]]} | Open Access 1 | 44866 | Santa Fe Valley Open Space Preserve | 25091 | 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 | 67.159 | Santa Fe Valley OSP | 0 | Local Conservation Area 4 | 2 | |
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 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://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 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.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 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]);