units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 120 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16020 | 16020 | 16019 | {"type": "Polygon", "coordinates": [[[-117.24719, 33.08498], [-117.24511, 33.08569], [-117.24483, 33.08511], [-117.24479, 33.08506], [-117.24465, 33.08473], [-117.24408, 33.08356], [-117.24396, 33.08316], [-117.24407, 33.08242], [-117.24407, 33.08146], [-117.24415, 33.08123], [-117.24416, 33.08092], [-117.24457, 33.08092], [-117.24442, 33.08125], [-117.24448, 33.08142], [-117.24468, 33.08178], [-117.24468, 33.08182], [-117.24491, 33.08223], [-117.24513, 33.0833], [-117.24532, 33.08363], [-117.24561, 33.08401], [-117.24598, 33.0844], [-117.24602, 33.08441], [-117.24619, 33.08461], [-117.24651, 33.08479], [-117.24719, 33.08498]]]} | Open Access 1 | 5079 | La Costa Canyon Open Space | 20752 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 12.952 | La Costa Canyon OS | 0 | Local Recreation Area 3 | 4 | |
15820 | 15820 | 15819 | {"type": "Polygon", "coordinates": [[[-117.30392, 33.09963], [-117.30353, 33.09976], [-117.30314, 33.09969], [-117.30324, 33.09954], [-117.30324, 33.09935], [-117.30314, 33.09914], [-117.30301, 33.09907], [-117.30276, 33.099], [-117.30287, 33.09898], [-117.30372, 33.09898], [-117.30392, 33.09963]]]} | Open Access 1 | 1117 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.277 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
15816 | 15816 | 15815 | {"type": "Polygon", "coordinates": [[[-117.30512, 33.09899], [-117.30508, 33.10086], [-117.30508, 33.10146], [-117.30497, 33.10125], [-117.30494, 33.10114], [-117.30486, 33.10098], [-117.30445, 33.1], [-117.30439, 33.09991], [-117.30399, 33.09898], [-117.30512, 33.09899]]]} | Open Access 1 | 1116 | Batiquitos Drive Open Space | 15863 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.566 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
15656 | 15656 | 15655 | {"type": "MultiPolygon", "coordinates": [[[[-117.30136, 33.12431], [-117.30109, 33.12548], [-117.30099, 33.12581], [-117.3009, 33.12606], [-117.30077, 33.1263], [-117.30063, 33.12653], [-117.30041, 33.12683], [-117.30016, 33.1271], [-117.29988, 33.12736], [-117.29943, 33.12767], [-117.29912, 33.12785], [-117.29879, 33.128], [-117.29844, 33.12813], [-117.29799, 33.12825], [-117.29689, 33.12844], [-117.29653, 33.12854], [-117.29611, 33.12871], [-117.29546, 33.12906], [-117.29516, 33.12919], [-117.29485, 33.1293], [-117.29455, 33.12937], [-117.29393, 33.12948], [-117.29388, 33.12931], [-117.29366, 33.12931], [-117.29348, 33.12914], [-117.2928, 33.12894], [-117.29075, 33.12924], [-117.29021, 33.12955], [-117.29004, 33.12945], [-117.28923, 33.12912], [-117.28822, 33.12843], [-117.2879, 33.12839], [-117.29047, 33.12797], [-117.29037, 33.12753], [-117.29114, 33.12727], [-117.29117, 33.12721], [-117.29105, 33.12678], [-117.29103, 33.12657], [-117.29388, 33.12611], [-117.29434, 33.12505], [-117.29475, 33.12451], [-117.29521, 33.12385], [-117.29436, 33.1232], [-117.29415, 33.12299], [-117.29467, 33.12313], [-117.29552, 33.12331], [-117.29988, 33.12403], [-117.30074, 33.12415], [-117.30085, 33.1242], [-117.30129, 33.12426], [-117.30134, 33.12428], [-117.30136, 33.12431]]], [[[-117.30821, 33.12981], [-117.30818, 33.12985], [-117.30818, 33.12992], [-117.30821, 33.13008], [-117.30827, 33.13574], [-117.30791, 33.13835], [-117.30763, 33.13858], [-117.30741, 33.13879], [-117.30725, 33.13898], [-117.3072, 33.139], [-117.30688, 33.13882], [-117.30658, 33.13862], [-117.30647, 33.13853], [-117.30624, 33.13828], [-117.30605, 33.13801], [-117.30591, 33.13774], [-117.30568, 33.13712], [-117.30553, 33.13682], [-117.30542, 33.13664], [-117.30519, 33.13635], [-117.30492, 33.1361], [-117.30461, 33.13589], [-117.30357, 33.13528], [-117.30323, 33.13506], [-117.30163, 33.13361], [-117.30136, 33.1334], [-117.30105, 33.13321], [-117.30081, 33.13309], [-117.30039, 33.13293], [-117.30012, 33.13286], [-117.29975, 33.13279], [-117.29928, 33.13275], [-117.29891, 33.13276], [-117.29836, 33.13285], [-117.29809, 33.13292], [-117.29774, 33.13304], [-117.29674, 33.13352], [-117.29634, 33.13378], [-117.29605, 33.13401], [-117.29585, 33.1342], [-117.29567, 33.1344], [-117.2954, 33.13476], [-117.29519, 33.13514], [-117.29465, 33.13281], [-117.29201, 33.13101], [-117.29222, 33.13079], [-117.29302, 33.13088], [-117.29334, 33.13079], [-117.29375, 33.13063], [-117.29486, 33.13138], [-117.29564, 33.13095], [-117.29622, 33.13071], [-117.29622, 33.13069], [-117.29569, 33.13037], [-117.29544, 33.13028], [-117.29554, 33.12974], [-117.29521, 33.12948], [-117.29563, 33.1293], [-117.29635, 33.12892], [-117.29665, 33.1288], [-117.29689, 33.12873], [-117.29722, 33.12866], [-117.2982, 33.12849], [-117.29851, 33.12841], [-117.29881, 33.1283], [-117.2992, 33.12813], [-117.29957, 33.12794], [-117.29983, 33.12777], [-117.30012, 33.12755], [-117.30045, 33.12725], [-117.30078, 33.12687], [-117.30079, 33.12685], [-117.30095, 33.12665], [-117.30115, 33.12628], [-117.30133, 33.12584], [-117.30159, 33.1248], [-117.30164, 33.12472], [-117.30169, 33.12449], [-117.30173, 33.12437], [-117.3018, 33.12434], [-117.30193, 33.12432], [-117.30244, 33.12435], [-117.30277, 33.12434], [-117.30376, 33.12426], [-117.30415, 33.12421], [-117.30475, 33.12408], [-117.30523, 33.12395], [-117.30593, 33.12373], [-117.306, 33.12376], [-117.30601, 33.12378], [-117.30639, 33.12491], [-117.30643, 33.12505], [-117.30675, 33.12506], [-117.30722, 33.12647], [-117.30727, 33.12686], [-117.30726, 33.12705], [-117.30712, 33.12705], [-117.30698, 33.12724], [-117.30691, 33.12971], [-117.30713, 33.12967], [-117.3082, 33.12935], [-117.30821, 33.12981]]]]} | Restricted Access 2 | 804 | The Crossings Golf Course | 30002 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 391.552 | The Crossings GC | 0 | Local Recreation Area 3 | 4 | |
15424 | 15424 | 15423 | {"type": "Polygon", "coordinates": [[[-117.30114, 33.13811], [-117.30093, 33.138], [-117.30079, 33.13778], [-117.30076, 33.13744], [-117.3007, 33.13713], [-117.30068, 33.13677], [-117.30099, 33.13627], [-117.3006, 33.13542], [-117.3005, 33.13529], [-117.30039, 33.13527], [-117.30019, 33.13536], [-117.30003, 33.13541], [-117.29985, 33.13543], [-117.29979, 33.13542], [-117.29974, 33.13534], [-117.29966, 33.13527], [-117.29969, 33.13496], [-117.29989, 33.13469], [-117.29992, 33.13447], [-117.30025, 33.13409], [-117.30048, 33.13361], [-117.30079, 33.13334], [-117.30118, 33.13354], [-117.30147, 33.13376], [-117.30217, 33.13439], [-117.30276, 33.13504], [-117.30306, 33.1353], [-117.30332, 33.13548], [-117.30456, 33.13621], [-117.30481, 33.13638], [-117.30497, 33.13653], [-117.30517, 33.13674], [-117.30533, 33.13698], [-117.30546, 33.13723], [-117.30582, 33.13813], [-117.30596, 33.13834], [-117.30623, 33.13864], [-117.30624, 33.13868], [-117.30621, 33.13872], [-117.30606, 33.13881], [-117.30581, 33.13889], [-117.30563, 33.1389], [-117.30496, 33.13888], [-117.30479, 33.1389], [-117.30457, 33.13895], [-117.30055, 33.1388], [-117.30037, 33.13863], [-117.30038, 33.13846], [-117.30101, 33.13828], [-117.30151, 33.13825], [-117.30174, 33.13819], [-117.30179, 33.13803], [-117.3017, 33.13794], [-117.30149, 33.13803], [-117.30114, 33.13811]]]} | Open Access 1 | 46664 | Veterans Memorial Park | 30003 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 49.269 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
15422 | 15422 | 15421 | {"type": "Polygon", "coordinates": [[[-117.34147, 33.16315], [-117.34136, 33.16303], [-117.34116, 33.16316], [-117.34123, 33.16287], [-117.34126, 33.16266], [-117.34126, 33.16249], [-117.34147, 33.16315]]]} | Open Access 1 | 46663 | Oak Park | 29998 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 0.189 | Oak Park | 0 | Local Park 2 | 4 | |
15421 | 15421 | 15420 | {"type": "Polygon", "coordinates": [[[-117.33023, 33.15686], [-117.33022, 33.157], [-117.33015, 33.15709], [-117.33003, 33.1572], [-117.32987, 33.15728], [-117.32972, 33.1573], [-117.3295, 33.15728], [-117.3294, 33.15725], [-117.32929, 33.15717], [-117.32917, 33.15701], [-117.32785, 33.15762], [-117.32731, 33.15675], [-117.32718, 33.15651], [-117.32716, 33.15642], [-117.32727, 33.15627], [-117.3275, 33.15625], [-117.32782, 33.1562], [-117.32795, 33.15615], [-117.32929, 33.15552], [-117.33023, 33.15686]]]} | Restricted Access 2 | 46659 | Magnolia Athletic Field | 31624 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 9.19 | Magnolia Athletic Field | 0 | Local Recreation Area 3 | 4 | |
15420 | 15420 | 15419 | {"type": "Polygon", "coordinates": [[[-117.2429, 33.08001], [-117.24288, 33.08032], [-117.24286, 33.08034], [-117.24286, 33.08075], [-117.24204, 33.08076], [-117.24201, 33.07859], [-117.24207, 33.07859], [-117.24218, 33.07904], [-117.24283, 33.07906], [-117.24279, 33.07988], [-117.2429, 33.08001]]]} | Restricted Access 2 | 46658 | Levante School Park | 29992 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 3.673 | Levante School Park | 0 | Local Park 2 | 4 | |
15419 | 15419 | 15418 | {"type": "Polygon", "coordinates": [[[-117.31703, 33.17107], [-117.3159, 33.17157], [-117.31556, 33.17136], [-117.31645, 33.17091], [-117.31681, 33.17077], [-117.31703, 33.17107]]]} | Open Access 1 | 46652 | Ann D. L'Heureux Dog Park | 29989 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/dog.asp | San Diego 4 | 1.222 | Ann D. L'Heureux Dog Park | 0 | Local Park 2 | 4 |
15418 | 15418 | 15417 | {"type": "Polygon", "coordinates": [[[-117.33206, 33.16323], [-117.33174, 33.16369], [-117.33078, 33.16284], [-117.33123, 33.16249], [-117.33206, 33.16323]]]} | Restricted Access 2 | 46651 | Carlsbad High School Tennis Courts | 32247 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 1.727 | Carlsbad High School Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
15396 | 15396 | 15395 | {"type": "Polygon", "coordinates": [[[-117.27642, 33.10482], [-117.27601, 33.10477], [-117.2759, 33.10472], [-117.27538, 33.10439], [-117.27531, 33.10432], [-117.27516, 33.104], [-117.27491, 33.10395], [-117.27475, 33.10394], [-117.27475, 33.10338], [-117.27481, 33.10333], [-117.27618, 33.1033], [-117.27625, 33.1034], [-117.27624, 33.10399], [-117.27633, 33.10406], [-117.27642, 33.10482]]]} | Restricted Access 2 | 46650 | Aviara Oaks Middle School Park | 31948 | 2399 | Carlsbad Unified School District 1157 | Special District 4 | School District 14 | http://www.carlsbadusd.k12.ca.us/ | Special District 4 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 4.374 | Aviara Oaks Middle School Park | 0 | Local Park 2 | 4 | |
8097 | 8097 | 8096 | {"type": "Polygon", "coordinates": [[[-117.28346, 33.11537], [-117.28295, 33.11572], [-117.28315, 33.11639], [-117.2821, 33.11639], [-117.28209, 33.11605], [-117.28222, 33.11596], [-117.28224, 33.11584], [-117.28218, 33.11576], [-117.2821, 33.11573], [-117.28221, 33.11546], [-117.2822, 33.11545], [-117.28187, 33.11552], [-117.28168, 33.11575], [-117.28157, 33.11574], [-117.28097, 33.11609], [-117.28076, 33.11628], [-117.28034, 33.11639], [-117.2799, 33.11639], [-117.27904, 33.11585], [-117.27902, 33.11438], [-117.28103, 33.11436], [-117.28105, 33.11442], [-117.28112, 33.11447], [-117.28119, 33.11448], [-117.28127, 33.11446], [-117.28133, 33.11442], [-117.28135, 33.11434], [-117.28123, 33.1141], [-117.28121, 33.11394], [-117.2812, 33.11376], [-117.28123, 33.11358], [-117.28131, 33.11332], [-117.28137, 33.11328], [-117.28214, 33.1134], [-117.28341, 33.11348], [-117.28342, 33.11373], [-117.28339, 33.11373], [-117.28329, 33.11397], [-117.28341, 33.11407], [-117.28337, 33.11424], [-117.28339, 33.11512], [-117.28346, 33.11537]]]} | Open Access 1 | 12157 | Aviara Community Park | 15728 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/south/aviara.asp | San Diego 4 | 24.308 | Aviara Community Park | 0 | Local Park 2 | 4 |
7815 | 7815 | 7814 | {"type": "Polygon", "coordinates": [[[-117.35386, 33.16562], [-117.35275, 33.16562], [-117.35275, 33.16525], [-117.35327, 33.16513], [-117.35386, 33.16562]]]} | Open Access 1 | 12484 | Maxton Brown Park | 21968 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/brown.asp | San Diego 4 | 0.947 | Maxton Brown Park | 0 | Local Park 2 | 4 |
7616 | 7616 | 7615 | {"type": "Polygon", "coordinates": [[[-117.26666, 33.13637], [-117.26647, 33.13716], [-117.26627, 33.13719], [-117.26603, 33.13729], [-117.26594, 33.13735], [-117.26581, 33.13752], [-117.26568, 33.13736], [-117.26537, 33.1374], [-117.26513, 33.13702], [-117.2651, 33.13689], [-117.26567, 33.13602], [-117.26591, 33.13616], [-117.26634, 33.1363], [-117.26666, 33.13637]]]} | Open Access 1 | 47629 | Carlsbad Skatepark | 31368 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/skatepark.asp | San Diego 4 | 3.643 | Carlsbad Skatepark | None 634 | ||
6757 | 6757 | 6756 | {"type": "Polygon", "coordinates": [[[-117.24428, 33.09175], [-117.24058, 33.09032], [-117.24075, 33.08948], [-117.24003, 33.08937], [-117.23998, 33.08931], [-117.24017, 33.08891], [-117.24038, 33.08895], [-117.24047, 33.08869], [-117.2408, 33.08877], [-117.2407, 33.08906], [-117.24154, 33.0893], [-117.24205, 33.08873], [-117.24215, 33.08879], [-117.24246, 33.08889], [-117.2425, 33.08893], [-117.24257, 33.08896], [-117.24286, 33.08959], [-117.24286, 33.08963], [-117.24347, 33.09012], [-117.24426, 33.09013], [-117.24428, 33.09175]]]} | Open Access 1 | 5135 | La Costa Canyon Park | 20753 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/south/canyon.asp | San Diego 4 | 15.802 | La Costa Canyon Park | 0 | Local Park 2 | 4 |
6740 | 6740 | 6739 | {"type": "Polygon", "coordinates": [[[-117.23721, 33.07583], [-117.23678, 33.07671], [-117.23607, 33.07685], [-117.236, 33.07666], [-117.2357, 33.07677], [-117.23537, 33.07678], [-117.2347, 33.07685], [-117.23417, 33.07688], [-117.23297, 33.07706], [-117.2327, 33.07729], [-117.23225, 33.07746], [-117.23209, 33.07757], [-117.23195, 33.07783], [-117.23189, 33.07777], [-117.23037, 33.07715], [-117.23046, 33.07689], [-117.23071, 33.07649], [-117.23087, 33.0763], [-117.23112, 33.07604], [-117.23208, 33.07538], [-117.23237, 33.07522], [-117.23265, 33.07509], [-117.23301, 33.07498], [-117.23337, 33.07492], [-117.23384, 33.07488], [-117.23441, 33.07493], [-117.23497, 33.07506], [-117.23721, 33.07583]]]} | Open Access 1 | 5078 | Stagecoach Community Park | 30001 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/south/stagecoach.asp | San Diego 4 | 28.423 | Stagecoach Community Park | 0 | Local Park 2 | 4 |
6686 | 6686 | 6685 | {"type": "Polygon", "coordinates": [[[-117.29824, 33.13313], [-117.29812, 33.13667], [-117.29552, 33.13657], [-117.29529, 33.13554], [-117.29538, 33.1353], [-117.29548, 33.13507], [-117.29561, 33.13484], [-117.29582, 33.13456], [-117.29599, 33.13436], [-117.29626, 33.13411], [-117.29655, 33.13389], [-117.29678, 33.13374], [-117.29768, 33.13329], [-117.29796, 33.13319], [-117.29824, 33.13313]]]} | Open Access 1 | 48411 | Veterans Park Preserve | 32977 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/civicax/filebank/blobdload.aspx?BlobID=37992 | San Diego 4 | 19.573 | Veterans Park Preserve | 0 | Local Conservation Area 4 | 2 |
6675 | 6675 | 6674 | {"type": "Polygon", "coordinates": [[[-117.30179, 33.13802], [-117.30174, 33.13819], [-117.30151, 33.13825], [-117.30101, 33.13828], [-117.30039, 33.13846], [-117.30037, 33.13863], [-117.30055, 33.1388], [-117.29992, 33.13877], [-117.30002, 33.13674], [-117.29812, 33.13667], [-117.29824, 33.13312], [-117.29871, 33.13306], [-117.2992, 33.13303], [-117.2995, 33.13305], [-117.29988, 33.13309], [-117.30021, 33.13316], [-117.30049, 33.13324], [-117.30079, 33.13334], [-117.30047, 33.13362], [-117.30025, 33.13408], [-117.29992, 33.13447], [-117.29989, 33.13469], [-117.29968, 33.13496], [-117.29966, 33.13527], [-117.29974, 33.13534], [-117.29979, 33.13542], [-117.29986, 33.13543], [-117.30003, 33.13541], [-117.30019, 33.13536], [-117.3004, 33.13527], [-117.3005, 33.13529], [-117.30059, 33.13542], [-117.30099, 33.13627], [-117.30068, 33.13678], [-117.3007, 33.13713], [-117.30076, 33.13745], [-117.30079, 33.13778], [-117.30093, 33.13801], [-117.30114, 33.13811], [-117.30148, 33.13803], [-117.30171, 33.13794], [-117.30179, 33.13802]]]} | Open Access 1 | 48409 | Macario Canyon Preserve | 32975 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | San Diego 4 | 24.84 | Macario Canyon Preserve | 0 | Local Conservation Area 4 | 2 | |
6431 | 6431 | 6430 | {"type": "Polygon", "coordinates": [[[-117.23992, 33.11868], [-117.23968, 33.12004], [-117.23953, 33.12006], [-117.23882, 33.12], [-117.23835, 33.11991], [-117.23795, 33.12013], [-117.23771, 33.12034], [-117.23735, 33.12062], [-117.23697, 33.12084], [-117.23701, 33.12088], [-117.23698, 33.12091], [-117.23632, 33.12138], [-117.23525, 33.12035], [-117.23528, 33.12033], [-117.23525, 33.12019], [-117.23525, 33.12012], [-117.23532, 33.11989], [-117.2357, 33.11951], [-117.23574, 33.11935], [-117.23573, 33.11929], [-117.23562, 33.11916], [-117.23573, 33.11901], [-117.23569, 33.11894], [-117.23563, 33.11888], [-117.23551, 33.11886], [-117.23545, 33.11884], [-117.23531, 33.11875], [-117.23541, 33.11845], [-117.23546, 33.11814], [-117.23543, 33.11795], [-117.23535, 33.11772], [-117.23527, 33.11758], [-117.2353, 33.11753], [-117.23553, 33.11743], [-117.23577, 33.11762], [-117.23577, 33.11765], [-117.23599, 33.11774], [-117.23602, 33.11778], [-117.23625, 33.11783], [-117.23627, 33.11786], [-117.23636, 33.11788], [-117.23655, 33.11782], [-117.23665, 33.11761], [-117.23783, 33.11779], [-117.23816, 33.11782], [-117.23812, 33.11828], [-117.23831, 33.11843], [-117.23851, 33.11847], [-117.23868, 33.11847], [-117.23992, 33.11868]]]} | Open Access 1 | 1950 | Leo Carillo Ranch Historic Park | 21165 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/south/carrillo.asp | San Diego 4 | 27.397 | Leo Carillo Ranch Historic Park | 0 | Local Historic or Cultural Area 19 | 4 |
6426 | 6426 | 6425 | {"type": "Polygon", "coordinates": [[[-117.28832, 33.16918], [-117.28816, 33.16969], [-117.288, 33.17008], [-117.28762, 33.17027], [-117.28755, 33.17053], [-117.28807, 33.17132], [-117.28817, 33.17188], [-117.28809, 33.17239], [-117.28778, 33.17235], [-117.28743, 33.17205], [-117.28705, 33.17199], [-117.287, 33.17181], [-117.28663, 33.17164], [-117.28607, 33.17149], [-117.28579, 33.17184], [-117.28571, 33.17242], [-117.2854, 33.17253], [-117.28518, 33.17298], [-117.285, 33.17422], [-117.2844, 33.17457], [-117.28428, 33.17416], [-117.28426, 33.17417], [-117.28425, 33.17447], [-117.28389, 33.17381], [-117.28389, 33.17324], [-117.28302, 33.17298], [-117.2815, 33.17354], [-117.2809, 33.17391], [-117.28089, 33.17412], [-117.28031, 33.17422], [-117.27957, 33.17406], [-117.27956, 33.17577], [-117.27527, 33.17577], [-117.27526, 33.17718], [-117.27095, 33.17716], [-117.27085, 33.1685], [-117.27953, 33.16855], [-117.27955, 33.16947], [-117.28386, 33.16947], [-117.28386, 33.16973], [-117.28435, 33.16972], [-117.28457, 33.16956], [-117.28458, 33.16946], [-117.28468, 33.16947], [-117.28473, 33.16932], [-117.28511, 33.16913], [-117.28522, 33.16882], [-117.28617, 33.16804], [-117.28832, 33.16918]]]} | Open Access 1 | 1933 | Lake Calavera Preserve | 2079 | 1045 | Carlsbad, City of 123 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/default.asp | City 2 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/open/trails/talk/calavera.asp | San Diego 4 | 262.295 | Lake Calavera Preserve | 0 | Local Conservation Area 4 | 2 |
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]);