units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
210 rows where ACCESS_TYP = 2 and DES_TP = 2 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY >30
- Whittier, City of 20
- Los Angeles Unified School District 15
- San Ramon, City of 13
- Los Angeles, City of 7
- East Bay Regional Park District 7
- Arcadia, City of 7
- Manhattan Beach, City of 7
- Beverly Hills, City of 5
- San Diego, City of 4
- Fullerton, City of 4
- Vacaville, City of 4
- Hollister, City of 4
- Hayward Area Recreation and Park District 4
- Pasadena, City of 4
- Lawndale, City of 4
- Modesto, City of 4
- Azusa Unified School District 4
- Glendora, City of 3
- Carlsbad, City of 3
- Palmdale, City of 3
- Mountain View, City of 3
- Conejo Valley Unified School District 3
- Los Angeles, County of 2
- Garden Grove, City of 2
- Oceanside, City of 2
- Orange, County of 2
- Lake Elsinore, City of 2
- Cerritos, City of 2
- Bell Gardens, City of 2
- Long Beach, City of 2
- …
MNG_AG_TYP 7
DES_TP 1
- Local Park · 210 ✖
ACCESS_TYP 1
- Restricted Access · 210 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16836 | 16836 | 16835 | {"type": "Polygon", "coordinates": [[[-121.88013, 38.03876], [-121.8799, 38.03947], [-121.87888, 38.03985], [-121.87938, 38.04057], [-121.87831, 38.04152], [-121.87674, 38.04095], [-121.8754, 38.04202], [-121.87585, 38.04277], [-121.87563, 38.04308], [-121.87538, 38.04357], [-121.87321, 38.04374], [-121.87163, 38.04436], [-121.86986, 38.04524], [-121.86868, 38.04556], [-121.86677, 38.04663], [-121.86586, 38.04647], [-121.86463, 38.04548], [-121.86456, 38.04549], [-121.86457, 38.04022], [-121.869, 38.04023], [-121.86901, 38.03651], [-121.86606, 38.03563], [-121.85991, 38.03561], [-121.85989, 38.04021], [-121.8644, 38.04022], [-121.86438, 38.04552], [-121.8629, 38.0458], [-121.86169, 38.04609], [-121.86089, 38.04681], [-121.86099, 38.04761], [-121.86205, 38.04829], [-121.86179, 38.04832], [-121.86114, 38.04802], [-121.86065, 38.04767], [-121.86064, 38.04741], [-121.86029, 38.04715], [-121.85877, 38.04615], [-121.85643, 38.04435], [-121.85513, 38.04328], [-121.85323, 38.04205], [-121.85256, 38.04052], [-121.85138, 38.03899], [-121.85147, 38.03731], [-121.85092, 38.03582], [-121.85024, 38.03499], [-121.85207, 38.03389], [-121.85368, 38.03368], [-121.85526, 38.03272], [-121.85876, 38.03221], [-121.8607, 38.03229], [-121.86306, 38.03258], [-121.86702, 38.03277], [-121.86921, 38.03335], [-121.87099, 38.03432], [-121.87408, 38.03568], [-121.87734, 38.03749], [-121.87896, 38.03836], [-121.88013, 38.03876]]]} | Restricted Access 2 | 3883 | Browns Island Regional Shoreline | 16445 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 600.69 | Browns Island Reg. Shoreline | 0 | Local Park 2 | 4 | |
4372 | 4372 | 4371 | {"type": "Polygon", "coordinates": [[[-118.22505, 33.96758], [-118.22454, 33.96753], [-118.22448, 33.9675], [-118.22431, 33.96734], [-118.22437, 33.96694], [-118.22436, 33.96693], [-118.22415, 33.96711], [-118.22327, 33.96702], [-118.22323, 33.96723], [-118.22254, 33.96715], [-118.22254, 33.96649], [-118.22474, 33.96672], [-118.22469, 33.96704], [-118.22505, 33.96708], [-118.22505, 33.96758]]]} | Restricted Access 2 | 45864 | Walnut Nature Park | 28911 | 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 | 3.587 | Walnut Nature Park | 0 | Local Park 2 | 4 | |
12699 | 12699 | 12698 | {"type": "MultiPolygon", "coordinates": [[[[-117.70985, 33.67857], [-117.7089, 33.67965], [-117.70712, 33.67964], [-117.70551, 33.68029], [-117.70462, 33.67998], [-117.70337, 33.67949], [-117.70257, 33.67965], [-117.70248, 33.6802], [-117.70115, 33.68143], [-117.70088, 33.68206], [-117.70139, 33.68338], [-117.69594, 33.68515], [-117.6951, 33.68578], [-117.69508, 33.68911], [-117.69505, 33.68948], [-117.69478, 33.68978], [-117.69023, 33.69323], [-117.68884, 33.69254], [-117.68876, 33.69247], [-117.68787, 33.69196], [-117.68749, 33.69171], [-117.68755, 33.69165], [-117.68754, 33.69164], [-117.68635, 33.69082], [-117.67818, 33.68513], [-117.68319, 33.67915], [-117.69036, 33.67056], [-117.69217, 33.67013], [-117.69313, 33.66987], [-117.69507, 33.66931], [-117.69685, 33.66873], [-117.69785, 33.66839], [-117.69877, 33.66805], [-117.69997, 33.66759], [-117.70039, 33.66788], [-117.70076, 33.66776], [-117.70424, 33.67016], [-117.70603, 33.66837], [-117.7061, 33.66899], [-117.70616, 33.66928], [-117.70626, 33.66967], [-117.70637, 33.66995], [-117.70653, 33.67033], [-117.70677, 33.67078], [-117.70713, 33.67129], [-117.70755, 33.67177], [-117.70803, 33.67222], [-117.70864, 33.67267], [-117.70621, 33.67513], [-117.70531, 33.67585], [-117.70522, 33.67578], [-117.70465, 33.67629], [-117.70484, 33.67656], [-117.706, 33.67671], [-117.70725, 33.677], [-117.70869, 33.67813], [-117.70985, 33.67857]]], [[[-117.73183, 33.66114], [-117.73182, 33.66147], [-117.73178, 33.66176], [-117.73168, 33.66208], [-117.73155, 33.66234], [-117.73132, 33.66266], [-117.73069, 33.66332], [-117.73045, 33.66361], [-117.73021, 33.66398], [-117.73005, 33.66431], [-117.72991, 33.66472], [-117.72984, 33.66507], [-117.72982, 33.66542], [-117.72982, 33.66638], [-117.72965, 33.66641], [-117.72953, 33.66647], [-117.72942, 33.66655], [-117.72935, 33.66665], [-117.7293, 33.66681], [-117.7293, 33.66736], [-117.72826, 33.66736], [-117.72818, 33.66621], [-117.72815, 33.66598], [-117.72806, 33.66564], [-117.72791, 33.66526], [-117.72777, 33.665], [-117.72763, 33.6648], [-117.72744, 33.66455], [-117.72727, 33.66437], [-117.72691, 33.66406], [-117.72669, 33.66392], [-117.7265, 33.66381], [-117.72621, 33.66369], [-117.72591, 33.6636], [-117.7256, 33.66354], [-117.72529, 33.66352], [-117.72501, 33.66352], [-117.72478, 33.66354], [-117.72425, 33.66364], [-117.72389, 33.66369], [-117.7236, 33.6637], [-117.72321, 33.66368], [-117.72275, 33.66361], [-117.72128, 33.66328], [-117.72102, 33.66324], [-117.72079, 33.66324], [-117.72051, 33.66328], [-117.72024, 33.66336], [-117.71925, 33.6638], [-117.719, 33.66392], [-117.71877, 33.66407], [-117.71826, 33.66446], [-117.71784, 33.66474], [-117.71728, 33.66506], [-117.71693, 33.66523], [-117.71645, 33.66544], [-117.71569, 33.66569], [-117.71518, 33.66582], [-117.7148, 33.6659], [-117.71398, 33.66601], [-117.71344, 33.66604], [-117.71303, 33.66604], [-117.71177, 33.66597], [-117.71149, 33.66597], [-117.71122, 33.666], [-117.711, 33.66603], [-117.71073, 33.6661], [-117.71048, 33.66619], [-117.71024, 33.6663], [-117.71001, 33.66643], [-117.70968, 33.66669], [-117.70846, 33.66803], [-117.70827, 33.66822], [-117.70802, 33.66841], [-117.70767, 33.66861], [-117.70727, 33.66876], [-117.70696, 33.66884], [-117.70651, 33.6689], [-117.70647, 33.66847], [-117.70646, 33.6681], [-117.70657, 33.66521], [-117.7067, 33.66503], [-117.70692, 33.6648], [-117.70758, 33.66415], [-117.70779, 33.66398], [-117.70812, 33.66374], [-117.70853, 33.66351], [-117.70885, 33.66336], [-117.70925, 33.66323], [-117.70973, 33.66311], [-117.71016, 33.66305], [-117.71052, 33.66303], [-117.71095, 33.66304], [-117.71408, 33.6599], [-117.72201, 33.6571], [-117.72501, 33.6541], [-117.72501, 33.65408], [-117.72416, 33.65347], [-117.72391, 33.65326], [-117.72364, 33.65297], [-117.72343, 33.6527], [-117.72324, 33.6524], [-117.72263, 33.65125], [-117.72328, 33.6506], [-117.72775, 33.65373], [-117.72755, 33.65396], [-117.72729, 33.65429], [-117.72711, 33.65457], [-117.72692, 33.65494], [-117.72677, 33.65531], [-117.72666, 33.6557], [-117.7266, 33.65602], [-117.72656, 33.65641], [-117.72656, 33.65681], [-117.72659, 33.65705], [-117.72664, 33.65737], [-117.72674, 33.65775], [-117.72688, 33.65813], [-117.72703, 33.65843], [-117.72719, 33.65872], [-117.72743, 33.65906], [-117.72783, 33.65951], [-117.72829, 33.65991], [-117.7288, 33.66027], [-117.72936, 33.66056], [-117.72988, 33.66078], [-117.7305, 33.66096], [-117.73116, 33.66108], [-117.73183, 33.66114]], [[-117.72422, 33.65519], [-117.72417, 33.65518], [-117.72416, 33.65519], [-117.72428, 33.65528], [-117.72422, 33.65519]]], [[[-117.72377, 33.67404], [-117.7199, 33.67417], [-117.71945, 33.67421], [-117.71903, 33.67427], [-117.71852, 33.67439], [-117.71805, 33.67454], [-117.71759, 33.67474], [-117.71723, 33.67494], [-117.7169, 33.67516], [-117.71659, 33.67539], [-117.71643, 33.67559], [-117.71636, 33.67574], [-117.71632, 33.67589], [-117.71633, 33.67682], [-117.7163, 33.67704], [-117.71624, 33.67726], [-117.71611, 33.67753], [-117.71594, 33.67776], [-117.7157, 33.67799], [-117.71546, 33.67816], [-117.71532, 33.67781], [-117.71514, 33.67745], [-117.71492, 33.6771], [-117.71468, 33.67676], [-117.71441, 33.67643], [-117.71411, 33.67612], [-117.71379, 33.67584], [-117.71344, 33.67556], [-117.71371, 33.67532], [-117.71406, 33.6751], [-117.71696, 33.67361], [-117.71746, 33.67339], [-117.71798, 33.67322], [-117.71852, 33.67309], [-117.71896, 33.67301], [-117.71974, 33.67293], [-117.722, 33.67285], [-117.72204, 33.67298], [-117.72212, 33.6731], [-117.72225, 33.6732], [-117.72238, 33.67325], [-117.72256, 33.67327], [-117.72346, 33.67324], [-117.72359, 33.67361], [-117.72377, 33.67404]]], [[[-117.73088, 33.68231], [-117.73091, 33.68384], [-117.73089, 33.68419], [-117.73084, 33.68452], [-117.73077, 33.68484], [-117.73062, 33.68527], [-117.7304, 33.68574], [-117.73019, 33.68608], [-117.72999, 33.68637], [-117.7298, 33.68659], [-117.72954, 33.68686], [-117.72924, 33.68713], [-117.72874, 33.68749], [-117.72788, 33.688], [-117.72715, 33.68849], [-117.72661, 33.68893], [-117.72583, 33.68972], [-117.72141, 33.68664], [-117.72176, 33.68629], [-117.72207, 33.68603], [-117.72237, 33.68584], [-117.72375, 33.68505], [-117.72411, 33.68478], [-117.72438, 33.68452], [-117.72464, 33.68418], [-117.72478, 33.68396], [-117.72487, 33.68377], [-117.72499, 33.68343], [-117.7251, 33.68291], [-117.72523, 33.68256], [-117.72535, 33.68237], [-117.72549, 33.68219], [-117.72574, 33.68194], [-117.72585, 33.68201], [-117.726, 33.68207], [-117.72612, 33.68208], [-117.72628, 33.68206], [-117.72644, 33.682], [-117.72708, 33.68162], [-117.72733, 33.68178], [-117.7277, 33.68195], [-117.728, 33.68206], [-117.72836, 33.68215], [-117.72857, 33.68218], [-117.73088, 33.68231]]], [[[-117.73948, 33.67501], [-117.73851, 33.67434], [-117.73608, 33.67677], [-117.7371, 33.6775], [-117.73543, 33.6792], [-117.73438, 33.67847], [-117.73088, 33.68196], [-117.73088, 33.68214], [-117.72868, 33.68203], [-117.72824, 33.68195], [-117.72787, 33.68184], [-117.72743, 33.68163], [-117.72719, 33.68148], [-117.72701, 33.68134], [-117.72681, 33.68115], [-117.72666, 33.68099], [-117.72648, 33.68073], [-117.7264, 33.68058], [-117.72626, 33.68022], [-117.72619, 33.6799], [-117.72618, 33.67969], [-117.72614, 33.67728], [-117.7261, 33.67696], [-117.72601, 33.67665], [-117.72587, 33.67636], [-117.72565, 33.67604], [-117.72547, 33.67586], [-117.72508, 33.6755], [-117.72486, 33.67528], [-117.72459, 33.67497], [-117.72441, 33.67473], [-117.72424, 33.67449], [-117.72404, 33.67415], [-117.72387, 33.6738], [-117.72373, 33.67344], [-117.72358, 33.67289], [-117.72318, 33.67077], [-117.72316, 33.67056], [-117.72318, 33.66952], [-117.72321, 33.66926], [-117.72329, 33.66901], [-117.72339, 33.66877], [-117.72356, 33.66851], [-117.7238, 33.66824], [-117.72408, 33.66801], [-117.72437, 33.66784], [-117.72464, 33.66772], [-117.72497, 33.66761], [-117.72536, 33.66754], [-117.72567, 33.66752], [-117.7336, 33.66754], [-117.7339, 33.66756], [-117.7342, 33.66761], [-117.73444, 33.66767], [-117.73471, 33.66776], [-117.73498, 33.66788], [-117.73522, 33.66802], [-117.73545, 33.66818], [-117.73566, 33.66836], [-117.73582, 33.66852], [-117.73596, 33.6687], [-117.73694, 33.67017], [-117.7372, 33.6705], [-117.73756, 33.67083], [-117.73873, 33.67164], [-117.73897, 33.67182], [-117.73927, 33.67211], [-117.73953, 33.67246], [-117.73969, 33.67276], [-117.7398, 33.67307], [-117.73988, 33.67344], [-117.73989, 33.67371], [-117.73987, 33.67404], [-117.73978, 33.6744], [-117.73968, 33.67467], [-117.73948, 33.67501]]], [[[-117.7433, 33.66791], [-117.74314, 33.66806], [-117.74298, 33.66816], [-117.74278, 33.66826], [-117.74263, 33.66832], [-117.74238, 33.66838], [-117.74168, 33.66847], [-117.7414, 33.66852], [-117.74099, 33.66865], [-117.74065, 33.66881], [-117.74038, 33.66898], [-117.7401, 33.6692], [-117.73903, 33.67029], [-117.73889, 33.67022], [-117.73874, 33.6702], [-117.73859, 33.67021], [-117.73844, 33.67025], [-117.73829, 33.67036], [-117.73784, 33.67082], [-117.73765, 33.67067], [-117.73746, 33.67051], [-117.73719, 33.67021], [-117.73615, 33.66865], [-117.73591, 33.66835], [-117.73574, 33.66819], [-117.73551, 33.668], [-117.7353, 33.66786], [-117.73503, 33.66771], [-117.7347, 33.66758], [-117.73445, 33.6675], [-117.73414, 33.66743], [-117.73382, 33.66739], [-117.73351, 33.66737], [-117.73063, 33.66737], [-117.73063, 33.66681], [-117.73059, 33.66666], [-117.7305, 33.66654], [-117.7304, 33.66647], [-117.73027, 33.66641], [-117.73012, 33.66639], [-117.73012, 33.66532], [-117.73015, 33.66504], [-117.73019, 33.66482], [-117.73025, 33.66461], [-117.73037, 33.66429], [-117.73047, 33.66409], [-117.73063, 33.66384], [-117.73084, 33.66356], [-117.7316, 33.66276], [-117.73176, 33.66253], [-117.73188, 33.66233], [-117.73199, 33.66207], [-117.73207, 33.66181], [-117.73212, 33.66145], [-117.73213, 33.66112], [-117.73366, 33.66113], [-117.73391, 33.66115], [-117.73421, 33.66121], [-117.73457, 33.66132], [-117.7349, 33.66148], [-117.73664, 33.66265], [-117.73692, 33.66287], [-117.73718, 33.66311], [-117.73741, 33.66337], [-117.73806, 33.66418], [-117.73833, 33.66445], [-117.73856, 33.66465], [-117.73883, 33.66485], [-117.7433, 33.66791]]], [[[-117.75103, 33.67316], [-117.74524, 33.67896], [-117.73964, 33.67512], [-117.73979, 33.67487], [-117.7399, 33.67464], [-117.73999, 33.6744], [-117.74005, 33.67416], [-117.74008, 33.67391], [-117.74009, 33.67371], [-117.74008, 33.67347], [-117.74004, 33.67322], [-117.73991, 33.67279], [-117.73978, 33.67252], [-117.73962, 33.67226], [-117.73946, 33.67205], [-117.73928, 33.67185], [-117.73912, 33.67171], [-117.73888, 33.67152], [-117.73932, 33.67107], [-117.73942, 33.67093], [-117.73944, 33.67079], [-117.73942, 33.67067], [-117.73936, 33.67054], [-117.73926, 33.67044], [-117.74029, 33.6694], [-117.74053, 33.66919], [-117.74089, 33.66898], [-117.74131, 33.66881], [-117.74173, 33.66871], [-117.74247, 33.66862], [-117.74283, 33.66852], [-117.74318, 33.66835], [-117.74339, 33.6682], [-117.74353, 33.66807], [-117.74388, 33.66833], [-117.74409, 33.66852], [-117.74429, 33.66872], [-117.7447, 33.66922], [-117.74461, 33.6693], [-117.74505, 33.66975], [-117.7455, 33.67017], [-117.74597, 33.67052], [-117.74646, 33.67085], [-117.74684, 33.67107], [-117.74743, 33.67147], [-117.74778, 33.67167], [-117.74807, 33.67181], [-117.74837, 33.67193], [-117.74955, 33.67232], [-117.74996, 33.67249], [-117.75041, 33.67274], [-117.75103, 33.67316]]]]} | Restricted Access 2 | 29675 | Orange County Great Park | 23151 | 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 | 2326.795 | Orange County Great Park | 0 | Local Park 2 | 4 | |
16360 | 16360 | 16359 | {"type": "Polygon", "coordinates": [[[-117.74864, 33.87571], [-117.74833, 33.87649], [-117.74581, 33.87766], [-117.74581, 33.87811], [-117.74358, 33.87871], [-117.74216, 33.88027], [-117.74233, 33.88141], [-117.74118, 33.88201], [-117.73899, 33.88209], [-117.73627, 33.88067], [-117.7323, 33.87754], [-117.73193, 33.87659], [-117.73167, 33.87505], [-117.73056, 33.87331], [-117.73041, 33.87237], [-117.72834, 33.87079], [-117.727, 33.86982], [-117.72625, 33.86965], [-117.72455, 33.86988], [-117.72208, 33.86913], [-117.72067, 33.8693], [-117.7196, 33.8694], [-117.71702, 33.8695], [-117.71599, 33.86972], [-117.71554, 33.86991], [-117.71527, 33.87045], [-117.71495, 33.87083], [-117.71448, 33.8712], [-117.71377, 33.87163], [-117.71287, 33.87208], [-117.71221, 33.8722], [-117.71038, 33.87221], [-117.70881, 33.87159], [-117.70732, 33.87139], [-117.7064, 33.87147], [-117.6895, 33.87691], [-117.68844, 33.87684], [-117.688, 33.87679], [-117.68756, 33.87671], [-117.68756, 33.87658], [-117.68758, 33.87657], [-117.68757, 33.87656], [-117.68564, 33.87601], [-117.68504, 33.87568], [-117.6856, 33.87486], [-117.68658, 33.87523], [-117.68798, 33.8757], [-117.68969, 33.87532], [-117.69094, 33.87471], [-117.69165, 33.87447], [-117.69301, 33.87466], [-117.69434, 33.87459], [-117.69607, 33.87434], [-117.69767, 33.87375], [-117.70002, 33.87268], [-117.70059, 33.87257], [-117.70644, 33.86987], [-117.70699, 33.86957], [-117.70855, 33.86899], [-117.70877, 33.86892], [-117.70901, 33.86886], [-117.7094, 33.86881], [-117.71077, 33.86886], [-117.71114, 33.86883], [-117.71151, 33.86874], [-117.71228, 33.86844], [-117.71232, 33.86849], [-117.71254, 33.8684], [-117.71259, 33.86768], [-117.7126, 33.86759], [-117.71268, 33.86748], [-117.71276, 33.86742], [-117.71285, 33.86738], [-117.71371, 33.8671], [-117.71521, 33.86689], [-117.71614, 33.86688], [-117.71728, 33.86695], [-117.71908, 33.86711], [-117.72365, 33.86757], [-117.72412, 33.86763], [-117.72459, 33.8677], [-117.7255, 33.86792], [-117.72667, 33.86835], [-117.73229, 33.87054], [-117.73248, 33.87063], [-117.73272, 33.8708], [-117.73285, 33.87094], [-117.73296, 33.87109], [-117.73307, 33.87134], [-117.7331, 33.87152], [-117.7331, 33.87169], [-117.7333, 33.87171], [-117.73322, 33.87226], [-117.73287, 33.87241], [-117.73313, 33.87284], [-117.73353, 33.87415], [-117.73406, 33.87576], [-117.7342, 33.87573], [-117.73566, 33.8767], [-117.73599, 33.87697], [-117.73655, 33.87754], [-117.73692, 33.87782], [-117.7372, 33.87798], [-117.73749, 33.87813], [-117.73779, 33.87824], [-117.73811, 33.87834], [-117.73844, 33.87841], [-117.73877, 33.87845], [-117.73911, 33.87847], [-117.73944, 33.87846], [-117.74077, 33.87836], [-117.74125, 33.87826], [-117.74156, 33.87816], [-117.74186, 33.87804], [-117.74214, 33.8779], [-117.74804, 33.87463], [-117.74864, 33.87571]]]} | Restricted Access 2 | 47965 | Featherly Regional Park | 32177 | 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://www.ocparks.com/parks/featherly | Orange 3 | 361.019 | Featherly RP | 0 | Local Park 2 | 4 |
12459 | 12459 | 12458 | {"type": "Polygon", "coordinates": [[[-122.93948, 38.35579], [-122.93861, 38.35592], [-122.93857, 38.35592], [-122.93856, 38.35587], [-122.93847, 38.35577], [-122.93853, 38.35573], [-122.93849, 38.35551], [-122.93858, 38.35544], [-122.93913, 38.35514], [-122.93922, 38.35551], [-122.93948, 38.35579]]]} | Restricted Access 2 | 28220 | Watson School/ Wayside Park | 31655 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 1.062 | Watson School/ Wayside Park | 0 | Local Park 2 | 4 | |
4057 | 4057 | 4056 | {"type": "Polygon", "coordinates": [[[-122.40231, 40.58043], [-122.40172, 40.58057], [-122.40131, 40.57969], [-122.40194, 40.57953], [-122.40231, 40.58043]]]} | Restricted Access 2 | 44420 | Magnolia Park | 21676 | 343 | Shasta, County of 717 | County 3 | County Agency 3 | http://www.co.shasta.ca.us/index.aspx | County 3 | 343 | Shasta, County of 700 | County 3 | County Agency 3 | Shasta 27 | 1.399 | Magnolia Park | 0 | Local Park 2 | 4 | |
4407 | 4407 | 4406 | {"type": "Polygon", "coordinates": [[[-118.14787, 33.95964], [-118.14683, 33.9602], [-118.14653, 33.95978], [-118.14761, 33.9592], [-118.14787, 33.95964]]]} | Restricted Access 2 | 46199 | Community Garden | 32757 | 1023 | Bell Gardens, City of 226 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | Los Angeles 6 | 1.546 | Community Garden | 0 | Local Park 2 | 4 | |
15728 | 15728 | 15727 | {"type": "Polygon", "coordinates": [[[-118.15633, 33.9544], [-118.15556, 33.95835], [-118.15532, 33.95831], [-118.15543, 33.95776], [-118.15531, 33.95757], [-118.15526, 33.95754], [-118.15527, 33.9572], [-118.15505, 33.95697], [-118.15296, 33.95675], [-118.15268, 33.95647], [-118.15483, 33.95531], [-118.15633, 33.9544]]]} | Restricted Access 2 | 46197 | Bell Gardens Golf Course at Ford Park | 33117 | 1023 | Bell Gardens, City of 226 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | Los Angeles 6 | 12.793 | Bell Gardens GC at Ford Park | 0 | Local Park 2 | 4 | |
3579 | 3579 | 3578 | {"type": "Polygon", "coordinates": [[[-122.27737, 37.52515], [-122.27628, 37.5261], [-122.27592, 37.52644], [-122.27476, 37.52551], [-122.27479, 37.52549], [-122.27485, 37.52551], [-122.27523, 37.52566], [-122.27527, 37.52574], [-122.27521, 37.52579], [-122.27589, 37.52633], [-122.27622, 37.52607], [-122.27592, 37.52582], [-122.27595, 37.52578], [-122.27578, 37.52566], [-122.27556, 37.52583], [-122.27534, 37.52568], [-122.27552, 37.52553], [-122.27553, 37.52546], [-122.2755, 37.52536], [-122.27531, 37.52529], [-122.27523, 37.5252], [-122.27526, 37.52495], [-122.27496, 37.52493], [-122.27495, 37.52486], [-122.27535, 37.52488], [-122.27541, 37.52444], [-122.27551, 37.52429], [-122.27562, 37.52424], [-122.27585, 37.52406], [-122.2754, 37.52369], [-122.27546, 37.52366], [-122.27592, 37.524], [-122.27737, 37.52515]]]} | Restricted Access 2 | 29136 | Nesbit School Park | 31954 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 6.56 | Nesbit School Park | 0 | Local Park 2 | 4 | |
15417 | 15417 | 15416 | {"type": "Polygon", "coordinates": [[[-118.01776, 33.8507], [-118.01418, 33.8507], [-118.01417, 33.85018], [-118.01775, 33.85014], [-118.01776, 33.8507]]]} | Restricted Access 2 | 46649 | City of Buena Park Community Gardens | 29984 | 1037 | Buena Park, City of 136 | City 2 | City Agency 2 | http://www.buenapark.com/ | City 2 | 1037 | Buena Park, City of 133 | City 2 | City Agency 2 | http://www.buenapark.com/index.aspx?page=109 | Orange 3 | 4.9 | City of Buena Park Community Gardens | 0 | Local Park 2 | 4 |
824 | 824 | 823 | {"type": "Polygon", "coordinates": [[[-118.29688, 34.18375], [-118.2965, 34.18411], [-118.29645, 34.18412], [-118.29561, 34.18351], [-118.2956, 34.18348], [-118.296, 34.18308], [-118.29685, 34.1837], [-118.29688, 34.18375]]]} | Restricted Access 2 | 5370 | Miller Park | 29568 | 1038 | Burbank, City of 138 | City 2 | City Agency 2 | http://burbankca.gov/departments/park-recreation-and-community-services/parks-facilities | City 2 | 1038 | Burbank, City of 135 | City 2 | City Agency 2 | http://www.burbankca.gov/departments/parks-and-recreation/parks-facilities/miller-park | Los Angeles 6 | 1.599 | Miller 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 | |
1030 | 1030 | 1029 | {"type": "Polygon", "coordinates": [[[-118.04152, 33.87135], [-118.04149, 33.87145], [-118.04152, 33.87159], [-118.04153, 33.87191], [-118.04149, 33.87195], [-118.04002, 33.87196], [-118.03998, 33.87195], [-118.03997, 33.87192], [-118.04, 33.87181], [-118.03999, 33.87176], [-118.03996, 33.87172], [-118.0399, 33.87171], [-118.03989, 33.87119], [-118.04023, 33.87119], [-118.04045, 33.87115], [-118.04068, 33.87106], [-118.04094, 33.87089], [-118.04112, 33.87082], [-118.04125, 33.8708], [-118.04146, 33.8708], [-118.0415, 33.87082], [-118.04152, 33.87135]]]} | Restricted Access 2 | 5646 | Friendship Park | 19120 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 3.848 | Friendship Park | 0 | Local Park 2 | 4 | |
6022 | 6022 | 6021 | {"type": "Polygon", "coordinates": [[[-118.06026, 33.87842], [-118.05959, 33.87842], [-118.05956, 33.87688], [-118.06001, 33.87688], [-118.06019, 33.87686], [-118.06024, 33.87689], [-118.06026, 33.87842]]]} | Restricted Access 2 | 729 | Frontier Park | 19131 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 2.643 | Frontier Park | 0 | Local Park 2 | 4 | |
14223 | 14223 | 14222 | {"type": "Polygon", "coordinates": [[[-118.19795, 33.88644], [-118.1967, 33.88649], [-118.19658, 33.88513], [-118.19786, 33.88512], [-118.19795, 33.88644]]]} | Restricted Access 2 | 44117 | Kelly Park | 20587 | 1065 | Compton, City of 276 | City 2 | City Agency 2 | http://www.comptoncity.org/index.php/Parks-and-Recreation/parks-and-recreation-overview.htm | City 2 | 1065 | Compton, City of 271 | City 2 | City Agency 2 | Los Angeles 6 | 4.325 | Kelly Park | 0 | Local Park 2 | 4 | |
10693 | 10693 | 10692 | {"type": "Polygon", "coordinates": [[[-117.04937, 33.13247], [-117.04883, 33.13273], [-117.0484, 33.13207], [-117.04842, 33.13205], [-117.04818, 33.13167], [-117.04871, 33.13143], [-117.04937, 33.13247]]]} | Restricted Access 2 | 19848 | Oak Hill City Park | 31522 | 1102 | Escondido, City of 86 | City 2 | City Agency 2 | http://www.escondido.org/parks-open-space.aspx | City 2 | 1102 | Escondido, City of 84 | City 2 | City Agency 2 | San Diego 4 | 1.876 | Oak Hill City Park | 0 | Local Park 2 | 4 | |
6374 | 6374 | 6373 | {"type": "Polygon", "coordinates": [[[-119.77927, 36.84098], [-119.77927, 36.84288], [-119.77707, 36.84288], [-119.77708, 36.84133], [-119.77769, 36.84134], [-119.77794, 36.84127], [-119.77843, 36.84127], [-119.77869, 36.84135], [-119.77899, 36.84134], [-119.77918, 36.84111], [-119.77919, 36.84097], [-119.77927, 36.84098]]]} | Restricted Access 2 | 1738 | Harry Goorabian Park | 31253 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.566 | Harry Goorabian Park | 0 | Local Park 2 | 4 | |
12857 | 12857 | 12856 | {"type": "Polygon", "coordinates": [[[-117.92663, 33.9084], [-117.92635, 33.90978], [-117.92622, 33.90981], [-117.92598, 33.90991], [-117.92543, 33.90885], [-117.92549, 33.90833], [-117.92663, 33.9084]]]} | Restricted Access 2 | 30308 | Hermosa School Park | 31593 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.279 | Hermosa School Park | 0 | Local Park 2 | 4 | |
12868 | 12868 | 12867 | {"type": "Polygon", "coordinates": [[[-117.93319, 33.89474], [-117.93316, 33.89535], [-117.93309, 33.89568], [-117.93278, 33.89561], [-117.93269, 33.8958], [-117.93199, 33.89562], [-117.93177, 33.89614], [-117.93144, 33.89605], [-117.93131, 33.89545], [-117.93168, 33.89521], [-117.93261, 33.89468], [-117.93285, 33.89466], [-117.93289, 33.89473], [-117.93319, 33.89474]]]} | Restricted Access 2 | 30311 | Laguna Road School Park | 31597 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.908 | Laguna Road School Park | 0 | Local Park 2 | 4 | |
14186 | 14186 | 14185 | {"type": "MultiPolygon", "coordinates": [[[[-117.90223, 33.90123], [-117.90203, 33.90123], [-117.90195, 33.90126], [-117.90189, 33.90133], [-117.9019, 33.90164], [-117.90137, 33.90168], [-117.9013, 33.90184], [-117.90058, 33.90185], [-117.90057, 33.90126], [-117.90037, 33.90108], [-117.90105, 33.90102], [-117.90222, 33.90088], [-117.90223, 33.90123]]], [[[-117.90115, 33.90289], [-117.90087, 33.90313], [-117.90081, 33.90314], [-117.90073, 33.90276], [-117.90072, 33.90264], [-117.90113, 33.90261], [-117.90115, 33.90289]]]]} | Restricted Access 2 | 44001 | Rolling Hills School Park | 31645 | 1115 | Fullerton, City of 116 | City 2 | City Agency 2 | http://www.ci.fullerton.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1115 | Fullerton, City of 113 | City 2 | City Agency 2 | Orange 3 | 3.343 | Rolling Hills School 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]);