units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,263 rows where AGNCY_TYP = 3
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 96
- San Diego, County of 71
- Orange, County of 62
- Santa Barbara, County of 51
- Butte, County of 45
- Lake, County of 41
- Los Angeles - Department of Parks and Recreation, County of 40
- Sacramento, County of 40
- El Dorado, County of 32
- Kern, County of 30
- Monterey, County of 24
- Santa Cruz, County of 19
- Placer, County of 18
- San Joaquin, County of 14
- Riverside, County of 13
- Stanislaus, County of 13
- San Luis Obispo, County of 11
- Fresno, County of 11
- San Bernardino, County of 10
- Yolo, County of 10
- Ventura, County of 7
- Humboldt, County of 7
- Merced, County of 6
- Lassen, County of 5
- Mariposa, County of 4
- Mendocino, County of 4
- Tulare, County of 3
- Napa, County of 3
- Modoc, County of 3
- Contra Costa, County of 3
- …
DES_TP >30
- Local Park 389
- Local Other or Unknown 137
- Local Recreation Area 91
- Local Conservation Area 59
- Local Historic or Cultural Area 8
- State Conservation Area 1
- National Forest 1
- National Monument or Landmark 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
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 11
ACCESS_TYP 4
- Open Access 664
- Restricted Access 41
- Unknown Access 22
- No Public Access 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6604 | 6604 | 6603 | {"type": "Polygon", "coordinates": [[[-116.53259, 32.82597], [-116.53029, 32.82583], [-116.52923, 32.82339], [-116.52988, 32.82262], [-116.53041, 32.82294], [-116.53063, 32.82271], [-116.5311, 32.82315], [-116.53135, 32.82342], [-116.53176, 32.82398], [-116.53193, 32.82426], [-116.53209, 32.82458], [-116.53231, 32.82509], [-116.53259, 32.82597]]]} | Open Access 1 | 4165 | Pine Valley Park | 23685 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/PineValley.html | San Diego 4 | 17.146 | Pine Valley Park | 0 | Local Park 2 | 4 |
6610 | 6610 | 6609 | {"type": "MultiPolygon", "coordinates": [[[[-117.65033, 33.66096], [-117.64922, 33.6629], [-117.64908, 33.6629], [-117.64911, 33.66256], [-117.64893, 33.66234], [-117.64824, 33.66234], [-117.64813, 33.66236], [-117.64803, 33.66247], [-117.64764, 33.66258], [-117.64634, 33.66263], [-117.64627, 33.66269], [-117.64627, 33.66282], [-117.64623, 33.66297], [-117.64612, 33.66303], [-117.64594, 33.66297], [-117.64577, 33.663], [-117.64559, 33.66312], [-117.64531, 33.66313], [-117.64509, 33.66307], [-117.64493, 33.66311], [-117.64445, 33.66303], [-117.64418, 33.66302], [-117.64394, 33.66306], [-117.64383, 33.66298], [-117.64369, 33.66297], [-117.64361, 33.66299], [-117.64364, 33.66279], [-117.64362, 33.66266], [-117.64353, 33.66247], [-117.64338, 33.66232], [-117.64325, 33.66224], [-117.64311, 33.66218], [-117.64295, 33.66215], [-117.64279, 33.66215], [-117.64231, 33.66222], [-117.64211, 33.66228], [-117.64184, 33.66241], [-117.64162, 33.66259], [-117.64145, 33.66281], [-117.64135, 33.66306], [-117.64133, 33.66332], [-117.64137, 33.66358], [-117.64118, 33.66354], [-117.64081, 33.66335], [-117.64035, 33.66315], [-117.64011, 33.6632], [-117.63958, 33.66293], [-117.63906, 33.66265], [-117.64203, 33.66222], [-117.64204, 33.66117], [-117.64234, 33.6612], [-117.64324, 33.66138], [-117.64469, 33.66135], [-117.64488, 33.66138], [-117.64575, 33.6616], [-117.64596, 33.66163], [-117.64618, 33.66163], [-117.64639, 33.66161], [-117.64963, 33.66113], [-117.64992, 33.66107], [-117.65033, 33.66096]], [[-117.64326, 33.6615], [-117.6432, 33.66149], [-117.6432, 33.66158], [-117.64326, 33.66158], [-117.64326, 33.6615]], [[-117.64376, 33.66143], [-117.6437, 33.66142], [-117.6437, 33.66149], [-117.64376, 33.66149], [-117.64376, 33.66143]]], [[[-117.63527, 33.66546], [-117.63426, 33.66589], [-117.63337, 33.6673], [-117.62925, 33.66919], [-117.62773, 33.67017], [-117.62765, 33.67032], [-117.62718, 33.67024], [-117.62672, 33.67012], [-117.6269, 33.66981], [-117.63455, 33.66511], [-117.63497, 33.66488], [-117.63527, 33.66546]]], [[[-117.65743, 33.67111], [-117.65572, 33.67203], [-117.65423, 33.67248], [-117.65355, 33.67208], [-117.65373, 33.67186], [-117.65384, 33.67177], [-117.65499, 33.67107], [-117.65563, 33.67131], [-117.65598, 33.67136], [-117.65617, 33.67133], [-117.65628, 33.67128], [-117.65671, 33.67092], [-117.657, 33.67111], [-117.65732, 33.67107], [-117.65743, 33.67111]]], [[[-117.64436, 33.67356], [-117.64426, 33.67364], [-117.6442, 33.67364], [-117.63957, 33.66465], [-117.63899, 33.66339], [-117.63941, 33.6636], [-117.63947, 33.66375], [-117.6401, 33.66411], [-117.64055, 33.66417], [-117.64116, 33.6647], [-117.64147, 33.66483], [-117.64107, 33.66534], [-117.6409, 33.66561], [-117.6408, 33.66595], [-117.64158, 33.66749], [-117.642, 33.66788], [-117.64262, 33.6689], [-117.64264, 33.66899], [-117.64261, 33.66912], [-117.64248, 33.6693], [-117.6423, 33.66945], [-117.64309, 33.67074], [-117.64318, 33.67081], [-117.64316, 33.67089], [-117.64318, 33.67101], [-117.6433, 33.67118], [-117.64374, 33.67203], [-117.64391, 33.67248], [-117.64426, 33.67317], [-117.64432, 33.67336], [-117.64436, 33.67356]]], [[[-117.64325, 33.67362], [-117.64289, 33.67363], [-117.64254, 33.67367], [-117.64014, 33.67408], [-117.63967, 33.67414], [-117.63946, 33.67373], [-117.63962, 33.67373], [-117.63989, 33.67389], [-117.64057, 33.67344], [-117.64131, 33.67369], [-117.64286, 33.67306], [-117.64298, 33.6731], [-117.64325, 33.67362]]], [[[-117.62933, 33.67264], [-117.62921, 33.67291], [-117.62904, 33.67296], [-117.62902, 33.67324], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62811, 33.6739], [-117.62741, 33.67443], [-117.6274, 33.67445], [-117.62742, 33.67454], [-117.62713, 33.67635], [-117.62769, 33.67748], [-117.62828, 33.6782], [-117.62825, 33.67847], [-117.62584, 33.67843], [-117.62624, 33.6778], [-117.62581, 33.67774], [-117.62509, 33.67727], [-117.62411, 33.6771], [-117.62332, 33.67849], [-117.62262, 33.67874], [-117.62302, 33.67832], [-117.62312, 33.67815], [-117.62321, 33.6779], [-117.62323, 33.67763], [-117.62319, 33.67729], [-117.62319, 33.67693], [-117.6233, 33.67558], [-117.62334, 33.6754], [-117.62341, 33.67522], [-117.62454, 33.67293], [-117.62465, 33.67273], [-117.6248, 33.67255], [-117.62609, 33.67111], [-117.62625, 33.67089], [-117.62656, 33.67039], [-117.62711, 33.67054], [-117.6275, 33.6706], [-117.62801, 33.67065], [-117.62852, 33.67064], [-117.62831, 33.67076], [-117.62819, 33.6715], [-117.62814, 33.67166], [-117.62819, 33.67192], [-117.62831, 33.67197], [-117.62839, 33.67193], [-117.6288, 33.67221], [-117.6289, 33.67225], [-117.62892, 33.67235], [-117.62911, 33.67256], [-117.62933, 33.67264]]], [[[-117.62818, 33.67926], [-117.62816, 33.67951], [-117.62785, 33.67967], [-117.62793, 33.68043], [-117.62796, 33.68056], [-117.62747, 33.67986], [-117.62724, 33.67942], [-117.62762, 33.67919], [-117.62818, 33.67926]]], [[[-117.67003, 33.69267], [-117.66497, 33.69736], [-117.66518, 33.69668], [-117.66527, 33.696], [-117.6653, 33.69544], [-117.66545, 33.69503], [-117.66563, 33.69481], [-117.66562, 33.69444], [-117.66582, 33.69421], [-117.66548, 33.69361], [-117.66517, 33.69345], [-117.66481, 33.69282], [-117.66409, 33.69308], [-117.66377, 33.69299], [-117.66341, 33.69274], [-117.66317, 33.69252], [-117.66279, 33.69231], [-117.66343, 33.69231], [-117.66409, 33.69284], [-117.66469, 33.69278], [-117.66531, 33.69207], [-117.66632, 33.69194], [-117.66744, 33.69202], [-117.66785, 33.69213], [-117.66811, 33.69265], [-117.67003, 33.69267]]], [[[-117.66278, 33.6923], [-117.66253, 33.69217], [-117.66251, 33.69236], [-117.662, 33.6933], [-117.6617, 33.69418], [-117.66131, 33.69456], [-117.66157, 33.69554], [-117.66238, 33.69629], [-117.66316, 33.69673], [-117.66412, 33.69756], [-117.66445, 33.69758], [-117.66484, 33.69736], [-117.66494, 33.69738], [-117.65489, 33.70668], [-117.64798, 33.70618], [-117.64242, 33.70397], [-117.64241, 33.70309], [-117.64214, 33.70266], [-117.64233, 33.7021], [-117.64229, 33.70182], [-117.64211, 33.70155], [-117.64141, 33.70127], [-117.64118, 33.70066], [-117.64083, 33.70051], [-117.64053, 33.7004], [-117.64052, 33.69999], [-117.64034, 33.69985], [-117.63921, 33.6992], [-117.63894, 33.69899], [-117.6381, 33.69847], [-117.63739, 33.69845], [-117.63687, 33.69835], [-117.63647, 33.69813], [-117.6363, 33.69811], [-117.64125, 33.6841], [-117.64074, 33.6846], [-117.63789, 33.69264], [-117.63754, 33.69249], [-117.63753, 33.69249], [-117.63562, 33.69804], [-117.63504, 33.69794], [-117.63454, 33.69778], [-117.63403, 33.69747], [-117.6334, 33.69687], [-117.63306, 33.69641], [-117.63294, 33.69617], [-117.63268, 33.6958], [-117.63247, 33.69554], [-117.63209, 33.6952], [-117.63182, 33.69499], [-117.63148, 33.69479], [-117.63048, 33.6943], [-117.62999, 33.69403], [-117.62972, 33.69386], [-117.62948, 33.69367], [-117.62789, 33.69231], [-117.62674, 33.69061], [-117.62905, 33.68955], [-117.63084, 33.68945], [-117.63082, 33.68827], [-117.63099, 33.68826], [-117.63097, 33.68812], [-117.63099, 33.688], [-117.63113, 33.6876], [-117.63114, 33.68749], [-117.63121, 33.68741], [-117.63145, 33.68724], [-117.63154, 33.68712], [-117.63165, 33.68717], [-117.632, 33.68712], [-117.63204, 33.68703], [-117.632, 33.68806], [-117.63276, 33.68804], [-117.63335, 33.6877], [-117.63373, 33.68669], [-117.63605, 33.68639], [-117.63553, 33.68544], [-117.63558, 33.68513], [-117.63647, 33.68432], [-117.63916, 33.68441], [-117.64016, 33.68348], [-117.64012, 33.68057], [-117.64039, 33.6806], [-117.6404, 33.68059], [-117.64008, 33.68034], [-117.64158, 33.67948], [-117.64048, 33.67786], [-117.63978, 33.67829], [-117.63914, 33.67832], [-117.63918, 33.67806], [-117.63918, 33.67781], [-117.63914, 33.67755], [-117.63902, 33.67727], [-117.63907, 33.67725], [-117.63919, 33.67741], [-117.63945, 33.67739], [-117.63963, 33.67749], [-117.64005, 33.67737], [-117.64039, 33.67708], [-117.6405, 33.67681], [-117.64036, 33.67652], [-117.64023, 33.67637], [-117.64016, 33.67635], [-117.64031, 33.67601], [-117.64034, 33.67574], [-117.64033, 33.67562], [-117.64024, 33.67544], [-117.63998, 33.67516], [-117.63986, 33.67495], [-117.63973, 33.67483], [-117.63955, 33.67471], [-117.6386, 33.67441], [-117.63912, 33.67445], [-117.63947, 33.67445], [-117.6398, 33.67443], [-117.6398, 33.6744], [-117.64021, 33.67435], [-117.64258, 33.67394], [-117.64289, 33.67391], [-117.64336, 33.67389], [-117.64357, 33.67431], [-117.64289, 33.67635], [-117.6429, 33.67636], [-117.64403, 33.67567], [-117.64451, 33.67424], [-117.64435, 33.67392], [-117.64464, 33.67393], [-117.64478, 33.67421], [-117.64504, 33.67421], [-117.64506, 33.67393], [-117.64575, 33.6739], [-117.6462, 33.67384], [-117.64665, 33.67375], [-117.64709, 33.67364], [-117.64774, 33.67342], [-117.64951, 33.67274], [-117.651, 33.67218], [-117.6514, 33.67201], [-117.65197, 33.67169], [-117.65229, 33.67172], [-117.65252, 33.67189], [-117.65276, 33.67206], [-117.65394, 33.67274], [-117.65382, 33.67289], [-117.65304, 33.67289], [-117.65296, 33.67317], [-117.65275, 33.67324], [-117.65232, 33.67322], [-117.65223, 33.67339], [-117.65167, 33.67342], [-117.65144, 33.67336], [-117.65108, 33.67338], [-117.6507, 33.67333], [-117.65032, 33.67353], [-117.65009, 33.67373], [-117.64999, 33.67394], [-117.64975, 33.67409], [-117.64953, 33.67438], [-117.64934, 33.67458], [-117.6492, 33.67488], [-117.64907, 33.67534], [-117.64904, 33.67538], [-117.64898, 33.67563], [-117.64882, 33.67569], [-117.64867, 33.67616], [-117.6485, 33.6764], [-117.6485, 33.67655], [-117.64834, 33.67672], [-117.64831, 33.67681], [-117.64831, 33.6769], [-117.64834, 33.67698], [-117.64858, 33.67725], [-117.64899, 33.67747], [-117.64893, 33.67765], [-117.6491, 33.67782], [-117.64902, 33.67826], [-117.64887, 33.67829], [-117.64886, 33.67835], [-117.64902, 33.67855], [-117.64923, 33.6787], [-117.6492, 33.67894], [-117.64916, 33.67898], [-117.64922, 33.67901], [-117.64916, 33.67906], [-117.64905, 33.67907], [-117.649, 33.6791], [-117.64899, 33.67915], [-117.6491, 33.67933], [-117.64909, 33.67938], [-117.64825, 33.67924], [-117.64765, 33.67973], [-117.64765, 33.67977], [-117.64773, 33.67987], [-117.64771, 33.68004], [-117.64789, 33.68031], [-117.64801, 33.68038], [-117.64806, 33.68042], [-117.64791, 33.68056], [-117.64784, 33.68109], [-117.6479, 33.68174], [-117.64796, 33.68184], [-117.64791, 33.68198], [-117.64785, 33.68266], [-117.64788, 33.6828], [-117.64786, 33.6831], [-117.64788, 33.68375], [-117.64798, 33.68464], [-117.64804, 33.68468], [-117.64799, 33.68472], [-117.6481, 33.6854], [-117.64828, 33.6858], [-117.64826, 33.68628], [-117.64833, 33.68654], [-117.6483, 33.68659], [-117.64834, 33.68681], [-117.64837, 33.68685], [-117.64838, 33.68694], [-117.64851, 33.68744], [-117.64882, 33.68769], [-117.64885, 33.68769], [-117.6489, 33.68781], [-117.64882, 33.68783], [-117.64859, 33.68805], [-117.64879, 33.68904], [-117.6495, 33.68971], [-117.64982, 33.68991], [-117.6505, 33.6898], [-117.65081, 33.6899], [-117.65094, 33.68999], [-117.65101, 33.69007], [-117.65105, 33.69017], [-117.65107, 33.69028], [-117.65105, 33.69037], [-117.65101, 33.69041], [-117.65095, 33.69045], [-117.65087, 33.69044], [-117.65077, 33.69037], [-117.65066, 33.69033], [-117.65058, 33.69034], [-117.65047, 33.69038], [-117.65041, 33.69047], [-117.6504, 33.69058], [-117.65045, 33.69067], [-117.65055, 33.69074], [-117.65068, 33.69075], [-117.6508, 33.69071], [-117.65086, 33.69066], [-117.65094, 33.69055], [-117.65109, 33.69042], [-117.65113, 33.69035], [-117.65114, 33.69027], [-117.65111, 33.69015], [-117.65103, 33.69], [-117.65089, 33.68988], [-117.65066, 33.68979], [-117.65087, 33.68978], [-117.65111, 33.68985], [-117.6515, 33.69013], [-117.65188, 33.69036], [-117.65227, 33.69051], [-117.65258, 33.69052], [-117.65312, 33.6904], [-117.65406, 33.69068], [-117.65431, 33.69144], [-117.6551, 33.69154], [-117.65621, 33.6909], [-117.6565, 33.69061], [-117.65657, 33.69052], [-117.65661, 33.69041], [-117.65661, 33.6903], [-117.65655, 33.69015], [-117.65663, 33.69011], [-117.65686, 33.69005], [-117.65701, 33.68986], [-117.65705, 33.68989], [-117.65737, 33.68989], [-117.65677, 33.68942], [-117.65682, 33.68903], [-117.65669, 33.6889], [-117.6567, 33.68886], [-117.65661, 33.68874], [-117.657, 33.6886], [-117.65709, 33.68855], [-117.65702, 33.68835], [-117.65774, 33.68792], [-117.65788, 33.68767], [-117.65788, 33.68748], [-117.65805, 33.68737], [-117.65913, 33.68535], [-117.65959, 33.68511], [-117.65959, 33.68507], [-117.65979, 33.68504], [-117.6601, 33.68509], [-117.66043, 33.68508], [-117.66092, 33.68471], [-117.6609, 33.68449], [-117.66086, 33.68437], [-117.66111, 33.68414], [-117.66145, 33.68412], [-117.66171, 33.68395], [-117.66181, 33.68382], [-117.66184, 33.68369], [-117.6618, 33.68354], [-117.66188, 33.68354], [-117.66218, 33.68338], [-117.66216, 33.68335], [-117.66309, 33.68287], [-117.66447, 33.68141], [-117.66446, 33.68139], [-117.66373, 33.68134], [-117.66378, 33.6809], [-117.6646, 33.68053], [-117.66503, 33.68126], [-117.66534, 33.68182], [-117.66466, 33.68197], [-117.66427, 33.68226], [-117.66442, 33.68243], [-117.66419, 33.68257], [-117.66405, 33.68271], [-117.66392, 33.68292], [-117.66378, 33.68338], [-117.66338, 33.68334], [-117.66335, 33.68351], [-117.66329, 33.68358], [-117.66273, 33.68383], [-117.66199, 33.6843], [-117.66177, 33.68431], [-117.66137, 33.68444], [-117.66104, 33.68474], [-117.66088, 33.68508], [-117.66087, 33.68542], [-117.66129, 33.68621], [-117.66104, 33.68641], [-117.66071, 33.68586], [-117.66028, 33.68583], [-117.65981, 33.68594], [-117.65902, 33.68647], [-117.65877, 33.68677], [-117.65869, 33.6873], [-117.65883, 33.68796], [-117.65876, 33.68874], [-117.65826, 33.68956], [-117.65825, 33.68994], [-117.6579, 33.69017], [-117.65791, 33.69018], [-117.65857, 33.69019], [-117.65905, 33.69033], [-117.65955, 33.69106], [-117.66032, 33.69165], [-117.66093, 33.69153], [-117.66248, 33.69179], [-117.66278, 33.6923]]]]} | Open Access 1 | 4176 | Whiting Ranch Wilderness Park | 32175 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/parks/whiting | Orange 3 | 1644.529 | Whiting Ranch Wilderness Park | 0 | Local Conservation Area 4 | 2 |
6620 | 6620 | 6619 | {"type": "MultiPolygon", "coordinates": [[[[-119.50852, 34.39516], [-119.50697, 34.39588], [-119.50689, 34.39577], [-119.5075, 34.3955], [-119.50841, 34.395], [-119.50852, 34.39516]]], [[[-119.50986, 34.39487], [-119.50965, 34.39489], [-119.50944, 34.39484], [-119.50927, 34.39472], [-119.50912, 34.39453], [-119.50904, 34.39446], [-119.50888, 34.39438], [-119.50873, 34.39436], [-119.5086, 34.39437], [-119.50821, 34.39482], [-119.50804, 34.39483], [-119.50784, 34.39456], [-119.50791, 34.39452], [-119.50809, 34.39429], [-119.50817, 34.39415], [-119.50814, 34.39411], [-119.50831, 34.39392], [-119.50859, 34.39368], [-119.50859, 34.3931], [-119.50876, 34.39344], [-119.50894, 34.39363], [-119.50974, 34.39478], [-119.5098, 34.39476], [-119.50986, 34.39487]]]]} | Unknown Access 4 | 4305 | Carpinteria Creek | 16896 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 3.634 | Carpinteria Creek | 0 | Local Other or Unknown 14 | 4 | |
6629 | 6629 | 6628 | {"type": "Polygon", "coordinates": [[[-117.61031, 33.64797], [-117.61017, 33.64805], [-117.60994, 33.64812], [-117.60981, 33.64818], [-117.60961, 33.64834], [-117.60957, 33.64841], [-117.60956, 33.64848], [-117.6096, 33.64857], [-117.60991, 33.64887], [-117.61001, 33.64902], [-117.61003, 33.64908], [-117.61, 33.64911], [-117.60957, 33.64928], [-117.60952, 33.64936], [-117.60953, 33.64945], [-117.60924, 33.64954], [-117.60928, 33.64947], [-117.60912, 33.64938], [-117.609, 33.64924], [-117.6092, 33.64915], [-117.60923, 33.64911], [-117.60917, 33.64897], [-117.60904, 33.6488], [-117.60899, 33.64862], [-117.60894, 33.64857], [-117.6091, 33.64835], [-117.60916, 33.64831], [-117.60923, 33.64833], [-117.60934, 33.64843], [-117.60942, 33.64844], [-117.60956, 33.64815], [-117.60969, 33.64818], [-117.60975, 33.6481], [-117.60982, 33.64806], [-117.60987, 33.64799], [-117.60993, 33.64798], [-117.6101, 33.6479], [-117.61025, 33.64796], [-117.61029, 33.64795], [-117.61031, 33.64797]]]} | Open Access 1 | 4357 | Estrella Vista Park | 18731 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.124 | Estrella Vista Park | 0 | Local Park 2 | 4 | |
6687 | 6687 | 6686 | {"type": "Polygon", "coordinates": [[[-116.92088, 32.85993], [-116.9178, 32.86035], [-116.91751, 32.86037], [-116.91746, 32.86039], [-116.91742, 32.86035], [-116.91622, 32.8598], [-116.91318, 32.85833], [-116.91254, 32.85841], [-116.91224, 32.85676], [-116.91305, 32.85644], [-116.91363, 32.85637], [-116.91375, 32.85656], [-116.91402, 32.85653], [-116.91407, 32.8568], [-116.91465, 32.85672], [-116.91468, 32.85685], [-116.91509, 32.85681], [-116.91526, 32.85677], [-116.91592, 32.85668], [-116.91599, 32.85711], [-116.9161, 32.85721], [-116.91627, 32.85723], [-116.91776, 32.85703], [-116.91824, 32.85695], [-116.9183, 32.8569], [-116.91832, 32.85684], [-116.91826, 32.85653], [-116.91907, 32.85643], [-116.91937, 32.85652], [-116.91959, 32.85772], [-116.92044, 32.8576], [-116.92088, 32.85993]]]} | Open Access 1 | 4881 | Lindo Lake Park | 29244 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LindoLake.html | San Diego 4 | 57.094 | Lindo Lake Park | 0 | Local Park 2 | 4 |
6692 | 6692 | 6691 | {"type": "Polygon", "coordinates": [[[-116.92544, 32.74521], [-116.92529, 32.74527], [-116.92388, 32.74556], [-116.92186, 32.74538], [-116.92193, 32.7451], [-116.92209, 32.74475], [-116.92224, 32.74452], [-116.9224, 32.74436], [-116.92264, 32.74419], [-116.9229, 32.74407], [-116.92313, 32.74401], [-116.92344, 32.74397], [-116.92381, 32.744], [-116.92395, 32.74404], [-116.92412, 32.74409], [-116.92441, 32.74424], [-116.92459, 32.74438], [-116.92544, 32.74521]]]} | Open Access 1 | 4972 | Hilton Head Park | 19997 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/HiltonHead.html | San Diego 4 | 9.882 | Hilton Head Park | 0 | Local Park 2 | 4 |
6696 | 6696 | 6695 | {"type": "Polygon", "coordinates": [[[-116.95847, 32.74943], [-116.95847, 32.75121], [-116.95732, 32.75118], [-116.95732, 32.74942], [-116.95847, 32.74943]]]} | Open Access 1 | 4976 | Lonny Brewer Park | 29245 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LonnyBrewer.html | San Diego 4 | 5.232 | Lonny Brewer Park | 0 | Local Park 2 | 4 |
6699 | 6699 | 6698 | {"type": "Polygon", "coordinates": [[[-116.91331, 32.73733], [-116.9132, 32.73762], [-116.91318, 32.73772], [-116.91317, 32.73796], [-116.91319, 32.7381], [-116.91135, 32.7385], [-116.91054, 32.73884], [-116.91055, 32.73722], [-116.91319, 32.73724], [-116.91331, 32.73733]]]} | Open Access 1 | 4984 | Steele Canyon Park | 25819 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SteeleCanyon.html | San Diego 4 | 8.122 | Steele Canyon Park | 0 | Local Park 2 | 4 |
6700 | 6700 | 6699 | {"type": "Polygon", "coordinates": [[[-116.91742, 32.75157], [-116.91715, 32.75181], [-116.9163, 32.75233], [-116.91649, 32.75258], [-116.91616, 32.75277], [-116.91612, 32.75277], [-116.91608, 32.75275], [-116.91571, 32.75227], [-116.9156, 32.75217], [-116.91491, 32.75174], [-116.9151, 32.75147], [-116.91522, 32.75105], [-116.91702, 32.75139], [-116.91725, 32.75147], [-116.91742, 32.75157]]]} | Open Access 1 | 4985 | Cottonwood County Park | 29270 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cottonwood.html | San Diego 4 | 5.47 | Cottonwood County Park | 0 | Local Park 2 | 4 |
6703 | 6703 | 6702 | {"type": "Polygon", "coordinates": [[[-116.94512, 32.75532], [-116.94511, 32.75706], [-116.94501, 32.75707], [-116.94501, 32.75859], [-116.94202, 32.75855], [-116.94197, 32.75818], [-116.94278, 32.7581], [-116.94286, 32.75813], [-116.94295, 32.75812], [-116.94301, 32.75808], [-116.94303, 32.75805], [-116.94303, 32.758], [-116.94301, 32.75794], [-116.94294, 32.75789], [-116.94297, 32.75783], [-116.94254, 32.75687], [-116.94212, 32.75672], [-116.94171, 32.75665], [-116.94122, 32.7557], [-116.94096, 32.75447], [-116.94109, 32.75444], [-116.94116, 32.75429], [-116.94127, 32.75428], [-116.94133, 32.75425], [-116.94136, 32.7542], [-116.94165, 32.75423], [-116.94281, 32.75501], [-116.94287, 32.75503], [-116.94512, 32.75532]]]} | Open Access 1 | 5000 | Damon Lane Park | 17902 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/DamonLane.html | San Diego 4 | 29.5 | Damon Lane Park | 0 | Local Park 2 | 4 |
6705 | 6705 | 6704 | {"type": "Polygon", "coordinates": [[[-117.00204, 32.76133], [-117.00199, 32.76124], [-117.00192, 32.76106], [-117.00179, 32.76094], [-117.00165, 32.76087], [-117.00111, 32.76077], [-117.00098, 32.76071], [-117.00094, 32.76067], [-117.0009, 32.76055], [-117.00109, 32.76047], [-117.00102, 32.76025], [-117.00045, 32.75882], [-117.00166, 32.75882], [-117.00223, 32.76019], [-117.00229, 32.76049], [-117.00228, 32.76074], [-117.00221, 32.76103], [-117.0021, 32.76124], [-117.00204, 32.76133]]]} | Open Access 1 | 5007 | Eucalyptus Park | 18739 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Eucalyptus.html | San Diego 4 | 6.737 | Eucalyptus Park | 0 | Local Park 2 | 4 |
6707 | 6707 | 6706 | {"type": "Polygon", "coordinates": [[[-116.91296, 32.75687], [-116.91276, 32.75701], [-116.91261, 32.75719], [-116.91188, 32.75864], [-116.91182, 32.75873], [-116.9117, 32.75885], [-116.91165, 32.7589], [-116.91152, 32.75896], [-116.9113, 32.75902], [-116.91117, 32.75904], [-116.91059, 32.75906], [-116.91052, 32.75901], [-116.91047, 32.75878], [-116.91034, 32.75853], [-116.91033, 32.75848], [-116.91058, 32.75828], [-116.91181, 32.75682], [-116.91193, 32.7567], [-116.91216, 32.75651], [-116.91231, 32.75641], [-116.91258, 32.75627], [-116.91296, 32.75687]]]} | Open Access 1 | 5011 | Woodhaven Park | 27713 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Woodhaven.html | San Diego 4 | 8.241 | Woodhaven Park | 0 | Local Park 2 | 4 |
6709 | 6709 | 6708 | {"type": "MultiPolygon", "coordinates": [[[[-116.91484, 32.86884], [-116.91485, 32.87034], [-116.91482, 32.87063], [-116.91469, 32.87097], [-116.91454, 32.87121], [-116.91438, 32.87142], [-116.91412, 32.87164], [-116.91342, 32.87076], [-116.91262, 32.87037], [-116.91096, 32.87045], [-116.91023, 32.86652], [-116.91402, 32.86599], [-116.91456, 32.86881], [-116.91484, 32.86884]]], [[[-116.91825, 32.86993], [-116.91733, 32.87197], [-116.91627, 32.87239], [-116.91504, 32.87239], [-116.91426, 32.87179], [-116.91425, 32.87177], [-116.91446, 32.87159], [-116.91462, 32.87141], [-116.91477, 32.8712], [-116.91487, 32.87103], [-116.91497, 32.87078], [-116.91502, 32.87058], [-116.91505, 32.87035], [-116.91505, 32.8701], [-116.91599, 32.87019], [-116.91531, 32.87033], [-116.91536, 32.87052], [-116.91825, 32.86993]]]]} | Open Access 1 | 5036 | Cactus Park | 16651 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/Cactus.html | San Diego 4 | 61.039 | Cactus Park | 0 | Local Park 2 | 4 |
6710 | 6710 | 6709 | {"type": "MultiPolygon", "coordinates": [[[[-116.90763, 32.87806], [-116.90721, 32.87867], [-116.90721, 32.87871], [-116.90698, 32.879], [-116.90668, 32.87927], [-116.90649, 32.87941], [-116.90432, 32.88052], [-116.90174, 32.88203], [-116.90134, 32.8822], [-116.90115, 32.88225], [-116.89874, 32.88282], [-116.89861, 32.88285], [-116.89823, 32.88287], [-116.89801, 32.88292], [-116.89772, 32.88301], [-116.89763, 32.88306], [-116.89755, 32.88308], [-116.89746, 32.88313], [-116.89712, 32.88341], [-116.89643, 32.88418], [-116.89602, 32.8847], [-116.8937, 32.88526], [-116.89377, 32.88553], [-116.89326, 32.88568], [-116.89333, 32.87228], [-116.89461, 32.87253], [-116.89385, 32.87529], [-116.90763, 32.87806]]], [[[-116.91612, 32.8798], [-116.91533, 32.88], [-116.91443, 32.88025], [-116.91461, 32.88611], [-116.91193, 32.8861], [-116.91275, 32.88473], [-116.91275, 32.88472], [-116.90853, 32.88469], [-116.91044, 32.88128], [-116.91044, 32.88126], [-116.89608, 32.88496], [-116.89638, 32.88452], [-116.89673, 32.88412], [-116.89734, 32.88345], [-116.89756, 32.88328], [-116.89769, 32.88321], [-116.89795, 32.8831], [-116.89825, 32.88304], [-116.89878, 32.88298], [-116.90121, 32.88242], [-116.90161, 32.88228], [-116.90183, 32.88218], [-116.90438, 32.88069], [-116.90646, 32.87962], [-116.90693, 32.87931], [-116.9073, 32.87891], [-116.90782, 32.8781], [-116.90806, 32.87814], [-116.90832, 32.87735], [-116.90834, 32.87732], [-116.90847, 32.87721], [-116.90859, 32.87714], [-116.90928, 32.87684], [-116.90946, 32.87672], [-116.90948, 32.87671], [-116.90903, 32.87835], [-116.91612, 32.8798]]]]} | Open Access 1 | 5026 | Louis Stelzer County Park | 28941 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LouisStelzer.html | San Diego 4 | 367.724 | Louis Stelzer County Park | 0 | Local Park 2 | 4 |
6722 | 6722 | 6721 | {"type": "Polygon", "coordinates": [[[-116.86518, 32.80929], [-116.86498, 32.80983], [-116.8637, 32.80982], [-116.86371, 32.80929], [-116.86518, 32.80929]]]} | Open Access 1 | 5038 | Nancy Jane County Park | 22624 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/NancyJane.html | San Diego 4 | 1.898 | Nancy Jane County Park | 0 | Local Park 2 | 4 |
6725 | 6725 | 6724 | {"type": "Polygon", "coordinates": [[[-116.86746, 32.80088], [-116.86746, 32.80106], [-116.86742, 32.80116], [-116.86697, 32.8015], [-116.86692, 32.80156], [-116.86688, 32.80166], [-116.86692, 32.80185], [-116.86669, 32.80238], [-116.86667, 32.80345], [-116.86669, 32.80397], [-116.86572, 32.80394], [-116.86574, 32.80243], [-116.86574, 32.80071], [-116.86746, 32.80088]]]} | Open Access 1 | 5047 | South Lane Park | 25663 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/SouthLane.html | San Diego 4 | 9.208 | South Lane Park | 0 | Local Park 2 | 4 |
6729 | 6729 | 6728 | {"type": "MultiPolygon", "coordinates": [[[[-119.77531, 34.45209], [-119.77531, 34.45312], [-119.7686, 34.454], [-119.76861, 34.45071], [-119.76859, 34.44934], [-119.77006, 34.44971], [-119.77438, 34.45153], [-119.77495, 34.45195], [-119.77531, 34.45209]], [[-119.76965, 34.45139], [-119.76974, 34.4514], [-119.76981, 34.45116], [-119.76932, 34.4508], [-119.76873, 34.45061], [-119.76873, 34.45135], [-119.76877, 34.45142], [-119.7692, 34.45152], [-119.76925, 34.45137], [-119.76929, 34.45138], [-119.7693, 34.45136], [-119.76933, 34.45136], [-119.76934, 34.45134], [-119.76959, 34.45138], [-119.76963, 34.4514], [-119.76965, 34.45139]]], [[[-119.77683, 34.45222], [-119.77667, 34.45302], [-119.77675, 34.45338], [-119.77595, 34.45341], [-119.7759, 34.45326], [-119.77589, 34.45311], [-119.77602, 34.45211], [-119.77683, 34.45222]]]]} | Unknown Access 4 | 5091 | Cathedral Oaks Fire Center | 16974 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 51.634 | Cathedral Oaks Fire Ctr. | 0 | Local Recreation Area 3 | 4 | |
6739 | 6739 | 6738 | {"type": "Polygon", "coordinates": [[[-116.1145, 32.65367], [-116.10581, 32.65366], [-116.10581, 32.64737], [-116.10624, 32.6465], [-116.11446, 32.64653], [-116.1145, 32.65367]]]} | Open Access 1 | 5151 | County Open Space | 29240 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 158.984 | County OS | 0 | Local Recreation Area 3 | 4 | |
6746 | 6746 | 6745 | {"type": "Polygon", "coordinates": [[[-117.97585, 34.00262], [-117.97532, 34.00429], [-117.97272, 34.0035], [-117.97327, 34.00182], [-117.97585, 34.00262]]]} | Open Access 1 | 5089 | Manzanita Park | 21767 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 12.116 | Manzanita Park | 0 | Local Park 2 | 4 | |
6772 | 6772 | 6771 | {"type": "MultiPolygon", "coordinates": [[[[-116.85271, 32.89302], [-116.85016, 32.89317], [-116.85014, 32.89281], [-116.84423, 32.89275], [-116.84295, 32.89205], [-116.84351, 32.8922], [-116.84518, 32.89238], [-116.84573, 32.89242], [-116.84616, 32.89241], [-116.84661, 32.89238], [-116.84788, 32.89222], [-116.8482, 32.89215], [-116.84849, 32.89204], [-116.84878, 32.89189], [-116.84902, 32.89172], [-116.84923, 32.89151], [-116.84936, 32.89135], [-116.84947, 32.89115], [-116.84995, 32.89012], [-116.85271, 32.89302]]], [[[-116.85018, 32.88908], [-116.85003, 32.88947], [-116.84931, 32.89106], [-116.84921, 32.89122], [-116.84905, 32.89144], [-116.84886, 32.89162], [-116.84863, 32.89178], [-116.8484, 32.8919], [-116.84815, 32.89199], [-116.84785, 32.89205], [-116.8466, 32.89221], [-116.84599, 32.89225], [-116.84526, 32.89223], [-116.84343, 32.89201], [-116.84478, 32.88919], [-116.84558, 32.8872], [-116.84609, 32.88674], [-116.84638, 32.88601], [-116.84995, 32.88843], [-116.85002, 32.8885], [-116.85007, 32.88858], [-116.85018, 32.88908]]]]} | Open Access 1 | 5237 | El Monte Park | 18518 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/ElMonte.html | San Diego 4 | 87.505 | El Monte 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]);