units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where AGNCY_TYP = 2, DES_TP = 2 and MNG_AGENCY = 120
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 20
MNG_AGENCY 1
- Carlsbad, City of · 20 ✖
DES_TP 1
- Local Park · 20 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
754 | 754 | 753 | {"type": "Polygon", "coordinates": [[[-117.35498, 33.1614], [-117.35452, 33.16157], [-117.35394, 33.16158], [-117.35354, 33.16109], [-117.35435, 33.16062], [-117.35498, 33.1614]]]} | Open Access 1 | 4943 | Magee Park | 29993 | 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/magee.asp | San Diego 4 | 2.038 | Magee 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 |
1388 | 1388 | 1387 | {"type": "Polygon", "coordinates": [[[-117.26522, 33.11651], [-117.26495, 33.11675], [-117.26508, 33.11785], [-117.26472, 33.11778], [-117.26456, 33.11804], [-117.26486, 33.11874], [-117.26455, 33.11898], [-117.26426, 33.11874], [-117.26356, 33.11871], [-117.26333, 33.11887], [-117.26309, 33.11878], [-117.26306, 33.11873], [-117.26305, 33.11849], [-117.26301, 33.11844], [-117.26293, 33.11839], [-117.26283, 33.11839], [-117.26278, 33.11841], [-117.26273, 33.11847], [-117.2626, 33.11866], [-117.26228, 33.11852], [-117.26237, 33.11837], [-117.26246, 33.11817], [-117.26251, 33.11799], [-117.26254, 33.11778], [-117.26255, 33.11666], [-117.26249, 33.11637], [-117.26241, 33.11614], [-117.26225, 33.11587], [-117.26201, 33.1156], [-117.26183, 33.11546], [-117.26152, 33.11525], [-117.26115, 33.11504], [-117.26088, 33.11474], [-117.26088, 33.11469], [-117.26091, 33.11466], [-117.26103, 33.11461], [-117.26178, 33.11424], [-117.26355, 33.11341], [-117.26382, 33.11379], [-117.2645, 33.11437], [-117.26426, 33.11532], [-117.26437, 33.11597], [-117.26517, 33.11629], [-117.26522, 33.11651]]]} | Open Access 1 | 12151 | Alga Norte Community Park | 29685 | 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/alga.asp | San Diego 4 | 32.106 | Alga Norte Community Park | 0 | Local Park 2 | 4 |
1454 | 1454 | 1453 | {"type": "Polygon", "coordinates": [[[-117.35047, 33.16003], [-117.34995, 33.16035], [-117.34918, 33.15942], [-117.34972, 33.15911], [-117.35047, 33.16003]]]} | Open Access 1 | 12582 | Rotary Park | 24686 | 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.857 | Rotary 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 |
4844 | 4844 | 4843 | {"type": "Polygon", "coordinates": [[[-117.30042, 33.16416], [-117.30022, 33.16457], [-117.30007, 33.16511], [-117.30001, 33.16558], [-117.30001, 33.16585], [-117.30008, 33.16623], [-117.30014, 33.16643], [-117.30038, 33.16702], [-117.30038, 33.16706], [-117.30035, 33.1671], [-117.29881, 33.16761], [-117.29876, 33.1676], [-117.29872, 33.16755], [-117.29802, 33.16583], [-117.29797, 33.16563], [-117.29795, 33.16544], [-117.298, 33.16505], [-117.29814, 33.16471], [-117.29822, 33.16458], [-117.29833, 33.16445], [-117.29862, 33.16422], [-117.29889, 33.16405], [-117.29965, 33.16377], [-117.29974, 33.16387], [-117.30042, 33.16416]]]} | Open Access 1 | 1099 | Calavera Park | 29986 | 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/calavera.asp | San Diego 4 | 16.79 | Calavera Park | 0 | Local Park 2 | 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 | |
6050 | 6050 | 6049 | {"type": "Polygon", "coordinates": [[[-117.34341, 33.1585], [-117.34289, 33.1588], [-117.34306, 33.15902], [-117.34259, 33.1593], [-117.34127, 33.15769], [-117.34126, 33.15765], [-117.34128, 33.1576], [-117.34263, 33.15682], [-117.34329, 33.15763], [-117.34292, 33.15786], [-117.34322, 33.15823], [-117.34321, 33.15825], [-117.34341, 33.1585]]]} | Open Access 1 | 762 | Pine Park | 29999 | 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/pine.asp | San Diego 4 | 7.138 | Pine 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 |
6139 | 6139 | 6138 | {"type": "Polygon", "coordinates": [[[-117.31884, 33.17107], [-117.31818, 33.1714], [-117.31763, 33.17197], [-117.31758, 33.17199], [-117.31759, 33.17204], [-117.31757, 33.17206], [-117.31714, 33.17219], [-117.31709, 33.1722], [-117.31708, 33.17217], [-117.31705, 33.17217], [-117.31704, 33.17224], [-117.31699, 33.17226], [-117.31682, 33.1731], [-117.31797, 33.17527], [-117.31573, 33.17406], [-117.31571, 33.17396], [-117.31541, 33.17367], [-117.31509, 33.17391], [-117.31494, 33.17383], [-117.31507, 33.17353], [-117.31472, 33.17344], [-117.31475, 33.17332], [-117.31475, 33.17321], [-117.31478, 33.17303], [-117.31474, 33.17278], [-117.31467, 33.17261], [-117.31465, 33.17247], [-117.31499, 33.17239], [-117.31517, 33.17229], [-117.31524, 33.17215], [-117.3152, 33.17185], [-117.31496, 33.17157], [-117.31516, 33.17153], [-117.31539, 33.17145], [-117.31556, 33.17136], [-117.3159, 33.17157], [-117.31702, 33.17107], [-117.31703, 33.17106], [-117.31681, 33.17078], [-117.31707, 33.1707], [-117.3174, 33.17065], [-117.31748, 33.17066], [-117.31769, 33.17063], [-117.31786, 33.17063], [-117.31829, 33.17065], [-117.31859, 33.17071], [-117.31884, 33.17107]]]} | Open Access 1 | 1132 | Hidden Canyon Community Park | 29988 | 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/hidden.asp | San Diego 4 | 20.755 | Hidden Canyon Community Park | 0 | Local Park 2 | 4 |
6425 | 6425 | 6424 | {"type": "Polygon", "coordinates": [[[-117.24324, 33.10452], [-117.24295, 33.10466], [-117.24254, 33.10499], [-117.2424, 33.10498], [-117.24176, 33.10484], [-117.24171, 33.10478], [-117.24165, 33.10475], [-117.24152, 33.10476], [-117.24146, 33.10481], [-117.24127, 33.10477], [-117.24119, 33.10472], [-117.24122, 33.10468], [-117.24122, 33.10467], [-117.24082, 33.10455], [-117.24083, 33.10447], [-117.24077, 33.10443], [-117.2408, 33.10434], [-117.24077, 33.10432], [-117.24092, 33.10403], [-117.24145, 33.10412], [-117.24144, 33.10416], [-117.24172, 33.10428], [-117.24255, 33.10361], [-117.24285, 33.10394], [-117.24324, 33.10452]]]} | Restricted Access 2 | 1929 | Fuerte Park | 31613 | 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 | 4.633 | Fuerte 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 |
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 |
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 |
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 |
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 |
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 | |
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 |
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]);