units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where COUNTY = 4 and MNG_AGENCY = 120 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
6087 | 6087 | 6086 | {"type": "Polygon", "coordinates": [[[-117.30606, 33.10595], [-117.30582, 33.10598], [-117.30555, 33.10596], [-117.30562, 33.10551], [-117.30557, 33.10548], [-117.30521, 33.10539], [-117.30525, 33.105], [-117.30526, 33.10463], [-117.30605, 33.10448], [-117.30606, 33.10595]]]} | Open Access 1 | 1113 | 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 | 2.468 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
6129 | 6129 | 6128 | {"type": "Polygon", "coordinates": [[[-117.30647, 33.10234], [-117.30617, 33.10247], [-117.30636, 33.10281], [-117.30617, 33.10282], [-117.30617, 33.10266], [-117.30508, 33.10086], [-117.30526, 33.1008], [-117.30538, 33.10115], [-117.3057, 33.10108], [-117.30542, 33.10119], [-117.30544, 33.10127], [-117.3055, 33.10135], [-117.30588, 33.10197], [-117.30617, 33.10185], [-117.30619, 33.10187], [-117.30588, 33.10201], [-117.30614, 33.10245], [-117.30645, 33.10232], [-117.30647, 33.10234]]]} | Open Access 1 | 1114 | 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 | 0.715 | Batiquitos Drive OS | 0 | Local Recreation Area 3 | 4 | |
6130 | 6130 | 6129 | {"type": "Polygon", "coordinates": [[[-117.30489, 33.1026], [-117.30484, 33.10263], [-117.30464, 33.10265], [-117.30424, 33.1026], [-117.30451, 33.10256], [-117.30459, 33.10251], [-117.30466, 33.10246], [-117.3047, 33.1024], [-117.30471, 33.1023], [-117.30467, 33.10201], [-117.30452, 33.10151], [-117.30442, 33.10129], [-117.30412, 33.10081], [-117.3039, 33.10085], [-117.30378, 33.10059], [-117.30402, 33.10049], [-117.30403, 33.10047], [-117.30422, 33.1004], [-117.30466, 33.10131], [-117.30467, 33.10135], [-117.30481, 33.10171], [-117.30487, 33.10193], [-117.30489, 33.10221], [-117.3049, 33.10257], [-117.30489, 33.1026]]]} | Open Access 1 | 1115 | 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.598 | 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 | |
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 | |
6024 | 6024 | 6023 | {"type": "Polygon", "coordinates": [[[-117.29374, 33.13929], [-117.29267, 33.1393], [-117.29229, 33.13926], [-117.29214, 33.13922], [-117.29185, 33.13912], [-117.29165, 33.139], [-117.29149, 33.13887], [-117.29129, 33.13865], [-117.2935, 33.13738], [-117.29374, 33.13929]]]} | Open Access 1 | 828 | Business Park Recreation Facility | 16541 | 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 | 7.167 | Business Park Rec. Facility | 0 | Local Recreation Area 3 | 4 | |
680 | 680 | 679 | {"type": "Polygon", "coordinates": [[[-117.23306, 33.09171], [-117.232, 33.09268], [-117.23089, 33.09223], [-117.23225, 33.09118], [-117.23263, 33.0914], [-117.23306, 33.09171]]]} | Open Access 1 | 5136 | Cadencia Park | 16652 | 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/cadencia.asp | San Diego 4 | 4.028 | Cadencia Park | 0 | Local Park 2 | 4 |
1595 | 1595 | 1594 | {"type": "Polygon", "coordinates": [[[-117.33591, 33.13338], [-117.33487, 33.13375], [-117.33448, 33.13298], [-117.33535, 33.13267], [-117.3354, 33.13267], [-117.33591, 33.13338]]]} | Open Access 1 | 12167 | Cannon Park | 16804 | 6076 | San Diego Gas and Electric 389 | Private 7 | Utility 21 | http://www.sdge.com/ | Private 14 | 1045 | Carlsbad, City of 120 | City 2 | City Agency 2 | http://www.carlsbadca.gov/services/depts/parks/facilities/north/cannon.asp | San Diego 4 | 2.282 | Cannon Park | 0 | Local Park 2 | 4 |
5215 | 5215 | 5214 | {"type": "Polygon", "coordinates": [[[-117.34113, 33.15608], [-117.34183, 33.15694], [-117.34184, 33.15698], [-117.34182, 33.15701], [-117.34113, 33.15742], [-117.34108, 33.15742], [-117.34104, 33.1574], [-117.34033, 33.15654], [-117.34113, 33.15608]]]} | Open Access 1 | 816 | Chase Field | 17153 | 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 | 2.723 | Chase Field | 0 | Local Recreation Area 3 | 4 | |
5584 | 5584 | 5583 | {"type": "Polygon", "coordinates": [[[-117.32697, 33.13106], [-117.32664, 33.13118], [-117.32652, 33.13085], [-117.32636, 33.13054], [-117.32613, 33.13023], [-117.32591, 33.12999], [-117.32628, 33.12989], [-117.32697, 33.13106]]]} | Open Access 1 | 44150 | City Park | 17341 | 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.04 | City Park | 0 | Local Park 2 | 4 | |
841 | 841 | 840 | {"type": "Polygon", "coordinates": [[[-117.34054, 33.1609], [-117.34037, 33.16111], [-117.33975, 33.16146], [-117.33934, 33.16146], [-117.33932, 33.16072], [-117.33926, 33.16053], [-117.33917, 33.16033], [-117.33914, 33.16017], [-117.33915, 33.16016], [-117.33913, 33.1584], [-117.33921, 33.1584], [-117.33931, 33.15844], [-117.33997, 33.15983], [-117.34002, 33.15983], [-117.34054, 33.1609]]]} | Open Access 1 | 4942 | Holiday Park | 20031 | 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/holiday.asp | San Diego 4 | 5.967 | Holiday Park | 0 | Local Park 2 | 4 |
6127 | 6127 | 6126 | {"type": "MultiPolygon", "coordinates": [[[[-117.33676, 33.17635], [-117.33674, 33.1764], [-117.3367, 33.17642], [-117.3362, 33.17656], [-117.33598, 33.17665], [-117.33554, 33.17688], [-117.3352, 33.177], [-117.33499, 33.17707], [-117.33458, 33.17713], [-117.33417, 33.17713], [-117.33377, 33.17709], [-117.33296, 33.17692], [-117.33276, 33.17689], [-117.33266, 33.17686], [-117.33251, 33.17683], [-117.33247, 33.17684], [-117.33233, 33.17679], [-117.3316, 33.17666], [-117.33159, 33.17564], [-117.33151, 33.17505], [-117.3316, 33.17499], [-117.33175, 33.17481], [-117.33187, 33.17451], [-117.33186, 33.17444], [-117.33365, 33.17448], [-117.33439, 33.17413], [-117.33528, 33.17382], [-117.33556, 33.17374], [-117.33609, 33.175], [-117.33615, 33.17522], [-117.33622, 33.17538], [-117.33638, 33.17569], [-117.3365, 33.17584], [-117.33666, 33.1761], [-117.33676, 33.17635]]], [[[-117.33511, 33.17306], [-117.33485, 33.17315], [-117.33474, 33.17311], [-117.33471, 33.17314], [-117.33466, 33.17314], [-117.33443, 33.17353], [-117.33417, 33.17411], [-117.33337, 33.17427], [-117.33302, 33.17419], [-117.33299, 33.17406], [-117.33292, 33.17392], [-117.33285, 33.17358], [-117.33285, 33.17313], [-117.333, 33.17315], [-117.33355, 33.17287], [-117.33322, 33.17244], [-117.33341, 33.17217], [-117.33428, 33.17257], [-117.33443, 33.17265], [-117.33449, 33.17275], [-117.33487, 33.17259], [-117.33488, 33.17261], [-117.33482, 33.17265], [-117.33475, 33.17272], [-117.33471, 33.17286], [-117.33472, 33.1729], [-117.33488, 33.17303], [-117.33498, 33.17304], [-117.33508, 33.17303], [-117.33511, 33.17306]]], [[[-117.34318, 33.1761], [-117.34293, 33.17627], [-117.3428, 33.17638], [-117.34193, 33.17745], [-117.34172, 33.17766], [-117.34146, 33.17782], [-117.3413, 33.17788], [-117.34107, 33.17796], [-117.34068, 33.17805], [-117.34061, 33.17803], [-117.3404, 33.1776], [-117.34014, 33.1773], [-117.33934, 33.1766], [-117.3389, 33.17637], [-117.33869, 33.17637], [-117.33846, 33.17631], [-117.33796, 33.17624], [-117.33762, 33.17623], [-117.33739, 33.17625], [-117.33705, 33.1763], [-117.337, 33.1763], [-117.33696, 33.17627], [-117.33682, 33.17591], [-117.33672, 33.17572], [-117.33655, 33.17549], [-117.3364, 33.1752], [-117.33633, 33.17501], [-117.33629, 33.17484], [-117.33627, 33.17465], [-117.33627, 33.17433], [-117.33624, 33.1741], [-117.3361, 33.17354], [-117.33652, 33.1734], [-117.33609, 33.17237], [-117.33562, 33.17162], [-117.3348, 33.17057], [-117.33461, 33.17064], [-117.3343, 33.16987], [-117.33416, 33.16962], [-117.33402, 33.16943], [-117.33371, 33.16913], [-117.33349, 33.16896], [-117.33324, 33.16881], [-117.33385, 33.16881], [-117.33549, 33.17074], [-117.33567, 33.17092], [-117.33607, 33.1714], [-117.3368, 33.17244], [-117.33704, 33.17283], [-117.33727, 33.17327], [-117.33753, 33.17381], [-117.33758, 33.17388], [-117.33751, 33.17393], [-117.33846, 33.17505], [-117.33925, 33.17548], [-117.34006, 33.17602], [-117.34007, 33.17606], [-117.34318, 33.1761]]], [[[-117.33553, 33.17279], [-117.33504, 33.17295], [-117.33498, 33.17296], [-117.33486, 33.17291], [-117.33483, 33.17286], [-117.33482, 33.1728], [-117.33484, 33.17275], [-117.3349, 33.1727], [-117.33539, 33.17252], [-117.33553, 33.17279]]], [[[-117.33601, 33.17448], [-117.33569, 33.17369], [-117.33585, 33.17363], [-117.33597, 33.17413], [-117.33601, 33.17448]]], [[[-117.34183, 33.1778], [-117.34101, 33.17897], [-117.34066, 33.17885], [-117.3407, 33.17863], [-117.3407, 33.17845], [-117.34066, 33.17828], [-117.34067, 33.17824], [-117.34069, 33.17822], [-117.34109, 33.17813], [-117.34142, 33.17802], [-117.34162, 33.17793], [-117.34183, 33.1778]]]]} | Open Access 1 | 1104 | Hosp Grove Park | 20102 | 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/hosp.asp | San Diego 4 | 74.137 | Hosp Grove Park | 1986 | Local Park 2 | 4 |
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 | |
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 |
300 | 300 | 299 | {"type": "Polygon", "coordinates": [[[-117.3135, 33.14612], [-117.31318, 33.14646], [-117.31313, 33.1466], [-117.31099, 33.147], [-117.31088, 33.14654], [-117.31089, 33.14651], [-117.31092, 33.14648], [-117.3118, 33.14632], [-117.31204, 33.14623], [-117.31225, 33.14611], [-117.31238, 33.14601], [-117.31252, 33.14586], [-117.31262, 33.14572], [-117.31348, 33.1459], [-117.3135, 33.14612]]]} | Open Access 1 | 815 | Laguna Riviera Park | 20865 | 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/laguna.asp | San Diego 4 | 4.198 | Laguna Riviera Park | 0 | Local Park 2 | 4 |
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 |
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 |
3788 | 3788 | 3787 | {"type": "Polygon", "coordinates": [[[-117.3112, 33.11639], [-117.30509, 33.11639], [-117.30511, 33.11539], [-117.30509, 33.11339], [-117.30897, 33.1134], [-117.30898, 33.11268], [-117.30898, 33.11167], [-117.30935, 33.11167], [-117.30935, 33.11281], [-117.30938, 33.11308], [-117.30951, 33.11344], [-117.30953, 33.11345], [-117.31077, 33.11547], [-117.31069, 33.1155], [-117.31069, 33.11552], [-117.3112, 33.11639]]]} | Open Access 1 | 1078 | Poinsettia Park | 23844 | 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/poinsettia.asp | San Diego 4 | 42.183 | Poinsettia Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);