units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
38 rows where ACCESS_TYP = 3, COUNTY = 4 and MNG_AG_TYP = 2 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, LABEL_NAME, GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | 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 | 1.217 | 0 | Local Other or Unknown 14 | 4 | ||
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | 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 | 0.273 | 0 | Local Other or Unknown 14 | 4 | ||
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | 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 | 0.196 | 0 | Local Other or Unknown 14 | 4 | ||
4537 | 4537 | 4536 | {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} | No Public Access 3 | 19907 | 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 | 0.035 | 0 | Local Other or Unknown 14 | 4 | ||
4785 | 4785 | 4784 | {"type": "Polygon", "coordinates": [[[-117.23137, 32.88833], [-117.22878, 32.89057], [-117.22879, 32.89385], [-117.22675, 32.89645], [-117.22675, 32.89619], [-117.22726, 32.89551], [-117.22708, 32.8954], [-117.22721, 32.89514], [-117.22753, 32.89435], [-117.22772, 32.89381], [-117.22795, 32.89294], [-117.22797, 32.89271], [-117.22797, 32.89157], [-117.22795, 32.89107], [-117.22798, 32.89083], [-117.22816, 32.89009], [-117.22833, 32.89009], [-117.22872, 32.88902], [-117.22917, 32.88808], [-117.22989, 32.8883], [-117.23011, 32.88786], [-117.23073, 32.88808], [-117.23137, 32.88833]]]} | No Public Access 3 | 47655 | 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 | 20.801 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
6608 | 6608 | 6607 | {"type": "Polygon", "coordinates": [[[-117.03964, 32.5565], [-117.03952, 32.55674], [-117.03854, 32.5569], [-117.03824, 32.55697], [-117.03804, 32.55697], [-117.03763, 32.55706], [-117.03762, 32.55704], [-117.03717, 32.55717], [-117.03738, 32.55766], [-117.03743, 32.55783], [-117.03746, 32.55795], [-117.03747, 32.55822], [-117.03369, 32.55819], [-117.03357, 32.55452], [-117.03776, 32.55454], [-117.03928, 32.55638], [-117.03964, 32.5565]]]} | No Public Access 3 | 4168 | Beyer Community Park | 30224 | 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 | 43.828 | Beyer Community Park | 0 | Local Park 2 | 4 | |
16217 | 16217 | 16216 | {"type": "Polygon", "coordinates": [[[-117.14604, 33.16753], [-117.14568, 33.16832], [-117.14568, 33.16839], [-117.14137, 33.16834], [-117.1414, 33.16739], [-117.14061, 33.16658], [-117.14096, 33.16596], [-117.14048, 33.16411], [-117.14004, 33.1621], [-117.14023, 33.16217], [-117.14033, 33.16218], [-117.14079, 33.16211], [-117.1411, 33.1621], [-117.14137, 33.16215], [-117.14156, 33.16223], [-117.14169, 33.16234], [-117.14177, 33.16245], [-117.14184, 33.16259], [-117.14188, 33.16273], [-117.14187, 33.16285], [-117.14183, 33.16297], [-117.14178, 33.16306], [-117.14167, 33.16317], [-117.14168, 33.16329], [-117.14171, 33.1633], [-117.14189, 33.1633], [-117.1421, 33.16337], [-117.14218, 33.16342], [-117.1423, 33.16353], [-117.14243, 33.16362], [-117.14253, 33.16364], [-117.14279, 33.16359], [-117.14292, 33.1636], [-117.14302, 33.16367], [-117.14316, 33.16387], [-117.14335, 33.16399], [-117.14343, 33.16402], [-117.14354, 33.16401], [-117.14409, 33.16385], [-117.14429, 33.16385], [-117.14558, 33.16436], [-117.14574, 33.16445], [-117.14582, 33.16446], [-117.14584, 33.16451], [-117.14584, 33.16519], [-117.14582, 33.16537], [-117.14581, 33.166], [-117.14596, 33.16649], [-117.14598, 33.16664], [-117.14597, 33.16709], [-117.14604, 33.16753]]]} | No Public Access 3 | 44872 | City of Escondido Open Space | 17311 | 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 | 63.739 | City of Escondido OS | 0 | Local Recreation Area 3 | 4 | |
16219 | 16219 | 16218 | {"type": "Polygon", "coordinates": [[[-117.17233, 33.2342], [-117.17202, 33.23604], [-117.17189, 33.23648], [-117.17178, 33.23675], [-117.17165, 33.23702], [-117.17032, 33.23703], [-117.1702, 33.23718], [-117.17023, 33.23751], [-117.17011, 33.23751], [-117.16988, 33.23783], [-117.16972, 33.23784], [-117.16977, 33.2384], [-117.16849, 33.23842], [-117.16846, 33.24102], [-117.16803, 33.24124], [-117.16763, 33.24094], [-117.16776, 33.24042], [-117.16769, 33.2402], [-117.16743, 33.23991], [-117.16592, 33.23931], [-117.16579, 33.23935], [-117.16431, 33.23922], [-117.16405, 33.23994], [-117.16386, 33.23992], [-117.16381, 33.23961], [-117.16384, 33.23934], [-117.15908, 33.23938], [-117.15804, 33.23852], [-117.15919, 33.23818], [-117.15945, 33.23775], [-117.15995, 33.23749], [-117.16145, 33.23719], [-117.16196, 33.23581], [-117.1627, 33.23526], [-117.16318, 33.23561], [-117.16327, 33.23494], [-117.16638, 33.23486], [-117.16638, 33.23119], [-117.16608, 33.23118], [-117.16622, 33.2307], [-117.16638, 33.23055], [-117.16638, 33.23112], [-117.16644, 33.23112], [-117.16649, 33.23108], [-117.16651, 33.23101], [-117.16644, 33.23081], [-117.16645, 33.23065], [-117.16653, 33.23046], [-117.16659, 33.23041], [-117.16665, 33.23038], [-117.16671, 33.23037], [-117.16745, 33.2305], [-117.16762, 33.2305], [-117.16779, 33.23047], [-117.1683, 33.23026], [-117.16876, 33.22996], [-117.16893, 33.22982], [-117.16899, 33.22975], [-117.1691, 33.22972], [-117.16919, 33.22975], [-117.1693, 33.22992], [-117.16944, 33.23004], [-117.16958, 33.23012], [-117.16978, 33.23017], [-117.16979, 33.23023], [-117.16989, 33.23025], [-117.16996, 33.23029], [-117.17, 33.23033], [-117.17008, 33.23044], [-117.17016, 33.23051], [-117.17022, 33.23053], [-117.17059, 33.23058], [-117.1706, 33.23248], [-117.17094, 33.2325], [-117.17188, 33.23359], [-117.17209, 33.23384], [-117.17201, 33.23419], [-117.17233, 33.2342]]]} | No Public Access 3 | 44881 | City of Oceanside Open Space | 17323 | 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 | San Diego 4 | 175.69 | City of Oceanside OS | 0 | Local Recreation Area 3 | 4 | |
7819 | 7819 | 7818 | {"type": "Polygon", "coordinates": [[[-117.03972, 33.04402], [-117.03943, 33.0444], [-117.03888, 33.04486], [-117.03845, 33.04501], [-117.03841, 33.04513], [-117.03859, 33.04512], [-117.03865, 33.04535], [-117.03844, 33.04562], [-117.03814, 33.04572], [-117.03826, 33.04578], [-117.03836, 33.04591], [-117.03828, 33.04624], [-117.03818, 33.04641], [-117.03827, 33.04668], [-117.03823, 33.04682], [-117.03792, 33.04698], [-117.03759, 33.047], [-117.03783, 33.04722], [-117.03797, 33.04745], [-117.03789, 33.048], [-117.03771, 33.04806], [-117.0377, 33.04816], [-117.03778, 33.04815], [-117.03782, 33.04825], [-117.03805, 33.04818], [-117.03825, 33.0486], [-117.03828, 33.04894], [-117.03825, 33.04912], [-117.03773, 33.05005], [-117.03685, 33.05007], [-117.03641, 33.0508], [-117.03551, 33.05159], [-117.03526, 33.05167], [-117.03535, 33.05175], [-117.03535, 33.05196], [-117.03492, 33.05207], [-117.03493, 33.05208], [-117.03535, 33.05209], [-117.03564, 33.05265], [-117.03564, 33.05294], [-117.03546, 33.0533], [-117.03525, 33.05341], [-117.03491, 33.05349], [-117.03449, 33.05379], [-117.03405, 33.05399], [-117.03372, 33.05402], [-117.03355, 33.05395], [-117.0332, 33.0535], [-117.03299, 33.0536], [-117.03251, 33.05366], [-117.0322, 33.05358], [-117.0319, 33.05323], [-117.0317, 33.05276], [-117.03172, 33.0526], [-117.03161, 33.05254], [-117.03152, 33.05235], [-117.03142, 33.05222], [-117.03121, 33.05205], [-117.03118, 33.05189], [-117.031, 33.05176], [-117.03082, 33.05168], [-117.03078, 33.05199], [-117.03021, 33.05221], [-117.03018, 33.05235], [-117.03005, 33.05247], [-117.0298, 33.05251], [-117.02974, 33.05266], [-117.02965, 33.05275], [-117.02977, 33.05283], [-117.02994, 33.05303], [-117.02985, 33.05319], [-117.03003, 33.0532], [-117.03029, 33.05356], [-117.02997, 33.05366], [-117.03029, 33.05384], [-117.03015, 33.05422], [-117.02991, 33.05429], [-117.03009, 33.05449], [-117.0301, 33.0548], [-117.02958, 33.05524], [-117.02954, 33.05553], [-117.02843, 33.05665], [-117.02719, 33.05498], [-117.02941, 33.05187], [-117.02865, 33.05038], [-117.02823, 33.05039], [-117.02836, 33.05023], [-117.0285, 33.04996], [-117.02865, 33.04978], [-117.03273, 33.04973], [-117.03274, 33.04972], [-117.0327, 33.04686], [-117.03187, 33.04596], [-117.03187, 33.04407], [-117.0268, 33.04408], [-117.02681, 33.04403], [-117.02936, 33.04402], [-117.02925, 33.04297], [-117.02982, 33.0424], [-117.03205, 33.04177], [-117.03183, 33.03683], [-117.03128, 33.03703], [-117.03115, 33.03705], [-117.03105, 33.03702], [-117.03078, 33.03701], [-117.03029, 33.03705], [-117.03004, 33.03693], [-117.03, 33.03687], [-117.02993, 33.03669], [-117.02962, 33.03636], [-117.0295, 33.03605], [-117.02942, 33.03576], [-117.02934, 33.03565], [-117.02929, 33.03539], [-117.02918, 33.03537], [-117.0287, 33.03495], [-117.02858, 33.03483], [-117.02838, 33.03472], [-117.02919, 33.03406], [-117.02919, 33.03422], [-117.02916, 33.03453], [-117.02944, 33.03467], [-117.03002, 33.03461], [-117.03033, 33.03469], [-117.03025, 33.03518], [-117.02965, 33.03624], [-117.03035, 33.03686], [-117.03087, 33.03678], [-117.03125, 33.0362], [-117.03135, 33.03618], [-117.0315, 33.03609], [-117.03161, 33.03599], [-117.03171, 33.03587], [-117.03179, 33.03561], [-117.03179, 33.03547], [-117.03175, 33.03535], [-117.03168, 33.0352], [-117.03157, 33.03508], [-117.03066, 33.03436], [-117.03054, 33.03421], [-117.03048, 33.03405], [-117.03071, 33.034], [-117.03078, 33.03386], [-117.0313, 33.03387], [-117.03106, 33.03315], [-117.03106, 33.03288], [-117.03202, 33.03289], [-117.03187, 33.03648], [-117.03222, 33.04407], [-117.03972, 33.04402]]]} | No Public Access 3 | 45249 | City of Poway Open Space | 17327 | 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 | 193.801 | City of Poway OS | 0 | Local Recreation Area 3 | 4 | |
10005 | 10005 | 10004 | {"type": "Polygon", "coordinates": [[[-117.13531, 32.80963], [-117.13296, 32.80967], [-117.13295, 32.80886], [-117.13279, 32.80885], [-117.13274, 32.80882], [-117.13263, 32.8087], [-117.13257, 32.80854], [-117.13257, 32.80843], [-117.13265, 32.80791], [-117.13264, 32.80786], [-117.1326, 32.8078], [-117.13254, 32.80778], [-117.13225, 32.80775], [-117.13215, 32.80763], [-117.13295, 32.80762], [-117.13296, 32.80837], [-117.13529, 32.80833], [-117.13531, 32.80963]]]} | No Public Access 3 | 47974 | City of San Diego Open Space | 32304 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 9.034 | City of San Diego OS | 0 | Local Recreation Area 3 | 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 | |
7628 | 7628 | 7627 | {"type": "Polygon", "coordinates": [[[-117.15123, 33.13075], [-117.14933, 33.13075], [-117.14897, 33.13165], [-117.14916, 33.13197], [-117.15033, 33.13376], [-117.14836, 33.13491], [-117.14827, 33.13106], [-117.14832, 33.12938], [-117.14827, 33.12783], [-117.14921, 33.12832], [-117.14932, 33.12837], [-117.14963, 33.12845], [-117.15012, 33.12851], [-117.15039, 33.12859], [-117.15064, 33.12873], [-117.15083, 33.12889], [-117.15099, 33.12911], [-117.15109, 33.12937], [-117.15123, 33.13075]]]} | No Public Access 3 | 47623 | La Moree Park | 31359 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 28.883 | La Moree Park | 0 | Local Park 2 | 4 | |
5384 | 5384 | 5383 | {"type": "MultiPolygon", "coordinates": [[[[-116.68414, 32.63592], [-116.68408, 32.63754], [-116.68186, 32.63754], [-116.68193, 32.63587], [-116.68414, 32.63592]]], [[[-116.73738, 32.62107], [-116.72053, 32.62112], [-116.72052, 32.62207], [-116.72052, 32.62295], [-116.7117, 32.62354], [-116.71149, 32.62647], [-116.70719, 32.6268], [-116.70737, 32.63295], [-116.69486, 32.63301], [-116.6948, 32.63927], [-116.69518, 32.64285], [-116.69112, 32.64286], [-116.69177, 32.64642], [-116.68717, 32.64646], [-116.68654, 32.64172], [-116.68619, 32.63925], [-116.68626, 32.63596], [-116.68515, 32.63593], [-116.6852, 32.63414], [-116.68522, 32.63386], [-116.68629, 32.63392], [-116.68627, 32.63595], [-116.69052, 32.63602], [-116.6907, 32.62656], [-116.69491, 32.62661], [-116.69487, 32.61949], [-116.69897, 32.61962], [-116.69898, 32.61612], [-116.70769, 32.61631], [-116.71809, 32.61565], [-116.71841, 32.61579], [-116.71976, 32.61606], [-116.72042, 32.61573], [-116.72048, 32.61573], [-116.7205, 32.61766], [-116.72724, 32.61758], [-116.72721, 32.61799], [-116.72733, 32.61851], [-116.72734, 32.61863], [-116.7274, 32.6188], [-116.72749, 32.61894], [-116.7276, 32.61905], [-116.72772, 32.61914], [-116.72798, 32.61926], [-116.72822, 32.61931], [-116.72844, 32.61931], [-116.72863, 32.61927], [-116.72879, 32.61922], [-116.72899, 32.6191], [-116.72916, 32.61894], [-116.72964, 32.61831], [-116.73109, 32.61792], [-116.73167, 32.61772], [-116.73243, 32.61755], [-116.73313, 32.61755], [-116.73314, 32.61739], [-116.73495, 32.61697], [-116.73551, 32.61686], [-116.73599, 32.6168], [-116.73648, 32.61676], [-116.737, 32.61675], [-116.73737, 32.61677], [-116.73738, 32.62107]]], [[[-116.73102, 32.61755], [-116.72988, 32.61781], [-116.72962, 32.6179], [-116.72943, 32.61801], [-116.72935, 32.61808], [-116.72835, 32.61869], [-116.72789, 32.61859], [-116.72763, 32.61823], [-116.72768, 32.61763], [-116.72773, 32.61758], [-116.73102, 32.61755]]], [[[-116.73736, 32.61645], [-116.73617, 32.61654], [-116.73521, 32.61659], [-116.73314, 32.61707], [-116.73303, 32.61407], [-116.73736, 32.61399], [-116.73736, 32.61645]]]]} | No Public Access 3 | 7400 | MSCP Open Space Preserve Land | 22572 | 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 | 1276.75 | MSCP OSP Land | 0 | Local Conservation Area 4 | 2 | |
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 | |
3846 | 3846 | 3845 | {"type": "Polygon", "coordinates": [[[-117.22388, 32.93759], [-117.22376, 32.93764], [-117.22348, 32.9376], [-117.22333, 32.93761], [-117.22215, 32.93794], [-117.22194, 32.93802], [-117.22151, 32.93822], [-117.22151, 32.93456], [-117.22388, 32.93457], [-117.22388, 32.93759]]]} | No Public Access 3 | 46811 | Neighborhood 8 Neighborhood Park | 30272 | 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 | 19.773 | Neighborhood 8 Neighborhood Park | 0 | Local Park 2 | 4 | |
10000 | 10000 | 9999 | {"type": "Polygon", "coordinates": [[[-117.00123, 32.56466], [-117.00121, 32.56728], [-117.00107, 32.56728], [-117.00106, 32.56732], [-117.00068, 32.56736], [-117.00055, 32.56745], [-117.00053, 32.56778], [-117.00042, 32.56807], [-116.99905, 32.56804], [-116.99908, 32.56463], [-117.00123, 32.56466]]]} | No Public Access 3 | 47970 | Otay Mesa Open Space | 32281 | 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.649 | Otay Mesa OS | 0 | Local Recreation Area 3 | 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 |
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]);