units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
995 rows where COUNTY = 4 and MNG_AG_TYP = 2 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_ID, YR_EST
DES_TP >30
- Local Park 552
- Local Recreation Area 288
- Local Other or Unknown 89
- Local Conservation Area 16
- 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 18
- San Diego, City of 533
- Chula Vista, City of 70
- Poway, City of 67
- Encinitas, City of 57
- Oceanside, City of 45
- Carlsbad, City of 40
- San Marcos, City of 40
- 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 12
- Del Mar, City of 8
- National City, City of 7
- Lemon Grove, City of 6
- Imperial Beach, City of 5
- Solana Beach, City of 3
AGNCY_TYP 9 ✖
ACCESS_TYP 4
- Open Access 928
- No Public Access 38
- Restricted Access 28
- Unknown Access 1
MNG_AG_TYP 1
- City Agency · 995 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.13155, 32.60871], [-117.13082, 32.60779], [-117.1306, 32.6076], [-117.1302, 32.60762], [-117.12999, 32.60766], [-117.12894, 32.60764], [-117.12851, 32.60758], [-117.1281, 32.60746], [-117.12761, 32.60717], [-117.12702, 32.60667], [-117.12658, 32.60618], [-117.1259, 32.60554], [-117.12564, 32.60545], [-117.12498, 32.60536], [-117.12444, 32.60519], [-117.12507, 32.60517], [-117.12808, 32.60599], [-117.1287, 32.60621], [-117.12921, 32.60642], [-117.1296, 32.60663], [-117.12996, 32.60686], [-117.13025, 32.60707], [-117.1305, 32.60731], [-117.13071, 32.60753], [-117.13153, 32.60854], [-117.13155, 32.60871]]]} | No Public Access 3 | 47652 | South Bay Marine Biological Study Area | 31395 | 110 | United States Navy 876 | Federal 1 | Federal Agency 1 | http://www.navy.mil/ | Other Federal 13 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.569 | South Bay Marine Biological Study Area | None 645 | |||
16452 | 16452 | 16451 | {"type": "Polygon", "coordinates": [[[-117.31058, 33.07647], [-117.31024, 33.07647], [-117.30983, 33.07527], [-117.30891, 33.07324], [-117.30866, 33.07256], [-117.30669, 33.06808], [-117.30625, 33.06704], [-117.30608, 33.0665], [-117.30551, 33.06583], [-117.30541, 33.0655], [-117.30479, 33.06563], [-117.30446, 33.06469], [-117.30483, 33.06459], [-117.30492, 33.06399], [-117.30429, 33.06269], [-117.30461, 33.06262], [-117.30504, 33.06328], [-117.30518, 33.06356], [-117.3054, 33.06412], [-117.30551, 33.06446], [-117.30564, 33.06468], [-117.30568, 33.06484], [-117.30572, 33.06532], [-117.30575, 33.06545], [-117.30593, 33.06584], [-117.30644, 33.06646], [-117.30657, 33.06663], [-117.30681, 33.06708], [-117.30691, 33.06733], [-117.30715, 33.06807], [-117.30726, 33.0683], [-117.30735, 33.06859], [-117.30748, 33.06898], [-117.30764, 33.06936], [-117.30785, 33.06979], [-117.30805, 33.07028], [-117.30825, 33.07082], [-117.30893, 33.07212], [-117.30901, 33.0724], [-117.3091, 33.07289], [-117.31058, 33.07647]]]} | Open Access 1 | 4045 | Leucadia State Beach | 30658 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 15.812 | Leucadia SB | 1949 | None 1403 | |
16454 | 16454 | 16453 | {"type": "MultiPolygon", "coordinates": [[[[-117.29601, 33.04852], [-117.29434, 33.04867], [-117.29425, 33.04809], [-117.29422, 33.04808], [-117.2942, 33.04794], [-117.2959, 33.04778], [-117.29595, 33.04815], [-117.29601, 33.04852]]], [[[-117.29802, 33.04877], [-117.29769, 33.0488], [-117.29769, 33.04872], [-117.29776, 33.04866], [-117.29781, 33.04865], [-117.2979, 33.04869], [-117.29798, 33.04869], [-117.29801, 33.04872], [-117.29802, 33.04877]]], [[[-117.29663, 33.04875], [-117.29631, 33.04878], [-117.29629, 33.04866], [-117.29661, 33.04863], [-117.29663, 33.04875]]], [[[-117.29605, 33.04882], [-117.29572, 33.04885], [-117.2957, 33.04871], [-117.29603, 33.04868], [-117.29605, 33.04882]]], [[[-117.29565, 33.04886], [-117.29534, 33.04888], [-117.29532, 33.04875], [-117.29564, 33.04872], [-117.29565, 33.04886]]], [[[-117.29466, 33.04895], [-117.29438, 33.04898], [-117.29436, 33.04884], [-117.29464, 33.04881], [-117.29466, 33.04895]]], [[[-117.29921, 33.04945], [-117.29911, 33.04946], [-117.29906, 33.04935], [-117.29873, 33.04939], [-117.29861, 33.04844], [-117.29812, 33.04848], [-117.29811, 33.04845], [-117.29806, 33.04846], [-117.29797, 33.04843], [-117.29789, 33.04845], [-117.29781, 33.0485], [-117.2978, 33.04856], [-117.29777, 33.0486], [-117.29765, 33.04867], [-117.29763, 33.04871], [-117.29763, 33.04881], [-117.2973, 33.04883], [-117.29724, 33.0484], [-117.29627, 33.04849], [-117.29608, 33.04721], [-117.29743, 33.04707], [-117.29736, 33.04645], [-117.29767, 33.04642], [-117.29749, 33.04498], [-117.29747, 33.04497], [-117.29745, 33.04483], [-117.29747, 33.04482], [-117.29725, 33.0431], [-117.29727, 33.04302], [-117.29734, 33.04365], [-117.29745, 33.04422], [-117.29804, 33.04641], [-117.29814, 33.04686], [-117.29815, 33.04688], [-117.29822, 33.04688], [-117.2988, 33.04824], [-117.29921, 33.04945]]]]} | Open Access 1 | 5464 | Moonlight State Beach | 30664 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 15.875 | Moonlight SB | 1949 | None 1404 | |
4007 | 4007 | 4006 | {"type": "MultiPolygon", "coordinates": [[[[-117.14406, 32.70147], [-117.1438, 32.70178], [-117.14126, 32.70002], [-117.14133, 32.6999], [-117.14168, 32.70003], [-117.14184, 32.70014], [-117.14214, 32.70029], [-117.14239, 32.70037], [-117.14245, 32.70033], [-117.14406, 32.70147]]], [[[-117.14441, 32.70113], [-117.14421, 32.70131], [-117.14265, 32.70025], [-117.14169, 32.69956], [-117.14176, 32.69951], [-117.14179, 32.69934], [-117.14203, 32.69909], [-117.14229, 32.69886], [-117.1439, 32.7], [-117.14382, 32.70008], [-117.14379, 32.70022], [-117.14379, 32.70042], [-117.14375, 32.70045], [-117.14383, 32.70053], [-117.14392, 32.70058], [-117.14392, 32.70062], [-117.14396, 32.70074], [-117.14401, 32.70083], [-117.14441, 32.70113]]]]} | Open Access 1 | 46820 | Chicano Park | 17188 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.609 | Chicano Park | 0 | Local Park 2 | 4 | |
13167 | 13167 | 13166 | {"type": "MultiPolygon", "coordinates": [[[[-117.06575, 32.85148], [-117.06108, 32.85142], [-117.05338, 32.85136], [-117.05338, 32.85293], [-117.05221, 32.8528], [-117.05147, 32.85255], [-117.05108, 32.852], [-117.05061, 32.85144], [-117.0501, 32.85094], [-117.0495, 32.85046], [-117.04913, 32.8502], [-117.04868, 32.84993], [-117.04767, 32.84943], [-117.04769, 32.84785], [-117.06406, 32.84798], [-117.06575, 32.85148]]], [[[-117.05339, 32.85425], [-117.0534, 32.85544], [-117.05338, 32.85558], [-117.05244, 32.8541], [-117.05339, 32.85425]]]]} | Open Access 1 | 45149 | Mission Trails Regional Park | 29248 | 221 | San Diego State University 1047 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 155.468 | Mission Trails RP | 0 | Local Park 2 | 4 |
16308 | 16308 | 16307 | {"type": "MultiPolygon", "coordinates": [[[[-117.0198, 32.82876], [-117.01951, 32.82959], [-117.01936, 32.8301], [-117.01773, 32.83003], [-117.01791, 32.82937], [-117.01801, 32.82935], [-117.01803, 32.82882], [-117.01793, 32.82837], [-117.01781, 32.82808], [-117.01732, 32.82737], [-117.01791, 32.82736], [-117.0198, 32.82876]]], [[[-117.04626, 32.81855], [-117.04598, 32.81888], [-117.04576, 32.81919], [-117.04407, 32.82211], [-117.04113, 32.82749], [-117.04075, 32.82815], [-117.04034, 32.82876], [-117.03996, 32.82928], [-117.03954, 32.82979], [-117.0391, 32.83029], [-117.03793, 32.83145], [-117.03427, 32.83146], [-117.02856, 32.82771], [-117.02747, 32.82882], [-117.02687, 32.82902], [-117.02698, 32.82892], [-117.0266, 32.82839], [-117.02654, 32.82842], [-117.02589, 32.82794], [-117.02548, 32.82847], [-117.02498, 32.82829], [-117.02459, 32.82809], [-117.02386, 32.82757], [-117.02399, 32.82745], [-117.02411, 32.82684], [-117.02346, 32.82662], [-117.02302, 32.82699], [-117.02263, 32.82673], [-117.02249, 32.82686], [-117.02235, 32.82676], [-117.02233, 32.82677], [-117.02208, 32.82659], [-117.01999, 32.82869], [-117.01798, 32.82719], [-117.01706, 32.8272], [-117.01687, 32.82685], [-117.01635, 32.82571], [-117.01586, 32.82388], [-117.01584, 32.82388], [-117.01574, 32.82376], [-117.01563, 32.82364], [-117.01539, 32.82346], [-117.01521, 32.82324], [-117.01505, 32.8231], [-117.01499, 32.823], [-117.01493, 32.82269], [-117.01488, 32.82256], [-117.01458, 32.82224], [-117.01449, 32.82216], [-117.01421, 32.82197], [-117.01183, 32.82066], [-117.01156, 32.82047], [-117.01137, 32.82028], [-117.01119, 32.82005], [-117.01107, 32.81978], [-117.0107, 32.81851], [-117.01061, 32.81816], [-117.0106, 32.81809], [-117.01066, 32.81799], [-117.01075, 32.81793], [-117.01086, 32.81792], [-117.01099, 32.81796], [-117.01107, 32.81805], [-117.01136, 32.81892], [-117.01145, 32.81906], [-117.01158, 32.81921], [-117.01183, 32.81938], [-117.01271, 32.81981], [-117.01289, 32.81988], [-117.01308, 32.81992], [-117.01337, 32.81993], [-117.01361, 32.8199], [-117.01385, 32.81983], [-117.01409, 32.8197], [-117.01425, 32.81957], [-117.01435, 32.81946], [-117.01481, 32.81877], [-117.0147, 32.81871], [-117.01426, 32.81937], [-117.01416, 32.81949], [-117.01399, 32.81963], [-117.01383, 32.81972], [-117.01365, 32.81978], [-117.01341, 32.81982], [-117.01323, 32.81983], [-117.01299, 32.8198], [-117.01277, 32.81972], [-117.0119, 32.81929], [-117.01168, 32.81914], [-117.01156, 32.81899], [-117.01147, 32.81885], [-117.01119, 32.81801], [-117.01113, 32.81792], [-117.01103, 32.81785], [-117.0109, 32.81781], [-117.01075, 32.81782], [-117.01063, 32.81786], [-117.01052, 32.81797], [-117.01048, 32.81805], [-117.01047, 32.81813], [-117.01058, 32.81855], [-117.01023, 32.81751], [-117.00997, 32.81563], [-117.01204, 32.81698], [-117.01391, 32.81818], [-117.0198, 32.8119], [-117.01979, 32.81188], [-117.01937, 32.81159], [-117.01979, 32.81115], [-117.02118, 32.8122], [-117.02174, 32.81214], [-117.02325, 32.81054], [-117.02339, 32.8101], [-117.02316, 32.80969], [-117.02272, 32.80941], [-117.02259, 32.8095], [-117.02245, 32.80957], [-117.02229, 32.80961], [-117.02212, 32.80963], [-117.02193, 32.80962], [-117.02176, 32.80957], [-117.02161, 32.8095], [-117.0215, 32.80942], [-117.0216, 32.80933], [-117.0219, 32.80952], [-117.02312, 32.80816], [-117.02571, 32.80819], [-117.02706, 32.80763], [-117.02759, 32.80851], [-117.02839, 32.80817], [-117.02788, 32.80729], [-117.02849, 32.80704], [-117.02918, 32.80557], [-117.0298, 32.80447], [-117.0313, 32.80375], [-117.03165, 32.80305], [-117.0317, 32.80307], [-117.03622, 32.80401], [-117.03728, 32.80422], [-117.03718, 32.80461], [-117.03774, 32.80471], [-117.0377, 32.80494], [-117.03767, 32.80517], [-117.03767, 32.8054], [-117.03771, 32.80568], [-117.03778, 32.80594], [-117.03785, 32.80614], [-117.03795, 32.80634], [-117.03809, 32.80655], [-117.03832, 32.80684], [-117.03857, 32.80707], [-117.03903, 32.8074], [-117.0394, 32.80757], [-117.03925, 32.80783], [-117.04019, 32.80836], [-117.03971, 32.80914], [-117.03963, 32.80933], [-117.0396, 32.80953], [-117.03959, 32.80986], [-117.03983, 32.81006], [-117.04008, 32.81009], [-117.04005, 32.81052], [-117.04018, 32.81053], [-117.04039, 32.81104], [-117.04042, 32.81119], [-117.04041, 32.81136], [-117.04046, 32.81152], [-117.04087, 32.81226], [-117.04123, 32.81262], [-117.04166, 32.81316], [-117.0432, 32.81475], [-117.04291, 32.8147], [-117.04273, 32.81537], [-117.04315, 32.81545], [-117.0436, 32.81548], [-117.04419, 32.81549], [-117.04512, 32.8158], [-117.04555, 32.8159], [-117.04626, 32.81855]]]]} | Open Access 1 | 1152 | Mission Trails Regional Park | 29248 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.mtrp.org/ | San Diego 4 | 1520.459 | Mission Trails RP | 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 |
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 |
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]);