units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
99 rows where COUNTY = 4 and DES_TP = 14 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AGENCY 14
- Poway, City of 35
- San Diego, City of 14
- Escondido, City of 9
- Encinitas, City of 4
- San Diego, County of 4
- San Marcos, City of 4
- Ramona Municipal Water District 2
- Santee, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- Borrego Water District 1
- Helix Water District 1
- Olivenhain Municipal Water District 1
- North County Transit District 1
MNG_AG_TYP 4
ACCESS_TYP 4
DES_TP 1
- Local Other or Unknown · 79 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13428 | 13428 | 13427 | {"type": "Polygon", "coordinates": [[[-117.25127, 33.02194], [-117.25127, 33.02345], [-117.25103, 33.02344], [-117.2509, 33.02335], [-117.2507, 33.0233], [-117.25061, 33.02326], [-117.25046, 33.02314], [-117.25039, 33.02299], [-117.25041, 33.02262], [-117.25034, 33.02248], [-117.25025, 33.02238], [-117.2504, 33.02227], [-117.25071, 33.0221], [-117.25109, 33.02196], [-117.25123, 33.02192], [-117.25126, 33.02192], [-117.25127, 33.02194]]]} | Open Access 1 | 35546 | Encinitas holding 42 | 18662 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 2.872 | Encinitas holding 42 | 0 | Local Other or Unknown 14 | 4 | |
13421 | 13421 | 13420 | {"type": "Polygon", "coordinates": [[[-117.25119, 33.02892], [-117.25116, 33.02906], [-117.24968, 33.02909], [-117.24971, 33.02907], [-117.24974, 33.02897], [-117.24991, 33.02881], [-117.24992, 33.02878], [-117.24992, 33.02865], [-117.24995, 33.02859], [-117.25001, 33.02853], [-117.25075, 33.02804], [-117.25081, 33.02804], [-117.25084, 33.02805], [-117.25088, 33.0281], [-117.25089, 33.02815], [-117.25081, 33.02827], [-117.25054, 33.02853], [-117.2505, 33.02861], [-117.25049, 33.02867], [-117.25051, 33.02876], [-117.25055, 33.0288], [-117.25063, 33.02884], [-117.2508, 33.02884], [-117.25102, 33.02881], [-117.25113, 33.02882], [-117.25118, 33.02885], [-117.25119, 33.02892]]]} | Open Access 1 | 35539 | Encinitas holding 47 | 18663 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.83 | Encinitas holding 47 | 0 | Local Other or Unknown 14 | 4 | |
13539 | 13539 | 13538 | {"type": "Polygon", "coordinates": [[[-117.25535, 33.02689], [-117.25534, 33.02898], [-117.25128, 33.02906], [-117.2513, 33.02725], [-117.25342, 33.02724], [-117.25342, 33.0256], [-117.254, 33.02648], [-117.25474, 33.0268], [-117.25483, 33.02681], [-117.25471, 33.02689], [-117.2546, 33.02701], [-117.25456, 33.02725], [-117.25397, 33.02765], [-117.25373, 33.02775], [-117.25324, 33.02793], [-117.25311, 33.02796], [-117.25294, 33.02798], [-117.25266, 33.02794], [-117.25253, 33.02801], [-117.25239, 33.02798], [-117.25232, 33.028], [-117.25207, 33.02796], [-117.25171, 33.02806], [-117.25159, 33.0282], [-117.25156, 33.02832], [-117.25161, 33.02851], [-117.25164, 33.02857], [-117.25179, 33.02864], [-117.25193, 33.02864], [-117.25228, 33.02858], [-117.25241, 33.02857], [-117.25275, 33.02876], [-117.25302, 33.02883], [-117.25333, 33.02882], [-117.25358, 33.02876], [-117.25375, 33.0287], [-117.25448, 33.02862], [-117.25459, 33.0287], [-117.25478, 33.0287], [-117.25495, 33.02852], [-117.25504, 33.02837], [-117.25503, 33.02795], [-117.25505, 33.02785], [-117.25508, 33.02733], [-117.25508, 33.02708], [-117.25506, 33.02703], [-117.25506, 33.02696], [-117.25512, 33.02692], [-117.25517, 33.02685], [-117.25531, 33.02685], [-117.25533, 33.02685], [-117.25535, 33.02689]]]} | Open Access 1 | 35847 | Encinitas holding 5 | 18664 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 13.377 | Encinitas holding 5 | 0 | Local Other or Unknown 14 | 4 | |
5007 | 5007 | 5006 | {"type": "Polygon", "coordinates": [[[-117.08308, 33.12563], [-117.083, 33.12566], [-117.08273, 33.12596], [-117.08261, 33.1257], [-117.08295, 33.12535], [-117.08308, 33.12563]]]} | No Public Access 3 | 689 | Escondido Creek | 18706 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 0.332 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
5863 | 5863 | 5862 | {"type": "MultiPolygon", "coordinates": [[[[-117.02636, 33.16692], [-117.02637, 33.16744], [-117.0263, 33.16767], [-117.02627, 33.16768], [-117.02381, 33.1705], [-117.0228, 33.17041], [-117.02244, 33.17066], [-117.02191, 33.17075], [-117.02157, 33.17076], [-117.0211, 33.17036], [-117.02039, 33.17028], [-117.0193, 33.16949], [-117.01888, 33.1689], [-117.01829, 33.16863], [-117.0182, 33.16854], [-117.01809, 33.16833], [-117.01805, 33.16832], [-117.01805, 33.16822], [-117.01821, 33.16823], [-117.01836, 33.16851], [-117.01841, 33.16856], [-117.019, 33.16883], [-117.01907, 33.16893], [-117.01899, 33.16898], [-117.01935, 33.16949], [-117.02041, 33.17025], [-117.02111, 33.17033], [-117.02157, 33.17072], [-117.02186, 33.17071], [-117.02188, 33.17067], [-117.02237, 33.17059], [-117.02276, 33.17032], [-117.02381, 33.17041], [-117.02579, 33.16812], [-117.02611, 33.1677], [-117.02619, 33.16744], [-117.02618, 33.16691], [-117.02636, 33.16692]]], [[[-117.03026, 33.16085], [-117.02978, 33.16201], [-117.02983, 33.16203], [-117.02952, 33.16302], [-117.02949, 33.16333], [-117.02954, 33.16362], [-117.02927, 33.16475], [-117.02785, 33.16432], [-117.02829, 33.16321], [-117.02812, 33.16305], [-117.02818, 33.16299], [-117.02891, 33.16214], [-117.029, 33.16188], [-117.02906, 33.16187], [-117.02931, 33.16168], [-117.02936, 33.16148], [-117.02948, 33.16128], [-117.02963, 33.16113], [-117.02986, 33.16099], [-117.03026, 33.16085]]], [[[-117.047, 33.14542], [-117.0464, 33.14577], [-117.04613, 33.14599], [-117.04568, 33.14639], [-117.04536, 33.1466], [-117.04502, 33.14677], [-117.04494, 33.1468], [-117.04431, 33.14709], [-117.04386, 33.14733], [-117.04316, 33.14765], [-117.04287, 33.14774], [-117.04248, 33.14783], [-117.04224, 33.14786], [-117.04113, 33.1479], [-117.04094, 33.14799], [-117.04089, 33.14791], [-117.04015, 33.14791], [-117.03971, 33.14795], [-117.03949, 33.14801], [-117.03909, 33.14814], [-117.0387, 33.1484], [-117.03852, 33.14855], [-117.03758, 33.14944], [-117.03759, 33.14947], [-117.03744, 33.14963], [-117.03729, 33.14987], [-117.03692, 33.14982], [-117.03731, 33.14903], [-117.03754, 33.14905], [-117.03827, 33.14831], [-117.03842, 33.14818], [-117.03841, 33.14815], [-117.03858, 33.14803], [-117.03896, 33.14783], [-117.03932, 33.14768], [-117.03981, 33.14758], [-117.04015, 33.14756], [-117.04116, 33.14756], [-117.04121, 33.14762], [-117.04189, 33.14763], [-117.04224, 33.1476], [-117.04252, 33.14756], [-117.04277, 33.14749], [-117.043, 33.14741], [-117.04507, 33.14646], [-117.04528, 33.14635], [-117.04539, 33.14627], [-117.04584, 33.14587], [-117.04623, 33.14554], [-117.04685, 33.14517], [-117.047, 33.14542]]], [[[-117.0675, 33.13214], [-117.06677, 33.13264], [-117.06648, 33.13289], [-117.06619, 33.13307], [-117.06584, 33.13324], [-117.06561, 33.13332], [-117.06516, 33.13344], [-117.06488, 33.13347], [-117.06459, 33.13312], [-117.06483, 33.1331], [-117.06485, 33.13313], [-117.06512, 33.13308], [-117.06552, 33.13296], [-117.06601, 33.13276], [-117.06651, 33.13245], [-117.06738, 33.13176], [-117.0675, 33.13214]]], [[[-117.06901, 33.13096], [-117.06874, 33.13109], [-117.06832, 33.13136], [-117.06801, 33.13163], [-117.06802, 33.13165], [-117.06769, 33.13191], [-117.06757, 33.13154], [-117.0683, 33.13093], [-117.0688, 33.13065], [-117.06901, 33.13096]]], [[[-117.0704, 33.13036], [-117.06983, 33.13063], [-117.0698, 33.1306], [-117.06925, 33.13085], [-117.06904, 33.13054], [-117.07019, 33.13002], [-117.0704, 33.13036]]], [[[-117.07179, 33.12972], [-117.07063, 33.13026], [-117.07043, 33.12995], [-117.07073, 33.12981], [-117.07071, 33.12977], [-117.07158, 33.12938], [-117.07179, 33.12972]]], [[[-117.07317, 33.12909], [-117.07202, 33.12961], [-117.07181, 33.12927], [-117.07295, 33.12874], [-117.07317, 33.12909]]], [[[-117.07456, 33.12844], [-117.07339, 33.12896], [-117.07334, 33.1289], [-117.07432, 33.12843], [-117.07448, 33.12836], [-117.07456, 33.12844]]], [[[-117.07591, 33.12782], [-117.07479, 33.12835], [-117.07472, 33.12824], [-117.07586, 33.12772], [-117.07591, 33.12782]]], [[[-117.07746, 33.12743], [-117.07699, 33.12747], [-117.07676, 33.12751], [-117.07641, 33.12762], [-117.07616, 33.12773], [-117.07608, 33.12761], [-117.07724, 33.12709], [-117.07746, 33.12743]]], [[[-117.08144, 33.1271], [-117.08115, 33.12721], [-117.08078, 33.1273], [-117.08026, 33.12738], [-117.07774, 33.12741], [-117.07754, 33.12707], [-117.07901, 33.12707], [-117.08015, 33.12704], [-117.08067, 33.12695], [-117.08102, 33.12686], [-117.08124, 33.12678], [-117.08144, 33.1271]]], [[[-117.08226, 33.12655], [-117.08202, 33.12674], [-117.08199, 33.12672], [-117.08166, 33.12695], [-117.08146, 33.12667], [-117.08176, 33.12645], [-117.08176, 33.12644], [-117.08207, 33.12614], [-117.08226, 33.12655]]], [[[-117.08271, 33.12607], [-117.08237, 33.12643], [-117.0822, 33.12601], [-117.08225, 33.12599], [-117.08254, 33.12569], [-117.08271, 33.12607]]], [[[-117.08966, 33.12061], [-117.08939, 33.12075], [-117.08924, 33.12087], [-117.08838, 33.12158], [-117.08823, 33.12129], [-117.08922, 33.12051], [-117.08949, 33.12035], [-117.08966, 33.12061]]], [[[-117.09276, 33.11986], [-117.09207, 33.11988], [-117.09152, 33.11994], [-117.09127, 33.11998], [-117.09056, 33.12017], [-117.09021, 33.1203], [-117.08986, 33.12046], [-117.0897, 33.12024], [-117.08998, 33.12008], [-117.09025, 33.11996], [-117.09048, 33.11986], [-117.09078, 33.11978], [-117.09107, 33.11977], [-117.09148, 33.11968], [-117.09186, 33.11961], [-117.09222, 33.11958], [-117.09265, 33.11958], [-117.09276, 33.11986]]], [[[-117.09679, 33.11874], [-117.09593, 33.11947], [-117.09577, 33.11965], [-117.09533, 33.11949], [-117.09538, 33.1194], [-117.09539, 33.11936], [-117.09511, 33.11927], [-117.09567, 33.119], [-117.09571, 33.11901], [-117.09634, 33.11858], [-117.09679, 33.11874]]], [[[-117.09969, 33.11766], [-117.09946, 33.1182], [-117.0989, 33.11818], [-117.09888, 33.11815], [-117.09867, 33.11815], [-117.09837, 33.11816], [-117.09803, 33.11822], [-117.09776, 33.11828], [-117.0975, 33.11838], [-117.09728, 33.11849], [-117.09706, 33.11865], [-117.09653, 33.11844], [-117.09691, 33.11816], [-117.09712, 33.11804], [-117.09749, 33.11788], [-117.09798, 33.11774], [-117.09798, 33.11772], [-117.09829, 33.11767], [-117.09893, 33.11765], [-117.09894, 33.11768], [-117.09931, 33.11768], [-117.09969, 33.11766]]], [[[-117.1043, 33.11385], [-117.10384, 33.11409], [-117.10355, 33.11429], [-117.10326, 33.11453], [-117.10283, 33.11502], [-117.10252, 33.11554], [-117.10242, 33.11581], [-117.10218, 33.11658], [-117.10203, 33.11686], [-117.10177, 33.1172], [-117.10174, 33.11727], [-117.10161, 33.11742], [-117.10146, 33.11755], [-117.10118, 33.11774], [-117.10097, 33.11726], [-117.10097, 33.11723], [-117.10128, 33.11699], [-117.1015, 33.11676], [-117.10182, 33.11591], [-117.10195, 33.1155], [-117.10213, 33.11513], [-117.10232, 33.11481], [-117.10255, 33.11452], [-117.10257, 33.11437], [-117.10284, 33.11418], [-117.10307, 33.11393], [-117.10311, 33.11394], [-117.10358, 33.11365], [-117.1043, 33.11385]]], [[[-117.11185, 33.10955], [-117.11069, 33.11042], [-117.11039, 33.11068], [-117.11003, 33.11107], [-117.10985, 33.11132], [-117.10976, 33.11149], [-117.10961, 33.1117], [-117.10939, 33.11195], [-117.10889, 33.11244], [-117.10817, 33.11317], [-117.10811, 33.11314], [-117.10768, 33.11353], [-117.10742, 33.11388], [-117.10735, 33.11405], [-117.10729, 33.11442], [-117.10718, 33.11439], [-117.10723, 33.11402], [-117.10738, 33.11364], [-117.10735, 33.11362], [-117.1076, 33.11327], [-117.10792, 33.11298], [-117.10786, 33.11293], [-117.10723, 33.11311], [-117.10723, 33.11314], [-117.10474, 33.11367], [-117.10402, 33.11348], [-117.10445, 33.11328], [-117.10496, 33.11313], [-117.10644, 33.11287], [-117.10742, 33.11262], [-117.10777, 33.1125], [-117.10831, 33.11222], [-117.10878, 33.11189], [-117.1092, 33.11145], [-117.10968, 33.11079], [-117.10997, 33.11045], [-117.11033, 33.11011], [-117.11091, 33.10963], [-117.11124, 33.1093], [-117.11185, 33.10955]]]]} | No Public Access 3 | 192 | Escondido Creek | 18706 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 62.151 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
6250 | 6250 | 6249 | {"type": "Polygon", "coordinates": [[[-117.1192, 33.10579], [-117.11901, 33.10627], [-117.11885, 33.10655], [-117.11637, 33.10688], [-117.11677, 33.10621], [-117.11701, 33.10622], [-117.11704, 33.1061], [-117.11691, 33.10609], [-117.11713, 33.10571], [-117.11708, 33.10568], [-117.1178, 33.10446], [-117.1192, 33.10579]]]} | No Public Access 3 | 1410 | Escondido Creek | 18706 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 8.905 | Escondido Creek | 0 | Local Other or Unknown 14 | 4 | |
6117 | 6117 | 6116 | {"type": "MultiPolygon", "coordinates": [[[[-116.98689, 32.83198], [-116.98676, 32.83215], [-116.98688, 32.83237], [-116.98633, 32.83237], [-116.98582, 32.83156], [-116.98607, 32.83162], [-116.98636, 32.83172], [-116.9866, 32.83182], [-116.98689, 32.83198]]], [[[-116.99272, 32.83496], [-116.99251, 32.8352], [-116.9923, 32.83491], [-116.99218, 32.83479], [-116.99185, 32.83455], [-116.99147, 32.83438], [-116.99132, 32.83434], [-116.991, 32.83429], [-116.99099, 32.8343], [-116.99099, 32.83449], [-116.98958, 32.83452], [-116.98958, 32.8339], [-116.99016, 32.83389], [-116.9907, 32.83397], [-116.99102, 32.83397], [-116.9914, 32.83405], [-116.99156, 32.8341], [-116.99173, 32.83417], [-116.99207, 32.83433], [-116.99246, 32.83464], [-116.99265, 32.83484], [-116.99272, 32.83496]]], [[[-116.99677, 32.83852], [-116.9964, 32.83852], [-116.99615, 32.83825], [-116.99592, 32.83806], [-116.99576, 32.83797], [-116.99506, 32.83768], [-116.99402, 32.83703], [-116.99377, 32.83685], [-116.99347, 32.83648], [-116.99315, 32.83603], [-116.99263, 32.83534], [-116.99283, 32.83511], [-116.99289, 32.83516], [-116.99337, 32.83577], [-116.99379, 32.83635], [-116.99416, 32.83677], [-116.99457, 32.83705], [-116.99512, 32.8374], [-116.99599, 32.83778], [-116.99626, 32.83795], [-116.99647, 32.83814], [-116.99668, 32.83838], [-116.99677, 32.83852]]]]} | Open Access 1 | 1086 | Forrester Creek | 19002 | 1325 | Santee, City of 34 | City 2 | City Agency 2 | http://www.ci.santee.ca.us/Index.aspx?page=63 | City 2 | 1325 | Santee, City of 33 | City 2 | City Agency 2 | San Diego 4 | 8.757 | Forrester Creek | 0 | Local Other or Unknown 14 | 4 | |
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 | |
1339 | 1339 | 1338 | {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} | No Public Access 3 | 7398 | Marron Valley Mitigation Bank | 21885 | 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 | 2644.0 | Marron Valley Mitigation Bank | 0 | Local Other or Unknown 14 | 4 | |
15141 | 15141 | 15140 | {"type": "Polygon", "coordinates": [[[-117.32181, 33.23522], [-117.32171, 33.23556], [-117.32162, 33.23557], [-117.32159, 33.23552], [-117.32146, 33.23545], [-117.32138, 33.23537], [-117.32154, 33.23522], [-117.32176, 33.23511], [-117.32181, 33.23522]]]} | Open Access 1 | 45966 | Mission Wells Historical Lot | 29115 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/gov/ns/parks/amenities/parks.asp#9 | San Diego 4 | 0.286 | Mission Wells Historical Lot | 0 | Local Other or Unknown 14 | 4 |
7775 | 7775 | 7774 | {"type": "Polygon", "coordinates": [[[-117.16118, 32.95396], [-117.15486, 32.95409], [-117.15484, 32.9525], [-117.16113, 32.95233], [-117.16118, 32.95396]]]} | Open Access 1 | 47658 | North City Mitigation | 31400 | 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 | 26.041 | North City Mitigation | 0 | Local Other or Unknown 14 | 4 | |
14774 | 14774 | 14773 | {"type": "MultiPolygon", "coordinates": [[[[-117.3104, 33.20185], [-117.31053, 33.20215], [-117.31063, 33.20246], [-117.31076, 33.20299], [-117.31074, 33.20304], [-117.31069, 33.20307], [-117.31012, 33.2032], [-117.30901, 33.2034], [-117.308, 33.20353], [-117.30733, 33.20359], [-117.30597, 33.20366], [-117.30496, 33.20366], [-117.30145, 33.20359], [-117.30076, 33.20359], [-117.30007, 33.20361], [-117.29904, 33.20369], [-117.29686, 33.20395], [-117.29686, 33.20297], [-117.30621, 33.20241], [-117.30709, 33.20231], [-117.30775, 33.20222], [-117.31037, 33.2018], [-117.3104, 33.20185]]], [[[-117.31023, 33.20153], [-117.3077, 33.20193], [-117.30618, 33.20213], [-117.29686, 33.2027], [-117.29686, 33.20126], [-117.3063, 33.20135], [-117.31012, 33.20136], [-117.31023, 33.20153]]]]} | Unknown Access 4 | 45152 | North County Transit District Mitigation | 22817 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 69.998 | North County Transit District Mitigation | 0 | Local Other or Unknown 14 | 4 | |
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 | |
5966 | 5966 | 5965 | {"type": "Polygon", "coordinates": [[[-116.99908, 32.56479], [-116.99905, 32.56803], [-116.99907, 32.56804], [-116.99876, 32.56801], [-116.99722, 32.568], [-116.99712, 32.56796], [-116.99709, 32.56789], [-116.99699, 32.56788], [-116.99702, 32.56465], [-116.99704, 32.5646], [-116.99907, 32.56465], [-116.99908, 32.56479]]]} | Open Access 1 | 1051 | Otay Mitigation Site | 23242 | 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 | 17.892 | Otay Mitigation Site | 0 | Local Other or Unknown 14 | 4 | |
9993 | 9993 | 9992 | {"type": "Polygon", "coordinates": [[[-117.00987, 32.55768], [-117.00557, 32.5576], [-117.00555, 32.56025], [-117.00128, 32.56018], [-117.00126, 32.55751], [-116.99834, 32.55745], [-116.99769, 32.55743], [-116.99699, 32.55743], [-116.99699, 32.55385], [-116.99614, 32.55382], [-116.99588, 32.55353], [-116.99536, 32.55264], [-116.99513, 32.55248], [-116.99481, 32.55243], [-116.99449, 32.55257], [-116.99356, 32.55323], [-116.993, 32.55322], [-116.99287, 32.55313], [-116.99284, 32.55268], [-116.99337, 32.55212], [-116.99346, 32.55187], [-116.99337, 32.55162], [-116.99317, 32.55135], [-116.9927, 32.55115], [-116.99269, 32.55005], [-116.99912, 32.55022], [-116.99914, 32.55328], [-116.99985, 32.5533], [-116.99986, 32.55391], [-117.00986, 32.55413], [-117.00985, 32.55619], [-117.00987, 32.55768]]]} | No Public Access 3 | 47971 | Otay Mitigation Site | 32285 | 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 | 200.028 | Otay Mitigation Site | 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 | |
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 |
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]);