units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
987 rows where AGNCY_TYP = 2 and COUNTY = 4 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, YR_EST
DES_TP >30
- Local Park 543
- Local Recreation Area 285
- Local Other or Unknown 88
- Local Conservation Area 19
- Local Historic or Cultural Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Local Resource Management Area 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AGENCY 26
- San Diego, City of 525
- Chula Vista, City of 70
- Poway, City of 67
- Encinitas, City of 54
- Oceanside, City of 44
- San Marcos, City of 38
- Carlsbad, City of 36
- Escondido, City of 34
- Coronado, City of 19
- Vista, City of 18
- El Cajon, City of 17
- La Mesa, City of 14
- Santee, City of 11
- Del Mar, City of 8
- National City, City of 7
- Lemon Grove, City of 6
- Imperial Beach, City of 5
- San Diego, County of 3
- Solana Beach, City of 3
- San Diego Unified Port District 2
- Boys and Girls Clubs of South County 1
- Private Landowner 1
- San Diego Zoo Global 1
- Bay Club 1
- JC Resorts 1
- American Golf 1
MNG_AG_TYP 6
ACCESS_TYP 4
- Open Access 924
- No Public Access 36
- Restricted Access 26
- Unknown Access 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7371 | 7371 | 7370 | {"type": "MultiPolygon", "coordinates": [[[[-116.86639, 32.64508], [-116.85755, 32.65151], [-116.84988, 32.64452], [-116.83978, 32.6535], [-116.84011, 32.64195], [-116.84001, 32.63453], [-116.85687, 32.6339], [-116.86632, 32.63397], [-116.8663, 32.63756], [-116.86637, 32.64162], [-116.86639, 32.64508]]], [[[-116.86655, 32.61902], [-116.86648, 32.62263], [-116.85735, 32.62253], [-116.8575, 32.61887], [-116.85328, 32.61895], [-116.85341, 32.6153], [-116.85765, 32.61523], [-116.85766, 32.61522], [-116.86235, 32.61529], [-116.86229, 32.61895], [-116.86655, 32.61902]]], [[[-116.89127, 32.62103], [-116.88695, 32.62103], [-116.88698, 32.62282], [-116.88243, 32.62281], [-116.88238, 32.62103], [-116.88012, 32.62103], [-116.88014, 32.61181], [-116.88905, 32.61191], [-116.88897, 32.61919], [-116.89126, 32.61923], [-116.89127, 32.62103]]], [[[-116.89403, 32.68807], [-116.88945, 32.68809], [-116.88943, 32.68986], [-116.88507, 32.6899], [-116.88499, 32.6881], [-116.88498, 32.68628], [-116.8872, 32.68625], [-116.88718, 32.68453], [-116.894, 32.68446], [-116.89403, 32.68807]]], [[[-116.9108, 32.60449], [-116.91078, 32.61199], [-116.89349, 32.61196], [-116.8934, 32.60454], [-116.9108, 32.60449]]], [[[-116.9023, 32.67355], [-116.89805, 32.67354], [-116.89802, 32.67032], [-116.90228, 32.6703], [-116.9023, 32.67355]]], [[[-116.92781, 32.66319], [-116.91926, 32.66312], [-116.91924, 32.66405], [-116.91912, 32.66399], [-116.91867, 32.66361], [-116.91849, 32.66338], [-116.91783, 32.66291], [-116.91751, 32.66259], [-116.91698, 32.66218], [-116.91629, 32.66151], [-116.91562, 32.661], [-116.91537, 32.66092], [-116.91511, 32.66091], [-116.91485, 32.66092], [-116.91489, 32.65935], [-116.91629, 32.65938], [-116.91632, 32.65562], [-116.9278, 32.65584], [-116.92781, 32.66319]]], [[[-116.9485, 32.60875], [-116.94821, 32.60883], [-116.94815, 32.60864], [-116.94799, 32.60841], [-116.94773, 32.60837], [-116.9475, 32.6084], [-116.94739, 32.60869], [-116.94739, 32.60906], [-116.94742, 32.60929], [-116.94734, 32.60969], [-116.94734, 32.60992], [-116.94738, 32.61022], [-116.94743, 32.61044], [-116.94749, 32.61058], [-116.9478, 32.61102], [-116.94786, 32.61125], [-116.94789, 32.61154], [-116.94788, 32.61175], [-116.94781, 32.61196], [-116.9477, 32.61218], [-116.94757, 32.61233], [-116.94741, 32.61249], [-116.94719, 32.61264], [-116.94704, 32.61273], [-116.94666, 32.61303], [-116.94652, 32.61342], [-116.94644, 32.61381], [-116.94655, 32.61422], [-116.94661, 32.6148], [-116.94671, 32.61502], [-116.94664, 32.61532], [-116.94647, 32.61551], [-116.94636, 32.61556], [-116.9461, 32.61561], [-116.94598, 32.6156], [-116.94581, 32.61554], [-116.94563, 32.61541], [-116.94524, 32.61528], [-116.94507, 32.61536], [-116.9451, 32.61559], [-116.94526, 32.61583], [-116.94535, 32.61608], [-116.94537, 32.61635], [-116.94531, 32.61658], [-116.94524, 32.61655], [-116.94451, 32.61703], [-116.94436, 32.61718], [-116.94427, 32.61735], [-116.94424, 32.61754], [-116.94426, 32.61802], [-116.94422, 32.61873], [-116.94416, 32.61915], [-116.94408, 32.61957], [-116.94392, 32.62017], [-116.94323, 32.62228], [-116.94298, 32.62294], [-116.94274, 32.62345], [-116.94252, 32.62383], [-116.9422, 32.62431], [-116.94185, 32.62477], [-116.94155, 32.6251], [-116.94113, 32.62552], [-116.94067, 32.62592], [-116.94033, 32.62618], [-116.93446, 32.61192], [-116.93444, 32.61181], [-116.93431, 32.61145], [-116.9337, 32.61008], [-116.93333, 32.60918], [-116.93421, 32.60895], [-116.93327, 32.60677], [-116.93401, 32.60657], [-116.93324, 32.60469], [-116.93298, 32.60475], [-116.93164, 32.60515], [-116.92891, 32.59854], [-116.93933, 32.5955], [-116.93933, 32.59113], [-116.93937, 32.58207], [-116.94513, 32.5821], [-116.94524, 32.59383], [-116.94269, 32.59453], [-116.94534, 32.60102], [-116.94534, 32.60104], [-116.94536, 32.60105], [-116.9485, 32.60875]]], [[[-116.96532, 32.58705], [-116.96529, 32.58711], [-116.96524, 32.58746], [-116.96526, 32.5878], [-116.96532, 32.58792], [-116.96231, 32.5888], [-116.96222, 32.58619], [-116.96221, 32.58429], [-116.96433, 32.58431], [-116.96437, 32.58459], [-116.96435, 32.58468], [-116.96443, 32.58532], [-116.9643, 32.58561], [-116.96436, 32.58577], [-116.96456, 32.58587], [-116.96514, 32.58598], [-116.96514, 32.58611], [-116.96525, 32.58636], [-116.96522, 32.58656], [-116.96532, 32.58705]]], [[[-116.97937, 32.58382], [-116.96896, 32.58686], [-116.9689, 32.5868], [-116.96865, 32.58659], [-116.96838, 32.58631], [-116.96819, 32.58627], [-116.968, 32.58606], [-116.96781, 32.58604], [-116.96723, 32.58604], [-116.96664, 32.5844], [-116.96574, 32.58455], [-116.9656, 32.58432], [-116.96664, 32.58432], [-116.96664, 32.58242], [-116.97107, 32.58246], [-116.97936, 32.58251], [-116.97937, 32.58382]]], [[[-116.98618, 32.61112], [-116.98584, 32.61131], [-116.98592, 32.61153], [-116.98568, 32.61161], [-116.98543, 32.61174], [-116.98533, 32.61174], [-116.98504, 32.61199], [-116.98461, 32.61232], [-116.98453, 32.61251], [-116.98451, 32.61261], [-116.98452, 32.61225], [-116.98456, 32.61219], [-116.9847, 32.61208], [-116.9847, 32.61206], [-116.98466, 32.612], [-116.98446, 32.61187], [-116.98445, 32.61182], [-116.98446, 32.61162], [-116.98449, 32.61153], [-116.98454, 32.61144], [-116.98461, 32.61139], [-116.98463, 32.61135], [-116.98462, 32.61119], [-116.98457, 32.61095], [-116.98458, 32.61089], [-116.98461, 32.61083], [-116.98467, 32.61062], [-116.98478, 32.61049], [-116.98486, 32.61033], [-116.98489, 32.61021], [-116.98496, 32.6101], [-116.98489, 32.60999], [-116.98489, 32.60976], [-116.98502, 32.60993], [-116.98504, 32.60993], [-116.98557, 32.61058], [-116.98618, 32.61112]]], [[[-116.99061, 32.60452], [-116.99046, 32.60532], [-116.99044, 32.60553], [-116.99036, 32.60581], [-116.99001, 32.60644], [-116.98993, 32.60662], [-116.98981, 32.60704], [-116.98935, 32.60734], [-116.98925, 32.60749], [-116.98912, 32.60783], [-116.98913, 32.60813], [-116.98795, 32.60955], [-116.98722, 32.61006], [-116.98659, 32.61084], [-116.98646, 32.61097], [-116.98582, 32.61041], [-116.98531, 32.60978], [-116.98516, 32.60986], [-116.98501, 32.60967], [-116.9852, 32.60968], [-116.98536, 32.60976], [-116.98547, 32.60976], [-116.98566, 32.60973], [-116.98594, 32.60962], [-116.98608, 32.6095], [-116.98621, 32.60935], [-116.98628, 32.60932], [-116.98638, 32.60904], [-116.98655, 32.60894], [-116.98689, 32.60884], [-116.98714, 32.60871], [-116.98726, 32.60852], [-116.98723, 32.6084], [-116.98728, 32.6081], [-116.98732, 32.60803], [-116.98783, 32.60768], [-116.98802, 32.60737], [-116.98804, 32.60681], [-116.98811, 32.60674], [-116.98869, 32.60645], [-116.98882, 32.60631], [-116.98903, 32.60523], [-116.98907, 32.60495], [-116.99061, 32.60452]]]]} | No Public Access 3 | 47589 | Otay Ranch Preserve | 31316 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 3245.845 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
7963 | 7963 | 7962 | {"type": "MultiPolygon", "coordinates": [[[[-116.96231, 32.5888], [-116.95891, 32.58979], [-116.96013, 32.59278], [-116.95959, 32.59293], [-116.95911, 32.5929], [-116.95864, 32.593], [-116.95789, 32.59309], [-116.95733, 32.59319], [-116.95703, 32.59325], [-116.95686, 32.59339], [-116.95657, 32.59347], [-116.95598, 32.59351], [-116.95514, 32.59365], [-116.95421, 32.59393], [-116.95377, 32.59419], [-116.95265, 32.59474], [-116.95221, 32.59489], [-116.95194, 32.59494], [-116.9508, 32.59216], [-116.95833, 32.58995], [-116.95639, 32.58888], [-116.95595, 32.58857], [-116.9523, 32.58586], [-116.95369, 32.58588], [-116.96222, 32.58619], [-116.96231, 32.5888]]], [[[-116.96197, 32.5973], [-116.96128, 32.5975], [-116.96123, 32.59737], [-116.96109, 32.59724], [-116.96094, 32.5972], [-116.96072, 32.59721], [-116.96053, 32.59726], [-116.96038, 32.59735], [-116.96029, 32.59743], [-116.96024, 32.59751], [-116.9602, 32.59766], [-116.96014, 32.59775], [-116.96003, 32.59785], [-116.95988, 32.59786], [-116.95969, 32.5978], [-116.95952, 32.59771], [-116.95914, 32.59765], [-116.95898, 32.59758], [-116.95875, 32.59759], [-116.95844, 32.59767], [-116.95811, 32.59787], [-116.95753, 32.5982], [-116.95669, 32.59855], [-116.95642, 32.59876], [-116.95623, 32.59892], [-116.95384, 32.59959], [-116.95285, 32.59719], [-116.95353, 32.59743], [-116.95424, 32.59722], [-116.95498, 32.59694], [-116.95604, 32.59641], [-116.95638, 32.5962], [-116.95675, 32.59608], [-116.95783, 32.59581], [-116.9586, 32.59566], [-116.95917, 32.59523], [-116.95938, 32.59502], [-116.96077, 32.59435], [-116.96197, 32.5973]]]]} | Restricted Access 2 | 47729 | Otay Ranch Preserve | 31529 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/openspace/Otay_Ranch.html | San Diego 4 | 179.037 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
13205 | 13205 | 13204 | {"type": "MultiPolygon", "coordinates": [[[[-116.92352, 32.60821], [-116.9235, 32.61195], [-116.91216, 32.61202], [-116.91078, 32.61199], [-116.91094, 32.61568], [-116.90658, 32.61567], [-116.90666, 32.61927], [-116.90219, 32.61927], [-116.90214, 32.61198], [-116.91078, 32.61199], [-116.9108, 32.60449], [-116.91928, 32.60446], [-116.91928, 32.6082], [-116.92352, 32.60821]]], [[[-116.91632, 32.65562], [-116.91629, 32.65938], [-116.91356, 32.65931], [-116.91311, 32.65864], [-116.91287, 32.65836], [-116.91254, 32.65791], [-116.91207, 32.65716], [-116.91169, 32.65659], [-116.91154, 32.65645], [-116.91128, 32.65626], [-116.91056, 32.65556], [-116.91239, 32.65554], [-116.91632, 32.65562]]]]} | Open Access 1 | 45236 | Otay Ranch Preserve | 10734 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/pds/mscp/or.html | San Diego 4 | 368.875 | Otay Ranch Preserve | 0 | Local Conservation Area 4 | 2 |
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 |
5072 | 5072 | 5071 | {"type": "Polygon", "coordinates": [[[-117.29151, 33.13914], [-117.29094, 33.13994], [-117.29087, 33.14012], [-117.29095, 33.14017], [-117.29055, 33.14137], [-117.28899, 33.14036], [-117.28835, 33.14107], [-117.28758, 33.14058], [-117.28903, 33.13896], [-117.28987, 33.13949], [-117.29102, 33.13866], [-117.2913, 33.13893], [-117.29151, 33.13909], [-117.29151, 33.13914]]]} | Open Access 1 | 822 | Business Park Recreation Facility (Zone 5) | 30004 | 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.987 | Business Park Rec. Facility (Zone 5) | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 |
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 | |
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 |
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 |
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]);