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 LAYER
This data as json, copyable, CSV (advanced)
MNG_AGENCY 15
- Poway, City of 34
- Encinitas, City of 20
- San Diego, City of 5
- Escondido, City of 4
- San Diego, County of 4
- Vista, City of 2
- Ramona Municipal Water District 2
- Santee, City of 1
- Oceanside, City of 1
- Chula Vista, City of 1
- San Marcos, 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
AGNCY_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4786 | 4786 | 4785 | {"type": "MultiPolygon", "coordinates": [[[[-116.87263, 32.64332], [-116.87061, 32.64522], [-116.87029, 32.64505], [-116.87093, 32.64366], [-116.87252, 32.64297], [-116.87263, 32.64332]]], [[[-116.87285, 32.64414], [-116.87285, 32.64414], [-116.87206, 32.64428], [-116.87271, 32.64366], [-116.87285, 32.64414]]]]} | No Public Access 3 | 47661 | Unnamed site - San Diego, City of | 31719 | 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.302 | 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 | |
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 | |
6015 | 6015 | 6014 | {"type": "Polygon", "coordinates": [[[-117.09363, 33.12972], [-117.0934, 33.12982], [-117.09332, 33.12983], [-117.09264, 33.12819], [-117.09301, 33.12807], [-117.09327, 33.1289], [-117.09363, 33.12972]]]} | No Public Access 3 | 675 | Reidy Canyon Creek | 24281 | 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 | 1.523 | Reidy Canyon 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 | |
6143 | 6143 | 6142 | {"type": "MultiPolygon", "coordinates": [[[[-117.2322, 33.14229], [-117.23213, 33.1423], [-117.23079, 33.14226], [-117.23016, 33.14279], [-117.23009, 33.14283], [-117.2299, 33.1429], [-117.22971, 33.14288], [-117.22965, 33.14293], [-117.22956, 33.1429], [-117.22942, 33.14281], [-117.22936, 33.14273], [-117.22838, 33.14284], [-117.22763, 33.14285], [-117.22742, 33.14382], [-117.22664, 33.14584], [-117.22578, 33.14584], [-117.22575, 33.14586], [-117.22578, 33.14672], [-117.22545, 33.14622], [-117.22543, 33.14499], [-117.22545, 33.14498], [-117.22571, 33.14438], [-117.22564, 33.14354], [-117.22553, 33.14314], [-117.22408, 33.14364], [-117.22366, 33.14366], [-117.22358, 33.14375], [-117.22341, 33.14374], [-117.22319, 33.14375], [-117.22294, 33.14384], [-117.22269, 33.14399], [-117.22261, 33.14408], [-117.22254, 33.14418], [-117.22244, 33.14426], [-117.22254, 33.1444], [-117.22213, 33.14452], [-117.22193, 33.14451], [-117.22167, 33.14427], [-117.22102, 33.14438], [-117.22071, 33.14439], [-117.22026, 33.14457], [-117.21977, 33.14473], [-117.21939, 33.14498], [-117.21909, 33.14516], [-117.21864, 33.14481], [-117.21879, 33.14463], [-117.21953, 33.14425], [-117.21971, 33.14417], [-117.21927, 33.1437], [-117.2198, 33.14346], [-117.22013, 33.14311], [-117.22065, 33.14288], [-117.2207, 33.1429], [-117.22156, 33.1426], [-117.22174, 33.14268], [-117.22244, 33.14249], [-117.2225, 33.14252], [-117.22325, 33.1423], [-117.22326, 33.14226], [-117.22301, 33.14137], [-117.22304, 33.14137], [-117.22341, 33.14217], [-117.22355, 33.14222], [-117.22536, 33.14182], [-117.22552, 33.14168], [-117.22571, 33.14182], [-117.22573, 33.14223], [-117.23002, 33.14216], [-117.22998, 33.14032], [-117.23034, 33.14013], [-117.23039, 33.14013], [-117.23078, 33.14048], [-117.23149, 33.14103], [-117.2317, 33.14126], [-117.23193, 33.14159], [-117.23208, 33.14189], [-117.2322, 33.14229]]], [[[-117.24385, 33.13544], [-117.24359, 33.13527], [-117.24107, 33.13527], [-117.24034, 33.13552], [-117.23979, 33.13609], [-117.23808, 33.138], [-117.23711, 33.13816], [-117.23713, 33.13888], [-117.23625, 33.1395], [-117.23444, 33.14101], [-117.23228, 33.14173], [-117.23214, 33.14146], [-117.23193, 33.14116], [-117.2317, 33.14091], [-117.23142, 33.14066], [-117.23315, 33.14025], [-117.2341, 33.13943], [-117.23428, 33.13863], [-117.23426, 33.13694], [-117.23613, 33.13594], [-117.23662, 33.13558], [-117.2372, 33.13568], [-117.23806, 33.13524], [-117.23805, 33.13501], [-117.23859, 33.135], [-117.24377, 33.13497], [-117.24385, 33.13544]]], [[[-117.2461, 33.13659], [-117.24526, 33.13547], [-117.24439, 33.13552], [-117.24438, 33.13503], [-117.24439, 33.13496], [-117.246, 33.13495], [-117.2461, 33.13659]]]]} | Open Access 1 | 1138 | Agua Hedionda Creek | 15293 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 113.24 | Agua Hedionda 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 | |
6466 | 6466 | 6465 | {"type": "Polygon", "coordinates": [[[-117.27321, 33.19], [-117.27305, 33.19012], [-117.27292, 33.19077], [-117.27299, 33.19089], [-117.27235, 33.19118], [-117.2714, 33.19154], [-117.26883, 33.19256], [-117.26869, 33.1927], [-117.26711, 33.19335], [-117.26697, 33.19342], [-117.26694, 33.19342], [-117.26676, 33.1935], [-117.26638, 33.19358], [-117.26615, 33.1936], [-117.26629, 33.19355], [-117.26664, 33.19337], [-117.26697, 33.19316], [-117.26841, 33.19181], [-117.26877, 33.19148], [-117.26933, 33.19093], [-117.26955, 33.19073], [-117.26992, 33.19051], [-117.27046, 33.19024], [-117.2708, 33.19001], [-117.27135, 33.18936], [-117.27148, 33.18924], [-117.27166, 33.18908], [-117.27193, 33.18894], [-117.27225, 33.18882], [-117.27306, 33.18867], [-117.27321, 33.19]]]} | Open Access 1 | 2018 | Buena Vista Creek | 16484 | 1369 | Vista, City of 159 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/services/parks-and-facilities | San Diego 4 | 24.565 | Buena Vista Creek | 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 | |
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 | |
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 | |
10489 | 10489 | 10488 | {"type": "MultiPolygon", "coordinates": [[[[-117.12268, 32.69609], [-117.12268, 32.69614], [-117.12249, 32.69637], [-117.12228, 32.69652], [-117.12228, 32.69653], [-117.12235, 32.69653], [-117.12235, 32.6967], [-117.12219, 32.69671], [-117.12219, 32.69676], [-117.12202, 32.69676], [-117.12186, 32.6969], [-117.12186, 32.69698], [-117.12172, 32.69714], [-117.12162, 32.69733], [-117.12157, 32.69751], [-117.12156, 32.69763], [-117.12157, 32.69774], [-117.12147, 32.69775], [-117.12133, 32.6969], [-117.12148, 32.69689], [-117.12178, 32.69653], [-117.12199, 32.69636], [-117.12216, 32.69609], [-117.12268, 32.69609]]], [[[-117.12309, 32.69586], [-117.12232, 32.69587], [-117.12232, 32.69552], [-117.12236, 32.69548], [-117.12309, 32.69548], [-117.12309, 32.69586]]], [[[-117.12309, 32.69542], [-117.12291, 32.69542], [-117.12291, 32.69504], [-117.12308, 32.69505], [-117.12309, 32.69542]]]]} | Open Access 1 | 18586 | Chollas Creek | 17217 | 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 | 2.599 | Chollas Creek | 0 | Local Other or Unknown 14 | 4 | |
11558 | 11558 | 11557 | {"type": "MultiPolygon", "coordinates": [[[[-116.9417, 32.65977], [-116.94153, 32.66001], [-116.94146, 32.66001], [-116.94134, 32.6601], [-116.94109, 32.66002], [-116.94043, 32.66015], [-116.94013, 32.66023], [-116.93992, 32.66038], [-116.93985, 32.66099], [-116.93993, 32.66109], [-116.9397, 32.66127], [-116.93967, 32.66141], [-116.9396, 32.6615], [-116.93959, 32.66161], [-116.93963, 32.66169], [-116.93962, 32.66217], [-116.93965, 32.66241], [-116.93987, 32.66274], [-116.94009, 32.66304], [-116.94024, 32.66334], [-116.94034, 32.66367], [-116.94033, 32.66399], [-116.94054, 32.66419], [-116.9404, 32.66434], [-116.94029, 32.66436], [-116.94008, 32.66444], [-116.94005, 32.66456], [-116.94009, 32.66474], [-116.94001, 32.66501], [-116.93996, 32.66512], [-116.93976, 32.66522], [-116.9396, 32.66538], [-116.93934, 32.66555], [-116.93931, 32.66565], [-116.93918, 32.66573], [-116.93914, 32.66578], [-116.93875, 32.66581], [-116.93873, 32.6657], [-116.93858, 32.66549], [-116.93836, 32.66534], [-116.938, 32.66531], [-116.93731, 32.66566], [-116.93724, 32.66576], [-116.93717, 32.66597], [-116.93703, 32.66611], [-116.9369, 32.66631], [-116.93668, 32.66655], [-116.93668, 32.66669], [-116.93654, 32.66682], [-116.93654, 32.66609], [-116.93437, 32.66605], [-116.93437, 32.66514], [-116.93657, 32.66518], [-116.93658, 32.65806], [-116.93693, 32.65833], [-116.93729, 32.65869], [-116.93758, 32.65884], [-116.93762, 32.65906], [-116.93794, 32.6591], [-116.93841, 32.65947], [-116.93842, 32.65946], [-116.93836, 32.65931], [-116.93804, 32.65879], [-116.93796, 32.6586], [-116.93774, 32.65835], [-116.93772, 32.658], [-116.93753, 32.65766], [-116.93762, 32.65749], [-116.93789, 32.65742], [-116.93831, 32.65764], [-116.93832, 32.65762], [-116.93807, 32.65723], [-116.9378, 32.65714], [-116.93724, 32.65649], [-116.93706, 32.65639], [-116.93678, 32.65633], [-116.93682, 32.65603], [-116.93777, 32.65605], [-116.9417, 32.65977]]], [[[-116.95166, 32.66641], [-116.95161, 32.66692], [-116.95163, 32.66696], [-116.9516, 32.66703], [-116.95159, 32.66721], [-116.94962, 32.66719], [-116.94953, 32.67814], [-116.93649, 32.67798], [-116.93651, 32.67515], [-116.93667, 32.67515], [-116.93683, 32.67519], [-116.93694, 32.6752], [-116.937, 32.6752], [-116.93708, 32.67517], [-116.937, 32.67534], [-116.93703, 32.67544], [-116.93686, 32.67577], [-116.93682, 32.67622], [-116.93675, 32.6765], [-116.93679, 32.67697], [-116.93684, 32.67708], [-116.93688, 32.67715], [-116.93696, 32.67721], [-116.93752, 32.67753], [-116.93754, 32.67758], [-116.93807, 32.6779], [-116.93872, 32.67798], [-116.93913, 32.67797], [-116.93933, 32.678], [-116.9401, 32.67801], [-116.94019, 32.67798], [-116.94054, 32.6777], [-116.94082, 32.67743], [-116.94095, 32.67737], [-116.94108, 32.67716], [-116.94113, 32.67717], [-116.9413, 32.67694], [-116.94143, 32.67692], [-116.94154, 32.67667], [-116.94162, 32.67667], [-116.94173, 32.67639], [-116.94186, 32.67643], [-116.94196, 32.67616], [-116.94206, 32.67615], [-116.94218, 32.6761], [-116.94226, 32.67602], [-116.94231, 32.67586], [-116.94232, 32.67553], [-116.94247, 32.67554], [-116.94248, 32.67527], [-116.94261, 32.67524], [-116.94262, 32.67502], [-116.9427, 32.67497], [-116.9427, 32.6743], [-116.94259, 32.67397], [-116.9425, 32.67384], [-116.94237, 32.67376], [-116.9422, 32.67371], [-116.94199, 32.67373], [-116.94189, 32.67371], [-116.94183, 32.67364], [-116.94184, 32.67335], [-116.94216, 32.67292], [-116.94273, 32.67265], [-116.94281, 32.67271], [-116.94307, 32.67268], [-116.9431, 32.6727], [-116.94321, 32.67272], [-116.94386, 32.67371], [-116.94389, 32.67392], [-116.94388, 32.67401], [-116.94378, 32.67405], [-116.94361, 32.67418], [-116.94352, 32.67448], [-116.94349, 32.67461], [-116.94354, 32.67466], [-116.94361, 32.67464], [-116.94367, 32.67484], [-116.9436, 32.67485], [-116.94359, 32.67486], [-116.94364, 32.67493], [-116.94377, 32.67508], [-116.94364, 32.67528], [-116.94367, 32.67533], [-116.94377, 32.67536], [-116.94392, 32.67554], [-116.94405, 32.67567], [-116.94417, 32.67587], [-116.9444, 32.67615], [-116.94486, 32.67639], [-116.94499, 32.6764], [-116.94518, 32.67651], [-116.94561, 32.67672], [-116.94595, 32.67672], [-116.94643, 32.67668], [-116.94681, 32.67689], [-116.94765, 32.67679], [-116.94767, 32.67675], [-116.94821, 32.67687], [-116.94836, 32.67646], [-116.94841, 32.67642], [-116.94863, 32.67585], [-116.9488, 32.6756], [-116.94889, 32.6755], [-116.94905, 32.67487], [-116.94904, 32.67475], [-116.94922, 32.67465], [-116.94934, 32.67443], [-116.94939, 32.67418], [-116.94922, 32.67339], [-116.94905, 32.67322], [-116.94902, 32.6731], [-116.94906, 32.67297], [-116.94905, 32.67283], [-116.94899, 32.67268], [-116.94892, 32.67261], [-116.94877, 32.67259], [-116.94868, 32.67261], [-116.94839, 32.67254], [-116.94823, 32.67256], [-116.94812, 32.67262], [-116.94805, 32.67271], [-116.94797, 32.67256], [-116.94782, 32.67248], [-116.94781, 32.67244], [-116.94765, 32.67235], [-116.94762, 32.67222], [-116.94757, 32.67219], [-116.9474, 32.67187], [-116.9473, 32.67183], [-116.94711, 32.67171], [-116.94694, 32.67167], [-116.94687, 32.67167], [-116.94685, 32.67147], [-116.94674, 32.6711], [-116.94672, 32.67073], [-116.94623, 32.66956], [-116.94603, 32.66927], [-116.94582, 32.669], [-116.94544, 32.66843], [-116.94568, 32.66829], [-116.946, 32.66758], [-116.94619, 32.66724], [-116.94636, 32.66705], [-116.9466, 32.66689], [-116.94664, 32.66679], [-116.94665, 32.66668], [-116.94654, 32.66642], [-116.94644, 32.66624], [-116.94634, 32.66615], [-116.94631, 32.66601], [-116.94627, 32.6659], [-116.94631, 32.66543], [-116.94648, 32.66474], [-116.94674, 32.66383], [-116.94672, 32.66346], [-116.94657, 32.66294], [-116.94649, 32.66275], [-116.94638, 32.66256], [-116.94624, 32.66246], [-116.9466, 32.66252], [-116.94774, 32.66266], [-116.94797, 32.66272], [-116.94821, 32.6627], [-116.94838, 32.66276], [-116.94856, 32.66278], [-116.94865, 32.6629], [-116.94881, 32.66299], [-116.9488, 32.66337], [-116.94888, 32.66345], [-116.94893, 32.66362], [-116.94902, 32.66379], [-116.94918, 32.6639], [-116.94948, 32.66429], [-116.94966, 32.66433], [-116.94978, 32.66455], [-116.9497, 32.66458], [-116.94975, 32.66464], [-116.94956, 32.66493], [-116.94962, 32.66499], [-116.94996, 32.66495], [-116.94998, 32.665], [-116.95009, 32.66509], [-116.95012, 32.66529], [-116.95016, 32.66532], [-116.95016, 32.66563], [-116.95029, 32.66579], [-116.95029, 32.66615], [-116.95016, 32.66624], [-116.95023, 32.66633], [-116.95041, 32.66644], [-116.95078, 32.66678], [-116.95134, 32.66642], [-116.95136, 32.66638], [-116.95139, 32.66638], [-116.95153, 32.66627], [-116.95166, 32.66641]]]]} | No Public Access 3 | 46837 | Rolling Hills Ranch | 30306 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | San Diego 4 | 221.546 | Rolling Hills Ranch | 0 | Local Other or Unknown 14 | 4 | |
13400 | 13400 | 13399 | {"type": "Polygon", "coordinates": [[[-117.02894, 33.01149], [-117.02839, 33.01226], [-117.02831, 33.01206], [-117.0279, 33.01182], [-117.02767, 33.01162], [-117.02781, 33.01138], [-117.02765, 33.01079], [-117.02712, 33.01022], [-117.0267, 33.00993], [-117.02621, 33.00987], [-117.02595, 33.00955], [-117.02569, 33.00944], [-117.02576, 33.00932], [-117.0259, 33.00914], [-117.02663, 33.00952], [-117.02678, 33.00925], [-117.0269, 33.00896], [-117.02702, 33.00866], [-117.02713, 33.00822], [-117.02757, 33.00777], [-117.02751, 33.00701], [-117.02768, 33.00696], [-117.02795, 33.00752], [-117.02735, 33.00867], [-117.02731, 33.00986], [-117.02804, 33.01051], [-117.02894, 33.01149]]]} | Open Access 1 | 35512 | Poway holding 29 | 23953 | 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 | 8.564 | Poway holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13401 | 13401 | 13400 | {"type": "Polygon", "coordinates": [[[-117.06276, 32.93262], [-117.06259, 32.93285], [-117.06243, 32.93294], [-117.06232, 32.93308], [-117.06211, 32.93322], [-117.06207, 32.93368], [-117.06184, 32.93365], [-117.06165, 32.93359], [-117.06148, 32.93352], [-117.06123, 32.93336], [-117.06172, 32.93277], [-117.06228, 32.93288], [-117.06276, 32.93262]]]} | Open Access 1 | 35513 | Poway holding 27 | 23951 | 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.662 | Poway holding 27 | 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 | |
13416 | 13416 | 13415 | {"type": "Polygon", "coordinates": [[[-117.28517, 33.08411], [-117.28517, 33.08713], [-117.28478, 33.08714], [-117.28429, 33.08718], [-117.28299, 33.08738], [-117.28297, 33.08412], [-117.28517, 33.08411]]]} | Open Access 1 | 35528 | Encinitas holding 29 | 18656 | 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 | 17.436 | Encinitas holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13417 | 13417 | 13416 | {"type": "Polygon", "coordinates": [[[-117.28529, 33.07544], [-117.2852, 33.07638], [-117.2851, 33.07638], [-117.28509, 33.07542], [-117.28506, 33.07538], [-117.28525, 33.0754], [-117.28529, 33.07544]]]} | Open Access 1 | 35529 | Encinitas holding 31 | 18657 | 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 | 0.384 | Encinitas holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13419 | 13419 | 13418 | {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} | Open Access 1 | 35537 | Encinitas holding 36 | 18658 | 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 | 0.044 | Encinitas holding 36 | 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]);