units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where MNG_AG_TYP = 8 sorted by DES_TP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, COUNTY, YR_EST, GAP_STS
DES_TP 18
- Local Park 7
- Local Other or Unknown 6
- Local Recreation Area 4
- Local Resource Management Area 3
- Local Conservation Area 2
- 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 7
- San Francisco - Public Utilities Commission, City and County of 14
- Contra Costa County Public Works Dept., County of 11
- Los Angeles County Department of Beaches and Harbors, County of 4
- Los Angeles Department of Public Works, County of 3
- Contra Costa Department of Conservation and Development, County of 1
- Humboldt - Public Works Department, County of 1
- Orange County Department of Education, County of 1
LAYER 3 ✖
ACCESS_TYP 3
MNG_AG_TYP 1
- County Agency - Other · 35 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1826 | 1826 | 1825 | {"type": "Polygon", "coordinates": [[[-121.59683, 37.91452], [-121.59681, 37.91464], [-121.59673, 37.91472], [-121.59644, 37.91528], [-121.59643, 37.91542], [-121.59661, 37.91574], [-121.5967, 37.9161], [-121.59664, 37.91618], [-121.59635, 37.91627], [-121.596, 37.91633], [-121.59546, 37.91637], [-121.59503, 37.91646], [-121.59462, 37.91649], [-121.59405, 37.91522], [-121.59426, 37.91509], [-121.5945, 37.91486], [-121.59474, 37.91466], [-121.59492, 37.91418], [-121.59501, 37.9138], [-121.59505, 37.91347], [-121.59532, 37.91343], [-121.59553, 37.91343], [-121.59577, 37.91346], [-121.59603, 37.91361], [-121.59619, 37.91376], [-121.59653, 37.91426], [-121.59673, 37.91442], [-121.59683, 37.91452]]]} | Open Access 1 | 15707 | Cornell Park | 32842 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.522 | Cornell Park | 0 | Local Park 2 | 4 | |
1963 | 1963 | 1962 | {"type": "Polygon", "coordinates": [[[-122.3308, 37.99984], [-122.32883, 38.00027], [-122.32826, 37.99972], [-122.32874, 37.99941], [-122.32795, 37.99863], [-122.32906, 37.99841], [-122.32936, 37.9984], [-122.33043, 37.9986], [-122.33057, 37.99918], [-122.33065, 37.99944], [-122.33072, 37.9996], [-122.3308, 37.99984]]]} | Open Access 1 | 15093 | Montalvin Park | 22382 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.497 | Montalvin Park | 0 | Local Park 2 | 4 | |
3257 | 3257 | 3256 | {"type": "Polygon", "coordinates": [[[-122.27841, 37.90357], [-122.27835, 37.9037], [-122.2783, 37.90383], [-122.27824, 37.90357], [-122.27841, 37.90357]]]} | Open Access 1 | 48179 | Kensington Pocket Park | 32715 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 0.053 | Kensington PP | 0 | Local Park 2 | 4 | |
11149 | 11149 | 11148 | {"type": "Polygon", "coordinates": [[[-118.74257, 34.03285], [-118.74156, 34.03296], [-118.73843, 34.03315], [-118.73603, 34.03334], [-118.73257, 34.03315], [-118.73256, 34.03316], [-118.73223, 34.0332], [-118.7308, 34.03308], [-118.72999, 34.033], [-118.73003, 34.03274], [-118.72998, 34.03271], [-118.72974, 34.03268], [-118.72822, 34.03245], [-118.72662, 34.03222], [-118.72427, 34.03197], [-118.72278, 34.03177], [-118.7223, 34.03172], [-118.7215, 34.03167], [-118.72061, 34.03152], [-118.71938, 34.03135], [-118.71848, 34.0314], [-118.71785, 34.03146], [-118.71648, 34.03156], [-118.71599, 34.03156], [-118.71554, 34.03158], [-118.71503, 34.03154], [-118.71434, 34.03147], [-118.71321, 34.03118], [-118.71225, 34.03096], [-118.71116, 34.03074], [-118.7102, 34.03048], [-118.7093, 34.03026], [-118.70891, 34.03019], [-118.70841, 34.03002], [-118.70794, 34.02989], [-118.70726, 34.02975], [-118.70682, 34.02968], [-118.70661, 34.02967], [-118.70651, 34.02923], [-118.70685, 34.02927], [-118.70751, 34.02941], [-118.70787, 34.02954], [-118.70806, 34.02966], [-118.70854, 34.02981], [-118.70941, 34.03004], [-118.70977, 34.03009], [-118.71028, 34.03011], [-118.71096, 34.03028], [-118.7112, 34.03038], [-118.7117, 34.0305], [-118.71225, 34.03059], [-118.7125, 34.03066], [-118.71291, 34.03088], [-118.71325, 34.03102], [-118.71349, 34.03114], [-118.71434, 34.03135], [-118.71464, 34.03139], [-118.71488, 34.03138], [-118.71514, 34.03142], [-118.71541, 34.03136], [-118.71581, 34.03141], [-118.7162, 34.03143], [-118.71653, 34.03138], [-118.71692, 34.03138], [-118.71766, 34.03127], [-118.71866, 34.03109], [-118.71905, 34.03098], [-118.71935, 34.03093], [-118.71968, 34.03097], [-118.71994, 34.03107], [-118.7203, 34.03111], [-118.7224, 34.03144], [-118.72307, 34.03166], [-118.72372, 34.03175], [-118.72519, 34.03187], [-118.72521, 34.03182], [-118.72546, 34.03187], [-118.7275, 34.03214], [-118.72806, 34.03228], [-118.72847, 34.03231], [-118.72882, 34.03239], [-118.73039, 34.0325], [-118.73173, 34.03267], [-118.73322, 34.03281], [-118.73401, 34.03287], [-118.73542, 34.03301], [-118.7359, 34.03304], [-118.73608, 34.03301], [-118.73625, 34.033], [-118.73651, 34.03307], [-118.737, 34.03305], [-118.73735, 34.03309], [-118.73764, 34.0331], [-118.73798, 34.03308], [-118.73897, 34.03295], [-118.73966, 34.03291], [-118.74017, 34.03286], [-118.74111, 34.03282], [-118.74171, 34.03275], [-118.74224, 34.03264], [-118.74252, 34.03255], [-118.74257, 34.03285]]]} | Open Access 1 | 47988 | Puerco Beach | 32408 | 378 | Los Angeles County Department of Beaches and Harbors, County of 966 | County 3 | County Agency - Other 9 | http://dpw.lacounty.gov/dbh/ | County 3 | 378 | Los Angeles County Department of Beaches and Harbors, County of 827 | County 3 | County Agency - Other 8 | Los Angeles 6 | 24.244 | Puerco Beach | 0 | Local Park 2 | 4 | |
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91335], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28006, 37.91364], [-122.28059, 37.91414], [-122.28032, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28013, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28074, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91335], [-122.28129, 37.91318], [-122.28132, 37.9134]]]} | Open Access 1 | 48178 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.459 | Kensington Park | 0 | Local Park 2 | 4 | |
12092 | 12092 | 12091 | {"type": "Polygon", "coordinates": [[[-122.02017, 37.86622], [-122.02016, 37.86639], [-122.01993, 37.86641], [-122.01969, 37.86648], [-122.01952, 37.86657], [-122.01934, 37.86672], [-122.0192, 37.86692], [-122.01905, 37.86733], [-122.01897, 37.86749], [-122.01882, 37.86767], [-122.01862, 37.86783], [-122.01852, 37.86783], [-122.01826, 37.8676], [-122.01798, 37.86742], [-122.01815, 37.86697], [-122.01795, 37.86683], [-122.0179, 37.86666], [-122.01792, 37.86629], [-122.01939, 37.86633], [-122.01944, 37.86632], [-122.0195, 37.86629], [-122.01953, 37.86625], [-122.01954, 37.8662], [-122.02017, 37.86622]]]} | Open Access 1 | 24911 | Livorna Park | 21386 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.387 | Livorna Park | 0 | Local Park 2 | 4 | |
12094 | 12094 | 12093 | {"type": "Polygon", "coordinates": [[[-121.95664, 38.0308], [-121.95557, 38.03164], [-121.95456, 38.03083], [-121.95562, 38.03], [-121.95664, 38.0308]]]} | Open Access 1 | 24917 | Lynbrook Park | 21606 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.143 | Lynbrook Park | 0 | Local Park 2 | 4 | |
7296 | 7296 | 7295 | {"type": "MultiPolygon", "coordinates": [[[[-118.09001, 33.80323], [-118.08973, 33.80323], [-118.08972, 33.80318], [-118.08943, 33.79703], [-118.0896, 33.79703], [-118.08976, 33.79762], [-118.09001, 33.80323]]], [[[-118.09035, 33.80941], [-118.09002, 33.8094], [-118.08982, 33.80517], [-118.09014, 33.80517], [-118.09035, 33.80941]]], [[[-118.09387, 33.78866], [-118.09152, 33.79346], [-118.09152, 33.79349], [-118.09142, 33.79369], [-118.09128, 33.7941], [-118.09112, 33.79469], [-118.09104, 33.7952], [-118.09101, 33.79591], [-118.0914, 33.80399], [-118.09119, 33.80398], [-118.09108, 33.80402], [-118.09108, 33.80406], [-118.09077, 33.80406], [-118.09035, 33.79591], [-118.09068, 33.7959], [-118.09069, 33.79548], [-118.09072, 33.79515], [-118.09082, 33.79456], [-118.0909, 33.79422], [-118.091, 33.79389], [-118.09124, 33.79331], [-118.09351, 33.78865], [-118.09387, 33.78866]]], [[[-118.09172, 33.81023], [-118.09119, 33.81024], [-118.09091, 33.80678], [-118.09078, 33.80436], [-118.09109, 33.80437], [-118.0911, 33.8044], [-118.09119, 33.80445], [-118.09143, 33.80444], [-118.09172, 33.81023]]]]} | Open Access 1 | 6580 | San Gabriel River Trail | 29917 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 36.911 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
12095 | 12095 | 12094 | {"type": "Polygon", "coordinates": [[[-122.2701, 38.03192], [-122.26926, 38.03205], [-122.2692, 38.03185], [-122.26868, 38.03192], [-122.26872, 38.03213], [-122.26707, 38.03237], [-122.26663, 38.03052], [-122.26966, 38.03007], [-122.2701, 38.03192]]]} | Open Access 1 | 24918 | Lefty Gomez Ballfield Complex | 21138 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 13.708 | Lefty Gomez Ballfield Complex | 0 | Local Recreation Area 3 | 4 | |
15389 | 15389 | 15388 | {"type": "Polygon", "coordinates": [[[-118.09413, 33.83158], [-118.09346, 33.83146], [-118.093, 33.82842], [-118.09369, 33.82863], [-118.09413, 33.83158]]]} | Open Access 1 | 46608 | San Gabriel River Trail | 29917 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 5.002 | San Gabriel River Trail | 0 | Local Recreation Area 3 | 4 | |
15875 | 15875 | 15874 | {"type": "Polygon", "coordinates": [[[-122.32946, 38.00168], [-122.32842, 38.00225], [-122.32756, 38.00145], [-122.32721, 38.00108], [-122.32859, 38.00069], [-122.32946, 38.00168]]]} | Open Access 1 | 15091 | Montara Bay Community Center | 22384 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 4.396 | Montara Bay Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
4167 | 4167 | 4166 | {"type": "Polygon", "coordinates": [[[-118.20389, 33.83208], [-118.20324, 33.83744], [-118.20316, 33.83872], [-118.20316, 33.83917], [-118.20311, 33.8393], [-118.20288, 33.84212], [-118.20281, 33.84232], [-118.20272, 33.84362], [-118.20264, 33.84403], [-118.20264, 33.84624], [-118.20261, 33.84653], [-118.20155, 33.84653], [-118.20155, 33.84626], [-118.20186, 33.84297], [-118.20215, 33.83915], [-118.20219, 33.83906], [-118.2025, 33.83476], [-118.2025, 33.83437], [-118.20269, 33.83211], [-118.20269, 33.83186], [-118.20277, 33.83168], [-118.20294, 33.83065], [-118.20296, 33.83039], [-118.20389, 33.83208]]]} | Open Access 1 | 48292 | Dominguez Gap Wetlands | 32867 | 375 | Los Angeles Department of Public Works, County of 729 | County 3 | County Agency - Other 9 | http://dpw.lacounty.gov/ | County 3 | 375 | Los Angeles Department of Public Works, County of 713 | County 3 | County Agency - Other 8 | Los Angeles 6 | 39.283 | Dominguez Gap Wetlands | 2008 | Local Conservation Area 4 | 2 | |
7784 | 7784 | 7783 | {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} | Restricted Access 2 | 8772 | Point Edith Wetlands | 23847 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 211.368 | Point Edith Wetlands | 2001 | Local Conservation Area 4 | 2 | |
63 | 63 | 62 | {"type": "MultiPolygon", "coordinates": [[[[-122.35186, 37.50815], [-122.35183, 37.50859], [-122.35042, 37.50998], [-122.35022, 37.51078], [-122.35002, 37.51099], [-122.34927, 37.5111], [-122.34878, 37.51124], [-122.34832, 37.51117], [-122.34844, 37.51053], [-122.34804, 37.50998], [-122.34755, 37.50975], [-122.3468, 37.50957], [-122.34674, 37.50854], [-122.3464, 37.50813], [-122.3464, 37.50737], [-122.34551, 37.50669], [-122.3447, 37.50623], [-122.34384, 37.50552], [-122.34335, 37.50533], [-122.34243, 37.50522], [-122.34186, 37.5049], [-122.34185, 37.50448], [-122.34157, 37.50432], [-122.34088, 37.50414], [-122.33922, 37.5033], [-122.33821, 37.50359], [-122.33715, 37.50366], [-122.33712, 37.50336], [-122.33723, 37.50291], [-122.33778, 37.50293], [-122.33812, 37.50288], [-122.3381, 37.50149], [-122.33783, 37.50116], [-122.337, 37.50107], [-122.3362, 37.50084], [-122.33591, 37.50041], [-122.33574, 37.49993], [-122.3353, 37.49929], [-122.33473, 37.49911], [-122.33381, 37.49895], [-122.33263, 37.49835], [-122.33168, 37.4981], [-122.33079, 37.49833], [-122.32941, 37.49851], [-122.32913, 37.49767], [-122.33042, 37.49744], [-122.33108, 37.49689], [-122.33085, 37.49634], [-122.33068, 37.49577], [-122.33036, 37.49533], [-122.33039, 37.49418], [-122.33013, 37.49398], [-122.32974, 37.49393], [-122.32939, 37.49409], [-122.3287, 37.49418], [-122.32807, 37.49409], [-122.32778, 37.49386], [-122.32715, 37.49212], [-122.32686, 37.49185], [-122.32603, 37.49185], [-122.32568, 37.49125], [-122.32517, 37.49066], [-122.32517, 37.49038], [-122.32563, 37.49015], [-122.32658, 37.48999], [-122.3268, 37.48976], [-122.32683, 37.48922], [-122.3258, 37.48855], [-122.32511, 37.48779], [-122.32468, 37.48748], [-122.32428, 37.4875], [-122.32402, 37.48786], [-122.32299, 37.48713], [-122.32238, 37.48679], [-122.32103, 37.48665], [-122.32118, 37.48587], [-122.32077, 37.48546], [-122.32077, 37.48521], [-122.32092, 37.48495], [-122.32098, 37.48443], [-122.32135, 37.48411], [-122.32164, 37.48365], [-122.32172, 37.48319], [-122.32195, 37.48294], [-122.32198, 37.48267], [-122.32173, 37.48232], [-122.32236, 37.48218], [-122.32273, 37.48246], [-122.32379, 37.48246], [-122.3244, 37.48267], [-122.32454, 37.48308], [-122.32503, 37.48363], [-122.32569, 37.48383], [-122.32661, 37.48361], [-122.32707, 37.48365], [-122.3275, 37.48381], [-122.32847, 37.48468], [-122.32959, 37.48478], [-122.33003, 37.48496], [-122.3304, 37.48523], [-122.33071, 37.48514], [-122.33072, 37.48462], [-122.33115, 37.48457], [-122.33158, 37.48487], [-122.33172, 37.48528], [-122.33158, 37.48562], [-122.33132, 37.48585], [-122.33097, 37.48585], [-122.33011, 37.48562], [-122.32954, 37.48537], [-122.32917, 37.48544], [-122.32925, 37.48574], [-122.32951, 37.48604], [-122.33043, 37.48658], [-122.33094, 37.487], [-122.33169, 37.48798], [-122.33364, 37.48943], [-122.33508, 37.48931], [-122.33528, 37.48787], [-122.33643, 37.4878], [-122.33752, 37.4881], [-122.33795, 37.48849], [-122.33801, 37.48984], [-122.33815, 37.49009], [-122.33827, 37.49092], [-122.33867, 37.49121], [-122.34028, 37.49181], [-122.34019, 37.49238], [-122.33919, 37.49295], [-122.33821, 37.49326], [-122.33809, 37.49435], [-122.33875, 37.49508], [-122.33898, 37.4957], [-122.33985, 37.4965], [-122.34249, 37.49836], [-122.34292, 37.49879], [-122.34292, 37.49941], [-122.34341, 37.49993], [-122.34364, 37.50014], [-122.34456, 37.5003], [-122.34557, 37.50021], [-122.34591, 37.50037], [-122.34634, 37.50098], [-122.34669, 37.50126], [-122.34749, 37.50169], [-122.34827, 37.50188], [-122.34861, 37.50206], [-122.34962, 37.50206], [-122.34988, 37.50222], [-122.35057, 37.50238], [-122.34933, 37.50314], [-122.3489, 37.50325], [-122.34856, 37.50366], [-122.34856, 37.50409], [-122.34942, 37.50415], [-122.34959, 37.50451], [-122.34939, 37.50474], [-122.34922, 37.50526], [-122.34924, 37.50558], [-122.3497, 37.50593], [-122.34979, 37.50622], [-122.35108, 37.50595], [-122.3514, 37.506], [-122.35143, 37.50685], [-122.35143, 37.50744], [-122.35186, 37.50815]]], [[[-122.39158, 37.55481], [-122.39144, 37.55538], [-122.39124, 37.55602], [-122.39144, 37.55641], [-122.39144, 37.55669], [-122.39104, 37.55657], [-122.39069, 37.5563], [-122.39032, 37.55575], [-122.38986, 37.5555], [-122.38963, 37.55527], [-122.38931, 37.55454], [-122.38782, 37.55335], [-122.38762, 37.55261], [-122.38696, 37.55163], [-122.38621, 37.55124], [-122.38641, 37.55058], [-122.38627, 37.55033], [-122.38532, 37.54975], [-122.38442, 37.54826], [-122.38325, 37.54707], [-122.38258, 37.54691], [-122.38235, 37.54643], [-122.38212, 37.5462], [-122.38103, 37.54568], [-122.38066, 37.54508], [-122.38014, 37.54474], [-122.37968, 37.54462], [-122.37951, 37.54398], [-122.37902, 37.54352], [-122.3789, 37.54311], [-122.37781, 37.54227], [-122.37761, 37.54197], [-122.37706, 37.54169], [-122.37697, 37.5414], [-122.37672, 37.54119], [-122.3766, 37.54069], [-122.37623, 37.54034], [-122.3758, 37.54009], [-122.37562, 37.53966], [-122.37522, 37.53934], [-122.37462, 37.53933], [-122.37468, 37.53883], [-122.3745, 37.53835], [-122.37471, 37.53812], [-122.37476, 37.53783], [-122.37436, 37.53737], [-122.37301, 37.53776], [-122.37275, 37.53805], [-122.3724, 37.53796], [-122.37203, 37.53773], [-122.37301, 37.53679], [-122.37358, 37.53668], [-122.37381, 37.5363], [-122.37338, 37.53625], [-122.37232, 37.53638], [-122.37229, 37.53606], [-122.37311, 37.53585], [-122.37243, 37.5354], [-122.3724, 37.53478], [-122.37212, 37.53439], [-122.37166, 37.53402], [-122.37039, 37.53418], [-122.36985, 37.53418], [-122.36944, 37.53382], [-122.36896, 37.53359], [-122.36847, 37.53354], [-122.36784, 37.53373], [-122.36755, 37.53359], [-122.36763, 37.53252], [-122.36691, 37.53212], [-122.36677, 37.53132], [-122.36651, 37.531], [-122.36571, 37.53052], [-122.36427, 37.52999], [-122.36306, 37.52942], [-122.36298, 37.52896], [-122.36266, 37.52842], [-122.36214, 37.52798], [-122.36191, 37.52761], [-122.36191, 37.52725], [-122.36211, 37.52677], [-122.36177, 37.52635], [-122.362, 37.52551], [-122.36191, 37.52505], [-122.36154, 37.52468], [-122.36137, 37.52439], [-122.36105, 37.52416], [-122.36019, 37.52397], [-122.36082, 37.52343], [-122.36088, 37.52305], [-122.36028, 37.52244], [-122.35973, 37.52239], [-122.35947, 37.52221], [-122.35956, 37.5215], [-122.3591, 37.52116], [-122.35838, 37.52122], [-122.35881, 37.52054], [-122.35812, 37.52001], [-122.35749, 37.51932], [-122.35697, 37.51777], [-122.35668, 37.51722], [-122.35694, 37.51685], [-122.35646, 37.51651], [-122.35645, 37.51619], [-122.35677, 37.5161], [-122.35737, 37.5161], [-122.35754, 37.51578], [-122.35528, 37.51493], [-122.35444, 37.51429], [-122.35384, 37.51403], [-122.35375, 37.51378], [-122.35292, 37.51339], [-122.35197, 37.51323], [-122.35111, 37.51248], [-122.35102, 37.51223], [-122.35217, 37.51177], [-122.35283, 37.51195], [-122.35329, 37.51192], [-122.35329, 37.51168], [-122.35258, 37.51131], [-122.35163, 37.51065], [-122.35171, 37.51017], [-122.35252, 37.50914], [-122.35301, 37.50888], [-122.35355, 37.50831], [-122.35398, 37.50829], [-122.35427, 37.50863], [-122.35398, 37.5093], [-122.35365, 37.50967], [-122.35447, 37.51044], [-122.3549, 37.51117], [-122.35631, 37.51227], [-122.3566, 37.51271], [-122.35694, 37.5128], [-122.3574, 37.5128], [-122.35864, 37.51214], [-122.35919, 37.51147], [-122.35936, 37.51081], [-122.3597, 37.51063], [-122.36008, 37.51097], [-122.36011, 37.51147], [-122.36022, 37.51172], [-122.36054, 37.512], [-122.35982, 37.51282], [-122.35985, 37.51312], [-122.36022, 37.51321], [-122.36048, 37.51344], [-122.36048, 37.51374], [-122.36068, 37.51411], [-122.36151, 37.51447], [-122.36194, 37.51479], [-122.36085, 37.51491], [-122.36091, 37.51539], [-122.36123, 37.51578], [-122.36123, 37.51623], [-122.36128, 37.51649], [-122.36166, 37.51692], [-122.36209, 37.51708], [-122.36301, 37.51708], [-122.36318, 37.51738], [-122.36307, 37.51763], [-122.36364, 37.51768], [-122.36429, 37.51833], [-122.3627, 37.51816], [-122.36255, 37.5185], [-122.3639, 37.51912], [-122.36464, 37.51967], [-122.36539, 37.52006], [-122.36637, 37.52036], [-122.36792, 37.52145], [-122.36631, 37.52132], [-122.36597, 37.52146], [-122.36588, 37.52189], [-122.36637, 37.52272], [-122.36677, 37.52361], [-122.36689, 37.52422], [-122.36597, 37.52391], [-122.36554, 37.52391], [-122.36542, 37.5247], [-122.36597, 37.52496], [-122.36732, 37.52601], [-122.36775, 37.52668], [-122.36881, 37.52761], [-122.36901, 37.52812], [-122.36967, 37.52869], [-122.37005, 37.52878], [-122.37125, 37.52867], [-122.37157, 37.52855], [-122.37174, 37.52828], [-122.37174, 37.52777], [-122.37278, 37.5275], [-122.37304, 37.52819], [-122.3735, 37.52858], [-122.37407, 37.52892], [-122.37499, 37.52917], [-122.37502, 37.52942], [-122.37492, 37.52975], [-122.37738, 37.53043], [-122.37862, 37.53096], [-122.3793, 37.53103], [-122.37997, 37.53141], [-122.38112, 37.53187], [-122.38143, 37.53217], [-122.38218, 37.53233], [-122.38253, 37.53293], [-122.38431, 37.53331], [-122.3852, 37.53361], [-122.38592, 37.53359], [-122.38589, 37.53464], [-122.38534, 37.53421], [-122.385, 37.534], [-122.38451, 37.53398], [-122.38416, 37.5338], [-122.38353, 37.53377], [-122.38307, 37.53364], [-122.38172, 37.53359], [-122.38111, 37.53304], [-122.38011, 37.53288], [-122.37939, 37.53265], [-122.37913, 37.53281], [-122.37882, 37.53283], [-122.37721, 37.53228], [-122.37686, 37.53213], [-122.37643, 37.5316], [-122.37609, 37.53146], [-122.37574, 37.53141], [-122.37542, 37.53118], [-122.37468, 37.53116], [-122.37419, 37.5308], [-122.37378, 37.53084], [-122.37341, 37.53139], [-122.37332, 37.5318], [-122.37309, 37.53199], [-122.37252, 37.53229], [-122.37252, 37.53263], [-122.37269, 37.53299], [-122.37399, 37.53306], [-122.37433, 37.53325], [-122.37473, 37.53384], [-122.37488, 37.53427], [-122.37525, 37.53473], [-122.37583, 37.53515], [-122.37609, 37.53565], [-122.37652, 37.53592], [-122.37669, 37.53656], [-122.37721, 37.5372], [-122.37758, 37.53746], [-122.37824, 37.53771], [-122.37824, 37.53801], [-122.37802, 37.53833], [-122.37842, 37.53851], [-122.37907, 37.53842], [-122.37959, 37.53819], [-122.37991, 37.53821], [-122.37985, 37.53869], [-122.37945, 37.53888], [-122.37939, 37.53957], [-122.37971, 37.54101], [-122.38, 37.54119], [-122.3808, 37.5414], [-122.38029, 37.54195], [-122.38074, 37.54263], [-122.38092, 37.54295], [-122.38146, 37.54341], [-122.38276, 37.54396], [-122.38273, 37.54447], [-122.38402, 37.54483], [-122.38439, 37.54533], [-122.38474, 37.54549], [-122.38549, 37.54554], [-122.38569, 37.54597], [-122.38526, 37.54618], [-122.38517, 37.54648], [-122.38577, 37.54744], [-122.38707, 37.54859], [-122.38724, 37.54904], [-122.38833, 37.5503], [-122.3888, 37.55117], [-122.38948, 37.5517], [-122.3892, 37.55209], [-122.38926, 37.55243], [-122.39012, 37.5527], [-122.39058, 37.55316], [-122.39089, 37.55401], [-122.39158, 37.55481]]], [[[-122.44289, 37.55923], [-122.44249, 37.55923], [-122.4405, 37.55846], [-122.43984, 37.55841], [-122.43947, 37.55864], [-122.43892, 37.5588], [-122.43898, 37.55818], [-122.43869, 37.55789], [-122.4353, 37.55699], [-122.43507, 37.55672], [-122.43466, 37.55665], [-122.43457, 37.55617], [-122.4332, 37.55521], [-122.43251, 37.5551], [-122.43196, 37.55523], [-122.43144, 37.55485], [-122.4311, 37.55482], [-122.43072, 37.55491], [-122.43052, 37.55462], [-122.42957, 37.55407], [-122.42894, 37.55388], [-122.42805, 37.5535], [-122.42773, 37.55322], [-122.42695, 37.55292], [-122.42684, 37.55263], [-122.42652, 37.55244], [-122.42592, 37.55233], [-122.42569, 37.55205], [-122.42465, 37.55146], [-122.42356, 37.55073], [-122.42298, 37.55089], [-122.42278, 37.55119], [-122.42276, 37.5516], [-122.42322, 37.55247], [-122.42333, 37.55293], [-122.42325, 37.55343], [-122.42333, 37.55437], [-122.42348, 37.55467], [-122.42356, 37.55542], [-122.42451, 37.55615], [-122.42477, 37.55647], [-122.42515, 37.55753], [-122.4242, 37.55705], [-122.42414, 37.55675], [-122.42351, 37.55618], [-122.42307, 37.55551], [-122.42261, 37.55503], [-122.4225, 37.5543], [-122.42215, 37.55377], [-122.42224, 37.5532], [-122.42201, 37.55274], [-122.42178, 37.55254], [-122.42189, 37.55208], [-122.42189, 37.55137], [-122.42175, 37.55096], [-122.42241, 37.55043], [-122.42258, 37.54986], [-122.4225, 37.54926], [-122.42261, 37.54897], [-122.4235, 37.54782], [-122.42407, 37.54768], [-122.42445, 37.54768], [-122.42445, 37.54807], [-122.42471, 37.54828], [-122.4248, 37.54885], [-122.4256, 37.54908], [-122.42621, 37.54965], [-122.42681, 37.54977], [-122.42701, 37.55004], [-122.42736, 37.5502], [-122.4292, 37.55011], [-122.42905, 37.5504], [-122.42856, 37.55093], [-122.42833, 37.55136], [-122.42836, 37.55173], [-122.42877, 37.55212], [-122.42917, 37.5521], [-122.42966, 37.55198], [-122.43, 37.55203], [-122.42986, 37.55244], [-122.42989, 37.55274], [-122.43012, 37.55311], [-122.43066, 37.55356], [-122.43158, 37.55386], [-122.43213, 37.55418], [-122.43391, 37.55441], [-122.43418, 37.55464], [-122.43521, 37.55482], [-122.43524, 37.55535], [-122.43616, 37.55606], [-122.43691, 37.55594], [-122.43688, 37.55645], [-122.43803, 37.55697], [-122.43909, 37.55722], [-122.4395, 37.55754], [-122.44272, 37.5588], [-122.44289, 37.55923]]]]} | Restricted Access 2 | 21943 | San Francisco Watershed Water | 24890 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 1251.272 | San Francisco Watershed Water | 1930 | None 9 | ||
1149 | 1149 | 1148 | {"type": "Polygon", "coordinates": [[[-122.46654, 37.70822], [-122.46654, 37.70827], [-122.46585, 37.70826], [-122.46585, 37.70822], [-122.46654, 37.70822]]]} | Restricted Access 2 | 6734 | Hillcrest And Ocean View Lots | 19962 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 0.08 | Hillcrest And Ocean View Lots | 0 | Local Other or Unknown 14 | 4 | |
4519 | 4519 | 4518 | {"type": "Polygon", "coordinates": [[[-117.6523, 33.73705], [-117.6424, 33.73701], [-117.64238, 33.73346], [-117.64935, 33.7315], [-117.65064, 33.73322], [-117.652, 33.73296], [-117.65104, 33.73389], [-117.6515, 33.73494], [-117.6523, 33.73705]]]} | Restricted Access 2 | 12713 | Unnamed site - Orange County Department of Education, County of | 28651 | 313 | Orange County Department of Education, County of 770 | County 3 | County Agency - Other 9 | http://www.ocde.us/ | County 3 | 313 | Orange County Department of Education, County of 751 | County 3 | County Agency - Other 8 | Orange 3 | 105.765 | 0 | Local Other or Unknown 14 | 4 | ||
5313 | 5313 | 5312 | {"type": "Polygon", "coordinates": [[[-122.40596, 37.71374], [-122.40581, 37.71398], [-122.40589, 37.71402], [-122.40573, 37.71427], [-122.4055, 37.71418], [-122.40565, 37.71394], [-122.40558, 37.7139], [-122.40573, 37.71365], [-122.40596, 37.71374]]]} | Open Access 1 | 6024 | Reis Tract Lots - Arleta I | 24283 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 0.348 | Reis Tract Lots - Arleta I | 0 | Local Other or Unknown 14 | 4 | |
5923 | 5923 | 5922 | {"type": "Polygon", "coordinates": [[[-122.1385, 37.48163], [-122.13828, 37.48212], [-122.13754, 37.48296], [-122.13725, 37.48334], [-122.13641, 37.48427], [-122.13358, 37.48639], [-122.13244, 37.48637], [-122.12668, 37.4898], [-122.12636, 37.48978], [-122.12589, 37.4898], [-122.1259, 37.48918], [-122.12601, 37.48639], [-122.12719, 37.48574], [-122.12827, 37.48519], [-122.13007, 37.48435], [-122.1312, 37.48388], [-122.13088, 37.48337], [-122.13108, 37.4829], [-122.13274, 37.48232], [-122.13331, 37.48262], [-122.1338, 37.48271], [-122.13422, 37.48259], [-122.13498, 37.48243], [-122.13544, 37.48231], [-122.13605, 37.48227], [-122.13669, 37.48211], [-122.13741, 37.48183], [-122.1385, 37.48163]]]} | Restricted Access 2 | 455 | San Mateo Properties | 24954 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Mateo 15 | 94.811 | San Mateo Properties | 1930 | Local Other or Unknown 14 | 4 | |
6832 | 6832 | 6831 | {"type": "MultiPolygon", "coordinates": [[[[-122.40617, 37.71487], [-122.40605, 37.71513], [-122.40573, 37.71504], [-122.40583, 37.71478], [-122.40549, 37.71466], [-122.40564, 37.71442], [-122.40582, 37.71449], [-122.40603, 37.71454], [-122.40593, 37.7148], [-122.40617, 37.71487]]], [[[-122.40653, 37.71572], [-122.40641, 37.71598], [-122.40609, 37.71589], [-122.4062, 37.71564], [-122.40612, 37.71561], [-122.40624, 37.71535], [-122.40639, 37.7154], [-122.40629, 37.71566], [-122.40653, 37.71572]]], [[[-122.40689, 37.71658], [-122.40678, 37.71684], [-122.40645, 37.71675], [-122.40656, 37.71649], [-122.40632, 37.71642], [-122.40643, 37.71616], [-122.40676, 37.71625], [-122.40665, 37.71651], [-122.40689, 37.71658]]]]} | Open Access 1 | 5446 | Reis Tract Lots - Tucker | 24285 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 1.334 | Reis Tract Lots - Tucker | 0 | Local Other or Unknown 14 | 4 | |
6833 | 6833 | 6832 | {"type": "MultiPolygon", "coordinates": [[[[-122.4062, 37.71304], [-122.40605, 37.71328], [-122.40613, 37.71332], [-122.40597, 37.71356], [-122.40582, 37.7135], [-122.40597, 37.71327], [-122.40589, 37.71323], [-122.40605, 37.71298], [-122.4062, 37.71304]]], [[[-122.40652, 37.71237], [-122.40637, 37.71261], [-122.40644, 37.71265], [-122.40629, 37.71289], [-122.40614, 37.71283], [-122.40628, 37.7126], [-122.40621, 37.71256], [-122.40636, 37.71231], [-122.40652, 37.71237]]]]} | Open Access 1 | 5452 | Reis Tract Lots - Arleta Ii | 24284 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | San Francisco 13 | 0.462 | Reis Tract Lots - Arleta Ii | 0 | Local Other or Unknown 14 | 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]);