units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,376 rows where DES_TP = 2
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, City of 313
- San Diego, City of 271
- Sacramento, City of 192
- San Jose, City of 175
- San Francisco, City and County of 117
- Long Beach, City of 101
- Oakland, City of 99
- Los Angeles, County of 94
- Consumnes Community Services District 92
- Fresno, City of 82
- East Bay Regional Park District 76
- Modesto, City of 76
- Huntington Beach, City of 74
- Hayward Area Recreation and Park District 74
- Tracy, City of 69
- Santa Rosa, City of 68
- San Diego, County of 68
- Stockton, City of 67
- Roseville, City of 67
- Mountains Recreation and Conservation Authority 66
- Brentwood, City of 63
- Chula Vista, City of 60
- Irvine, City of 59
- Valley-Wide Recreation and Park District 57
- Bakersfield, City of 56
- Clovis, City of 54
- Manteca, City of 54
- Newport Beach, City of 50
- Anaheim, City of 49
- Riverside, City of 49
- …
MNG_AG_TYP 16
- City Agency 7,453
- Recreation/Parks District 703
- County Agency 646
- Community Services District 173
- County Agency - Parks 154
- Open Space District 74
- Water District 38
- School District 32
- Port/Harbor District 24
- Flood District 17
- Special District - Other 9
- County Agency - Other 7
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
- Joint Powers Authority 1
ACCESS_TYP 4
- Open Access 9,044
- Restricted Access 210
- No Public Access 77
- Unknown Access 5
DES_TP 1
- Local Park · 9,336 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53 | 53 | 52 | {"type": "MultiPolygon", "coordinates": [[[[-122.45586, 37.69383], [-122.45576, 37.69389], [-122.45521, 37.6939], [-122.45477, 37.69419], [-122.45402, 37.69441], [-122.45367, 37.69455], [-122.45335, 37.69472], [-122.4531, 37.69488], [-122.45282, 37.69509], [-122.45259, 37.6953], [-122.45062, 37.69758], [-122.45045, 37.6978], [-122.45032, 37.69802], [-122.4502, 37.69826], [-122.4501, 37.69855], [-122.44974, 37.7004], [-122.44968, 37.70059], [-122.44958, 37.70076], [-122.44942, 37.70096], [-122.44917, 37.70116], [-122.44887, 37.7013], [-122.44853, 37.70139], [-122.44832, 37.70142], [-122.44805, 37.70141], [-122.44783, 37.70138], [-122.4476, 37.70132], [-122.4405, 37.69868], [-122.44023, 37.69856], [-122.44001, 37.69844], [-122.43785, 37.69708], [-122.43755, 37.6969], [-122.43714, 37.69669], [-122.4366, 37.69645], [-122.43458, 37.6957], [-122.43417, 37.69559], [-122.43381, 37.69556], [-122.43338, 37.69559], [-122.433, 37.69569], [-122.43264, 37.69586], [-122.43232, 37.6961], [-122.4321, 37.69637], [-122.432, 37.69654], [-122.43152, 37.69764], [-122.4314, 37.69782], [-122.43127, 37.69795], [-122.43113, 37.69805], [-122.43099, 37.69813], [-122.43082, 37.69819], [-122.43066, 37.69823], [-122.43032, 37.69825], [-122.43011, 37.69822], [-122.42993, 37.69818], [-122.42964, 37.69804], [-122.42667, 37.69595], [-122.42638, 37.69578], [-122.42605, 37.69566], [-122.42623, 37.69516], [-122.42616, 37.69514], [-122.42723, 37.6929], [-122.42704, 37.69252], [-122.42582, 37.69095], [-122.42486, 37.69026], [-122.42158, 37.68768], [-122.42399, 37.68578], [-122.42719, 37.6823], [-122.42696, 37.68121], [-122.42493, 37.68002], [-122.42415, 37.67959], [-122.42201, 37.67888], [-122.41837, 37.67888], [-122.41635, 37.6811], [-122.41619, 37.68108], [-122.41507, 37.68212], [-122.4155, 37.68555], [-122.41335, 37.6853], [-122.41168, 37.68323], [-122.41122, 37.68323], [-122.41065, 37.68155], [-122.40834, 37.68234], [-122.40806, 37.68223], [-122.40805, 37.68026], [-122.40802, 37.68025], [-122.40801, 37.67981], [-122.40799, 37.67554], [-122.39658, 37.67558], [-122.39656, 37.67385], [-122.39121, 37.67317], [-122.39215, 37.6717], [-122.39265, 37.67096], [-122.39304, 37.67044], [-122.39366, 37.66968], [-122.3938, 37.6696], [-122.39456, 37.66882], [-122.39478, 37.66862], [-122.39508, 37.6684], [-122.39561, 37.66807], [-122.39643, 37.66829], [-122.39717, 37.66803], [-122.39743, 37.66802], [-122.39761, 37.66804], [-122.39776, 37.66808], [-122.39782, 37.6672], [-122.39816, 37.66715], [-122.39923, 37.66776], [-122.40004, 37.66786], [-122.40018, 37.66697], [-122.40105, 37.66718], [-122.40144, 37.66677], [-122.40251, 37.66689], [-122.4031, 37.66666], [-122.40329, 37.6665], [-122.4034, 37.66636], [-122.40431, 37.66619], [-122.40375, 37.66712], [-122.40494, 37.66781], [-122.40544, 37.66781], [-122.40546, 37.66803], [-122.40614, 37.66787], [-122.40669, 37.66702], [-122.40759, 37.66724], [-122.40794, 37.66761], [-122.40779, 37.66826], [-122.40779, 37.66921], [-122.40847, 37.67002], [-122.41005, 37.67065], [-122.41048, 37.67036], [-122.41061, 37.66933], [-122.41164, 37.66899], [-122.41198, 37.66968], [-122.41283, 37.66986], [-122.41318, 37.67063], [-122.41267, 37.67171], [-122.41346, 37.67203], [-122.4138, 37.67093], [-122.4142, 37.67095], [-122.41513, 37.6718], [-122.41506, 37.67293], [-122.41608, 37.67277], [-122.41692, 37.67314], [-122.41748, 37.67301], [-122.41826, 37.67323], [-122.41833, 37.67307], [-122.41841, 37.67304], [-122.41885, 37.67333], [-122.41953, 37.6728], [-122.41996, 37.6717], [-122.42085, 37.67177], [-122.42194, 37.67167], [-122.42373, 37.6721], [-122.42629, 37.66877], [-122.42551, 37.66806], [-122.42518, 37.66782], [-122.42558, 37.66747], [-122.42575, 37.66735], [-122.42596, 37.66726], [-122.42616, 37.6672], [-122.42645, 37.66717], [-122.42667, 37.66718], [-122.42685, 37.66721], [-122.42866, 37.66768], [-122.4322, 37.6696], [-122.43247, 37.66984], [-122.43273, 37.67002], [-122.43361, 37.67048], [-122.43368, 37.67055], [-122.43313, 37.67162], [-122.43261, 37.67487], [-122.43875, 37.6776], [-122.44004, 37.67612], [-122.44052, 37.67588], [-122.44308, 37.67729], [-122.44272, 37.67776], [-122.44382, 37.67836], [-122.44346, 37.67936], [-122.4404, 37.68122], [-122.44001, 37.68139], [-122.43976, 37.68136], [-122.43941, 37.68122], [-122.43962, 37.68327], [-122.44108, 37.68336], [-122.44194, 37.68413], [-122.44347, 37.68464], [-122.4437, 37.68483], [-122.44526, 37.68548], [-122.44567, 37.68577], [-122.44554, 37.6869], [-122.44779, 37.68794], [-122.44798, 37.6881], [-122.44987, 37.68981], [-122.45121, 37.69109], [-122.45281, 37.69165], [-122.45276, 37.69171], [-122.45276, 37.69172], [-122.45455, 37.69233], [-122.45462, 37.69227], [-122.45472, 37.69231], [-122.4558, 37.69346], [-122.45586, 37.69383]], [[-122.43817, 37.69045], [-122.43834, 37.69045], [-122.43851, 37.69041], [-122.43901, 37.69011], [-122.43911, 37.69002], [-122.43919, 37.68989], [-122.43923, 37.68973], [-122.43922, 37.68961], [-122.43915, 37.68943], [-122.43914, 37.68932], [-122.43735, 37.68737], [-122.4362, 37.68732], [-122.43493, 37.68573], [-122.43517, 37.68513], [-122.43488, 37.68471], [-122.43347, 37.6853], [-122.43365, 37.68568], [-122.43427, 37.68552], [-122.43454, 37.68578], [-122.43477, 37.68612], [-122.43501, 37.68604], [-122.43508, 37.68614], [-122.4351, 37.68628], [-122.43504, 37.68668], [-122.43505, 37.68677], [-122.43514, 37.68703], [-122.43515, 37.68712], [-122.43515, 37.68726], [-122.43513, 37.68738], [-122.43509, 37.68746], [-122.4346, 37.68763], [-122.43458, 37.68779], [-122.43519, 37.68785], [-122.43538, 37.68796], [-122.43584, 37.68833], [-122.43613, 37.68846], [-122.43617, 37.68908], [-122.4362, 37.68936], [-122.4366, 37.68941], [-122.43714, 37.68913], [-122.43723, 37.6893], [-122.43735, 37.68971], [-122.43745, 37.68988], [-122.4377, 37.69018], [-122.43778, 37.69026], [-122.43798, 37.69038], [-122.43817, 37.69045]]], [[[-122.41242, 37.69178], [-122.41238, 37.6918], [-122.41233, 37.69197], [-122.41228, 37.69201], [-122.41222, 37.69202], [-122.41206, 37.69196], [-122.41198, 37.6919], [-122.41193, 37.69189], [-122.41188, 37.69191], [-122.41157, 37.69178], [-122.41124, 37.69167], [-122.41122, 37.69164], [-122.41114, 37.69161], [-122.41107, 37.69156], [-122.41098, 37.69155], [-122.41072, 37.69146], [-122.41067, 37.69138], [-122.4107, 37.69123], [-122.41068, 37.69105], [-122.41061, 37.69092], [-122.41058, 37.69073], [-122.41031, 37.69054], [-122.41022, 37.69044], [-122.40999, 37.69035], [-122.40975, 37.69028], [-122.40967, 37.69029], [-122.40959, 37.69033], [-122.40954, 37.69032], [-122.40948, 37.69028], [-122.40942, 37.69027], [-122.40913, 37.69043], [-122.40911, 37.69048], [-122.40921, 37.69061], [-122.40921, 37.69065], [-122.40904, 37.69069], [-122.40896, 37.69068], [-122.40869, 37.69078], [-122.40865, 37.69083], [-122.40867, 37.69093], [-122.40865, 37.69095], [-122.40861, 37.69096], [-122.40844, 37.69089], [-122.4084, 37.69089], [-122.40829, 37.69097], [-122.40824, 37.69111], [-122.40822, 37.69113], [-122.40816, 37.69113], [-122.40804, 37.6911], [-122.40797, 37.69111], [-122.40773, 37.69126], [-122.40761, 37.69125], [-122.40755, 37.69129], [-122.40744, 37.69143], [-122.40742, 37.69149], [-122.40743, 37.69163], [-122.40742, 37.69176], [-122.40739, 37.69192], [-122.40739, 37.69229], [-122.40755, 37.69275], [-122.40771, 37.69292], [-122.40784, 37.69312], [-122.40781, 37.69312], [-122.4078, 37.69313], [-122.40794, 37.69318], [-122.40798, 37.69322], [-122.40798, 37.69326], [-122.40794, 37.6933], [-122.40796, 37.69337], [-122.40793, 37.69344], [-122.40794, 37.69351], [-122.40792, 37.69357], [-122.40796, 37.6936], [-122.40795, 37.69365], [-122.40796, 37.69371], [-122.40799, 37.69372], [-122.40801, 37.6938], [-122.40798, 37.69383], [-122.40801, 37.69387], [-122.40802, 37.69392], [-122.40807, 37.69397], [-122.4081, 37.69403], [-122.40815, 37.69405], [-122.40827, 37.69426], [-122.40849, 37.69454], [-122.40847, 37.69457], [-122.40851, 37.69465], [-122.40852, 37.69472], [-122.40838, 37.69483], [-122.40825, 37.69485], [-122.40821, 37.69484], [-122.40818, 37.69479], [-122.40815, 37.69477], [-122.40719, 37.69314], [-122.407, 37.69291], [-122.4067, 37.69265], [-122.40664, 37.69256], [-122.40661, 37.69245], [-122.40661, 37.69234], [-122.4067, 37.69211], [-122.40675, 37.69193], [-122.40683, 37.69101], [-122.40955, 37.68982], [-122.41003, 37.68984], [-122.41023, 37.68982], [-122.41042, 37.68977], [-122.41047, 37.68979], [-122.41059, 37.68992], [-122.41071, 37.69003], [-122.41113, 37.69032], [-122.41132, 37.69047], [-122.41137, 37.69053], [-122.41142, 37.69054], [-122.4115, 37.69062], [-122.41149, 37.69065], [-122.41154, 37.69073], [-122.41164, 37.69076], [-122.41219, 37.69128], [-122.41219, 37.69135], [-122.41226, 37.69139], [-122.41231, 37.69144], [-122.41234, 37.69145], [-122.41237, 37.69151], [-122.41241, 37.69165], [-122.41242, 37.69178]]], [[[-122.40967, 37.69454], [-122.40962, 37.69458], [-122.40869, 37.6957], [-122.40859, 37.69552], [-122.40863, 37.6955], [-122.40872, 37.69539], [-122.4087, 37.69535], [-122.40881, 37.69525], [-122.40889, 37.69514], [-122.40894, 37.69498], [-122.40893, 37.69483], [-122.40889, 37.69476], [-122.4088, 37.69473], [-122.40864, 37.69453], [-122.40866, 37.69449], [-122.40861, 37.69442], [-122.4085, 37.6943], [-122.40845, 37.69429], [-122.40831, 37.69408], [-122.40822, 37.69389], [-122.40825, 37.69385], [-122.4082, 37.69368], [-122.40816, 37.69364], [-122.40816, 37.6936], [-122.4082, 37.69358], [-122.40818, 37.69349], [-122.40821, 37.69349], [-122.40831, 37.69362], [-122.40832, 37.69372], [-122.40837, 37.69383], [-122.40837, 37.69388], [-122.40846, 37.69401], [-122.40854, 37.69408], [-122.40867, 37.69412], [-122.4087, 37.69419], [-122.40875, 37.69423], [-122.40888, 37.69426], [-122.4091, 37.69427], [-122.4092, 37.69432], [-122.40931, 37.69434], [-122.40937, 37.69445], [-122.4094, 37.69448], [-122.40967, 37.69454]]], [[[-122.41013, 37.69429], [-122.4098, 37.69449], [-122.40983, 37.6943], [-122.40981, 37.69427], [-122.40974, 37.69423], [-122.40974, 37.69419], [-122.4098, 37.69413], [-122.40982, 37.69407], [-122.4099, 37.69408], [-122.40995, 37.69412], [-122.41, 37.69412], [-122.41013, 37.69429]]], [[[-122.41885, 37.69444], [-122.41869, 37.69447], [-122.41861, 37.69443], [-122.41832, 37.69437], [-122.4182, 37.69439], [-122.41809, 37.69438], [-122.41794, 37.6944], [-122.41787, 37.69447], [-122.41795, 37.69476], [-122.41793, 37.69484], [-122.41796, 37.6949], [-122.41773, 37.69491], [-122.41144, 37.69348], [-122.41028, 37.6942], [-122.41024, 37.69417], [-122.4102, 37.69417], [-122.41002, 37.69395], [-122.41002, 37.69383], [-122.41004, 37.69382], [-122.41007, 37.69385], [-122.41015, 37.69382], [-122.41024, 37.6937], [-122.41027, 37.69359], [-122.41026, 37.69347], [-122.41024, 37.69343], [-122.4102, 37.69341], [-122.41018, 37.69341], [-122.41018, 37.69338], [-122.41023, 37.69334], [-122.41026, 37.69335], [-122.4103, 37.69335], [-122.41039, 37.69327], [-122.41039, 37.69322], [-122.41033, 37.69319], [-122.41045, 37.69312], [-122.41047, 37.69288], [-122.41044, 37.69284], [-122.41038, 37.69282], [-122.41014, 37.69279], [-122.41013, 37.69271], [-122.41027, 37.6926], [-122.41031, 37.69247], [-122.41038, 37.69248], [-122.41044, 37.69246], [-122.41043, 37.69242], [-122.41048, 37.69238], [-122.41066, 37.69245], [-122.41088, 37.69229], [-122.41089, 37.69226], [-122.41099, 37.69226], [-122.41108, 37.69222], [-122.41111, 37.69218], [-122.41106, 37.69215], [-122.41107, 37.69212], [-122.41128, 37.69211], [-122.4114, 37.69185], [-122.41169, 37.69197], [-122.4117, 37.69199], [-122.41194, 37.6921], [-122.41198, 37.69209], [-122.41205, 37.69214], [-122.41207, 37.69217], [-122.4122, 37.69223], [-122.41224, 37.69224], [-122.41252, 37.69244], [-122.41252, 37.69248], [-122.4126, 37.69255], [-122.41264, 37.69256], [-122.41279, 37.69266], [-122.4128, 37.6927], [-122.41294, 37.69278], [-122.41302, 37.69279], [-122.41335, 37.69294], [-122.4134, 37.69298], [-122.41357, 37.69302], [-122.41365, 37.69301], [-122.41404, 37.69304], [-122.4144, 37.693], [-122.41442, 37.69303], [-122.41451, 37.69302], [-122.41454, 37.69297], [-122.41469, 37.69293], [-122.41497, 37.69291], [-122.41501, 37.69289], [-122.41505, 37.69291], [-122.41525, 37.6929], [-122.4154, 37.69293], [-122.41543, 37.69292], [-122.41563, 37.69294], [-122.41565, 37.69297], [-122.41646, 37.69307], [-122.4171, 37.6932], [-122.41725, 37.69324], [-122.41743, 37.69325], [-122.41744, 37.69326], [-122.41746, 37.69335], [-122.41749, 37.69342], [-122.41766, 37.69364], [-122.41777, 37.69375], [-122.41819, 37.69409], [-122.41818, 37.69411], [-122.41834, 37.69424], [-122.41874, 37.69437], [-122.41885, 37.69444]]], [[[-122.41994, 37.69322], [-122.41988, 37.69325], [-122.41983, 37.69325], [-122.4197, 37.69319], [-122.41968, 37.69312], [-122.41958, 37.69301], [-122.41937, 37.69292], [-122.41935, 37.69287], [-122.41936, 37.69277], [-122.41932, 37.69269], [-122.41913, 37.69258], [-122.41899, 37.69255], [-122.41886, 37.69258], [-122.41879, 37.69249], [-122.41866, 37.69245], [-122.41847, 37.69244], [-122.41833, 37.69246], [-122.41827, 37.69241], [-122.41812, 37.69236], [-122.41803, 37.69234], [-122.41789, 37.69235], [-122.41768, 37.69226], [-122.41745, 37.69226], [-122.41725, 37.69229], [-122.41691, 37.69223], [-122.41675, 37.69227], [-122.41657, 37.69226], [-122.41625, 37.69232], [-122.41609, 37.69229], [-122.41558, 37.69239], [-122.41553, 37.69236], [-122.41542, 37.69234], [-122.41449, 37.69226], [-122.41437, 37.69218], [-122.41426, 37.69212], [-122.41348, 37.69188], [-122.41275, 37.69155], [-122.41271, 37.69154], [-122.41253, 37.69156], [-122.41248, 37.69143], [-122.4124, 37.69131], [-122.41185, 37.69078], [-122.41184, 37.69073], [-122.41179, 37.69069], [-122.41174, 37.69061], [-122.41172, 37.69059], [-122.41165, 37.69059], [-122.41139, 37.69034], [-122.41138, 37.69029], [-122.41131, 37.69024], [-122.41127, 37.69024], [-122.41122, 37.6902], [-122.4113, 37.6901], [-122.4114, 37.69015], [-122.41157, 37.69024], [-122.41193, 37.69051], [-122.41333, 37.69139], [-122.41386, 37.69164], [-122.41439, 37.69182], [-122.41499, 37.69194], [-122.41555, 37.69199], [-122.41602, 37.69198], [-122.41729, 37.69189], [-122.41758, 37.6919], [-122.41784, 37.69195], [-122.41968, 37.6925], [-122.41965, 37.69271], [-122.41968, 37.69289], [-122.41978, 37.69306], [-122.41994, 37.69322]]], [[[-122.41389, 37.69874], [-122.41362, 37.69876], [-122.41335, 37.69881], [-122.4131, 37.69889], [-122.41284, 37.69901], [-122.4127, 37.69939], [-122.41274, 37.69942], [-122.41259, 37.69957], [-122.41246, 37.69972], [-122.41237, 37.69987], [-122.41227, 37.70007], [-122.41195, 37.69998], [-122.41262, 37.69847], [-122.41389, 37.69874]]], [[[-122.41627, 37.69926], [-122.41623, 37.69934], [-122.4159, 37.69925], [-122.41593, 37.69918], [-122.41627, 37.69926]]], [[[-122.41682, 37.69938], [-122.41677, 37.69949], [-122.41645, 37.6994], [-122.41649, 37.69931], [-122.41682, 37.69938]]], [[[-122.42369, 37.69362], [-122.42242, 37.69613], [-122.42153, 37.69584], [-122.42149, 37.69579], [-122.4215, 37.69577], [-122.42149, 37.69561], [-122.42145, 37.69542], [-122.42137, 37.69525], [-122.42126, 37.69508], [-122.42125, 37.69498], [-122.4212, 37.69493], [-122.42111, 37.69488], [-122.42105, 37.69476], [-122.42094, 37.69465], [-122.42073, 37.69472], [-122.42053, 37.69488], [-122.4204, 37.69477], [-122.42052, 37.69469], [-122.42058, 37.69457], [-122.42058, 37.69454], [-122.42055, 37.69452], [-122.42057, 37.69437], [-122.42056, 37.69423], [-122.42061, 37.69421], [-122.42062, 37.69414], [-122.42065, 37.69409], [-122.42065, 37.69402], [-122.42067, 37.69396], [-122.42064, 37.69392], [-122.42079, 37.69368], [-122.42084, 37.69365], [-122.42086, 37.69357], [-122.42085, 37.69353], [-122.42083, 37.69351], [-122.42083, 37.69346], [-122.42091, 37.69343], [-122.42099, 37.69333], [-122.42099, 37.69329], [-122.42157, 37.69302], [-122.42218, 37.69318], [-122.42345, 37.69357], [-122.42369, 37.69362]]], [[[-122.45778, 37.69822], [-122.45713, 37.69848], [-122.4569, 37.69839], [-122.45677, 37.69801], [-122.45665, 37.69791], [-122.45637, 37.69784], [-122.45602, 37.69762], [-122.4559, 37.69761], [-122.45561, 37.69771], [-122.45557, 37.69797], [-122.45505, 37.69801], [-122.4548, 37.69796], [-122.45465, 37.6978], [-122.45431, 37.69775], [-122.45379, 37.69781], [-122.45376, 37.69776], [-122.45348, 37.69775], [-122.45335, 37.6978], [-122.45316, 37.69807], [-122.45278, 37.69819], [-122.45257, 37.69811], [-122.45212, 37.69808], [-122.45203, 37.69815], [-122.45194, 37.69842], [-122.45218, 37.69879], [-122.45226, 37.69903], [-122.45271, 37.69925], [-122.45254, 37.6995], [-122.45215, 37.69983], [-122.45191, 37.70022], [-122.45191, 37.70053], [-122.45209, 37.70081], [-122.45174, 37.70127], [-122.45128, 37.70148], [-122.45101, 37.70173], [-122.45004, 37.70226], [-122.45001, 37.70247], [-122.44971, 37.70269], [-122.44937, 37.70286], [-122.44916, 37.70289], [-122.44886, 37.70286], [-122.44871, 37.70287], [-122.44857, 37.70293], [-122.44844, 37.70306], [-122.44835, 37.70312], [-122.44822, 37.70316], [-122.44809, 37.70317], [-122.44782, 37.70313], [-122.44777, 37.7031], [-122.44773, 37.70304], [-122.44768, 37.703], [-122.44762, 37.70299], [-122.44752, 37.70301], [-122.44746, 37.703], [-122.44718, 37.7029], [-122.44695, 37.70279], [-122.44905, 37.70165], [-122.44905, 37.70163], [-122.44893, 37.70159], [-122.44919, 37.70148], [-122.44943, 37.70134], [-122.44965, 37.70118], [-122.44982, 37.70099], [-122.44997, 37.70075], [-122.45007, 37.7005], [-122.45042, 37.6987], [-122.45048, 37.69848], [-122.45059, 37.69822], [-122.45073, 37.69797], [-122.45091, 37.69773], [-122.45234, 37.69608], [-122.45319, 37.69684], [-122.45485, 37.69643], [-122.456, 37.69525], [-122.45611, 37.69638], [-122.45698, 37.69769], [-122.45778, 37.69822]]]]} | Open Access 1 | 21942 | San Bruno Mountain State and County Park | 29293 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | https://parks.smcgov.org/san-bruno-mountain-state-county-park | San Mateo 15 | 2072.999 | San Bruno Mtn. State and County Park | 2000 | Local Park 2 | 4 |
54 | 54 | 53 | {"type": "Polygon", "coordinates": [[[-119.73175, 36.7591], [-119.73175, 36.75936], [-119.73077, 36.75936], [-119.72949, 36.75856], [-119.72945, 36.75845], [-119.72945, 36.75759], [-119.73145, 36.7576], [-119.73104, 36.75782], [-119.73095, 36.75784], [-119.73086, 36.75791], [-119.73087, 36.75827], [-119.73094, 36.75851], [-119.73101, 36.75863], [-119.73118, 36.75885], [-119.73131, 36.75898], [-119.73139, 36.75904], [-119.73157, 36.75909], [-119.73175, 36.7591]]]} | Open Access 1 | 125 | Carozza Park | 16891 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.025 | Carozza Park | 0 | Local Park 2 | 4 | |
55 | 55 | 54 | {"type": "Polygon", "coordinates": [[[-121.12622, 37.47895], [-121.12464, 37.47968], [-121.12384, 37.47861], [-121.12544, 37.47788], [-121.12622, 37.47895]]]} | Open Access 1 | 128 | Felipe Garza Park | 18867 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 5.539 | Felipe Garza Park | 0 | Local Park 2 | 4 | |
57 | 57 | 56 | {"type": "Polygon", "coordinates": [[[-117.16831, 32.71264], [-117.16831, 32.71356], [-117.1674, 32.71356], [-117.1674, 32.71264], [-117.16831, 32.71264]]]} | Open Access 1 | 170 | Pantoja Neighborhood Park | 30100 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.149 | Pantoja Neighborhood Park | 0 | Local Park 2 | 4 | |
58 | 58 | 57 | {"type": "Polygon", "coordinates": [[[-117.02209, 32.79762], [-117.02195, 32.79979], [-117.02062, 32.79972], [-117.02075, 32.79755], [-117.02202, 32.79758], [-117.02207, 32.7976], [-117.02209, 32.79762]]]} | Open Access 1 | 129 | San Carlos Community Park | 24847 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 7.486 | San Carlos Community Park | 0 | Local Park 2 | 4 | |
59 | 59 | 58 | {"type": "Polygon", "coordinates": [[[-121.1527, 37.47726], [-121.15269, 37.47821], [-121.15093, 37.47821], [-121.15093, 37.47775], [-121.15095, 37.47748], [-121.15165, 37.47732], [-121.15206, 37.47726], [-121.1527, 37.47726]]]} | Open Access 1 | 143 | Goldbar Park | 19357 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.779 | Goldbar Park | 0 | Local Park 2 | 4 | |
60 | 60 | 59 | {"type": "Polygon", "coordinates": [[[-121.14269, 37.47264], [-121.14187, 37.47299], [-121.14169, 37.47269], [-121.14164, 37.47256], [-121.1416, 37.47241], [-121.14166, 37.47235], [-121.14203, 37.47228], [-121.14236, 37.47215], [-121.14269, 37.47264]]]} | Open Access 1 | 148 | Golden Amber Park | 19358 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.295 | Golden Amber Park | 0 | Local Park 2 | 4 | |
61 | 61 | 60 | {"type": "Polygon", "coordinates": [[[-117.12117, 32.92243], [-117.12114, 32.92415], [-117.11938, 32.9242], [-117.11931, 32.92417], [-117.11913, 32.9225], [-117.11913, 32.92238], [-117.12117, 32.92243]]]} | Open Access 1 | 146 | Westview Park | 27432 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 8.82 | Westview Park | 0 | Local Park 2 | 4 | |
62 | 62 | 61 | {"type": "Polygon", "coordinates": [[[-122.66503, 38.48047], [-122.66507, 38.48062], [-122.66507, 38.48074], [-122.66505, 38.48087], [-122.66498, 38.48107], [-122.66496, 38.48119], [-122.66497, 38.48269], [-122.66322, 38.483], [-122.66293, 38.48249], [-122.66263, 38.48191], [-122.66259, 38.48191], [-122.66235, 38.48147], [-122.66342, 38.48127], [-122.66343, 38.48126], [-122.66201, 38.47875], [-122.6625, 38.47876], [-122.66282, 38.47874], [-122.66322, 38.4787], [-122.66362, 38.47862], [-122.6647, 38.48058], [-122.66503, 38.48047]]]} | Open Access 1 | 151 | Rincon Valley Community Park | 24371 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 18.752 | Rincon Valley Community Park | 0 | Local Park 2 | 4 | |
64 | 64 | 63 | {"type": "Polygon", "coordinates": [[[-121.91483, 37.63509], [-121.91478, 37.64364], [-121.9097, 37.64611], [-121.90561, 37.63248], [-121.90568, 37.63243], [-121.91279, 37.63249], [-121.9128, 37.63255], [-121.91326, 37.63289], [-121.91409, 37.63322], [-121.91427, 37.63348], [-121.91481, 37.63393], [-121.91472, 37.63444], [-121.91458, 37.63451], [-121.91479, 37.63476], [-121.9147, 37.63482], [-121.91478, 37.63509], [-121.91483, 37.63509]]]} | Open Access 1 | 185 | Augustin Bernal Park | 8732 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/services/recreation/rec-augustinpark.html | Alameda 17 | 217.388 | Augustin Bernal Park | 0 | Local Park 2 | 4 |
65 | 65 | 64 | {"type": "Polygon", "coordinates": [[[-119.79845, 36.71057], [-119.79843, 36.71219], [-119.7971, 36.71219], [-119.79701, 36.71221], [-119.79693, 36.71228], [-119.79644, 36.71228], [-119.79644, 36.71058], [-119.79845, 36.71057]]]} | Open Access 1 | 189 | Carver Park | 16927 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.052 | Carver Park | 0 | Local Park 2 | 4 | |
66 | 66 | 65 | {"type": "Polygon", "coordinates": [[[-118.24767, 33.99122], [-118.24568, 33.99122], [-118.24567, 33.98955], [-118.24762, 33.98955], [-118.24767, 33.99122]]]} | Open Access 1 | 190 | Augustus Hawkins Natural Park | 15707 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 8.369 | Augustus Hawkins Natural Park | 0 | Local Park 2 | 4 | |
68 | 68 | 67 | {"type": "MultiPolygon", "coordinates": [[[[-117.08318, 32.79598], [-117.08318, 32.79625], [-117.07976, 32.79623], [-117.07979, 32.79489], [-117.08005, 32.79464], [-117.08026, 32.79453], [-117.08041, 32.79449], [-117.08053, 32.79447], [-117.08069, 32.79447], [-117.08088, 32.79451], [-117.08105, 32.79458], [-117.08115, 32.79463], [-117.08253, 32.7958], [-117.0828, 32.79593], [-117.083, 32.79597], [-117.08318, 32.79598]]], [[[-117.08168, 32.79321], [-117.08167, 32.7939], [-117.08165, 32.79398], [-117.08157, 32.79411], [-117.08123, 32.79443], [-117.08117, 32.79444], [-117.08096, 32.79435], [-117.08077, 32.79431], [-117.08057, 32.7943], [-117.08036, 32.79433], [-117.07996, 32.79402], [-117.08082, 32.79319], [-117.08168, 32.79321]]]]} | Open Access 1 | 155 | Allied Gardens Community Park | 15383 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 13.814 | Allied Gardens Community Park | 0 | Local Park 2 | 4 | |
69 | 69 | 68 | {"type": "Polygon", "coordinates": [[[-117.06833, 32.78979], [-117.0681, 32.78985], [-117.06791, 32.78987], [-117.06755, 32.78998], [-117.06712, 32.79007], [-117.0668, 32.78832], [-117.06803, 32.78813], [-117.06823, 32.7894], [-117.06833, 32.78979]]]} | Open Access 1 | 163 | Princess Del Cerro Neighborhood Park | 30167 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.472 | Princess Del Cerro Neighborhood Park | 0 | Local Park 2 | 4 | |
70 | 70 | 69 | {"type": "Polygon", "coordinates": [[[-117.09581, 32.78702], [-117.0958, 32.78757], [-117.09407, 32.78755], [-117.09403, 32.78751], [-117.09402, 32.78697], [-117.09483, 32.78698], [-117.09581, 32.78702]]]} | Open Access 1 | 164 | Grantville Neighborhood Park | 30217 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 2.604 | Grantville Neighborhood Park | 0 | Local Park 2 | 4 | |
71 | 71 | 70 | {"type": "MultiPolygon", "coordinates": [[[[-121.12968, 37.47162], [-121.12901, 37.47193], [-121.12846, 37.47115], [-121.12967, 37.4715], [-121.12968, 37.47162]]], [[[-121.12992, 37.4719], [-121.12992, 37.4719], [-121.12973, 37.47288], [-121.12916, 37.47211], [-121.1298, 37.47182], [-121.12992, 37.4719]]]]} | Open Access 1 | 209 | Veterans Memorial Park | 27031 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.982 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
73 | 73 | 72 | {"type": "Polygon", "coordinates": [[[-121.14527, 37.47444], [-121.14472, 37.47469], [-121.14451, 37.47482], [-121.1445, 37.47484], [-121.14457, 37.47488], [-121.14435, 37.47509], [-121.14375, 37.47469], [-121.14375, 37.47462], [-121.14395, 37.47443], [-121.14407, 37.47433], [-121.14432, 37.47419], [-121.14487, 37.47396], [-121.14497, 37.47398], [-121.14527, 37.47444]]]} | Open Access 1 | 172 | Newcastle Park | 22719 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.056 | Newcastle Park | 0 | Local Park 2 | 4 | |
74 | 74 | 73 | {"type": "Polygon", "coordinates": [[[-121.88839, 37.30077], [-121.88844, 37.30077], [-121.88849, 37.3008], [-121.88874, 37.30116], [-121.88913, 37.30175], [-121.88914, 37.3018], [-121.88912, 37.30184], [-121.88672, 37.30289], [-121.88666, 37.30289], [-121.88661, 37.30287], [-121.88592, 37.30185], [-121.88593, 37.3018], [-121.88839, 37.30077]]]} | Open Access 1 | 173 | River Glen Park | 24409 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.688 | River Glen Park | 1983 | Local Park 2 | 4 | |
75 | 75 | 74 | {"type": "Polygon", "coordinates": [[[-122.05137, 36.97047], [-122.05103, 36.97055], [-122.05096, 36.97049], [-122.05087, 36.97031], [-122.05129, 36.97021], [-122.05137, 36.97047]]]} | Open Access 1 | 182 | Round Tree Park | 24704 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.27 | Round Tree Park | 0 | Local Park 2 | 4 | |
76 | 76 | 75 | {"type": "Polygon", "coordinates": [[[-117.21231, 32.83417], [-117.2123, 32.83532], [-117.21045, 32.83532], [-117.21045, 32.83506], [-117.21039, 32.83505], [-117.2104, 32.83456], [-117.2105, 32.83441], [-117.21086, 32.83404], [-117.21145, 32.83441], [-117.21146, 32.8344], [-117.21146, 32.83418], [-117.21231, 32.83417]]]} | Open Access 1 | 228 | Gershwin Neighborhood Park | 30085 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 5.364 | Gershwin Neighborhood 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]);