units_with_maps_view (view)
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4357 | {"type": "Polygon", "coordinates": [[[-118.2853, 33.94082], [-118.2853, 33.94114], [-118.28516, 33.94114], [-118.28516, 33.94082], [-118.2853, 33.94082]]]} | 1 | 45731 | 105th Street Pocket Park | 28734 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 1188 | 24 | 2 | 2 | http://www.laparks.org/environmental/105th.htm | 6 | 0.111 | 105th Street PP | 0 | 2 | 4 |
998 | {"type": "Polygon", "coordinates": [[[-118.24932, 33.93589], [-118.24931, 33.93673], [-118.24783, 33.93674], [-118.24784, 33.93589], [-118.24932, 33.93589]]]} | 1 | 6218 | 109th Street Recreation Center | 15168 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 1188 | 24 | 2 | 2 | 6 | 3.184 | 109th Street Rec. Ctr. | 0 | 3 | 4 | |
7978 | {"type": "Polygon", "coordinates": [[[-122.46853, 37.78203], [-122.4677, 37.78207], [-122.46767, 37.78166], [-122.4685, 37.78162], [-122.46853, 37.78203]], [[-122.4682, 37.78188], [-122.46824, 37.78188], [-122.46824, 37.78181], [-122.46819, 37.7818], [-122.46818, 37.78172], [-122.46796, 37.78173], [-122.46798, 37.78197], [-122.4682, 37.78197], [-122.4682, 37.78188]]]} | 1 | 15960 | 10th Ave & Clement Mini Park | 15169 | 1300 | 21 | 2 | 2 | http://sfrecpark.org/ | 2 | 1300 | 21 | 2 | 2 | 13 | 0.684 | 10th Ave & Clement MP | 0 | 2 | 4 | |
4222 | {"type": "Polygon", "coordinates": [[[-118.2713, 33.93401], [-118.2713, 33.93437], [-118.2712, 33.93437], [-118.2712, 33.93401], [-118.2713, 33.93401]]]} | 1 | 45017 | 111th Place Neighborhood Park | 27920 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 1188 | 24 | 2 | 2 | http://www.laparks.org/environmental/pdf/111thPark.pdf | 6 | 0.09 | 111th Place Neighborhood Park | 0 | 2 | 4 |
4370 | {"type": "MultiPolygon", "coordinates": [[[[-118.24124, 33.92765], [-118.24116, 33.9276], [-118.24085, 33.92733], [-118.24124, 33.92733], [-118.24124, 33.92765]]], [[[-118.24433, 33.92779], [-118.24433, 33.92814], [-118.24389, 33.92811], [-118.2427, 33.92796], [-118.24172, 33.92781], [-118.24433, 33.92779]]], [[[-118.24465, 33.92779], [-118.24465, 33.92817], [-118.24449, 33.92815], [-118.24449, 33.92779], [-118.24465, 33.92779]]], [[[-118.24611, 33.9282], [-118.24572, 33.9282], [-118.24571, 33.92817], [-118.24482, 33.92817], [-118.24482, 33.92779], [-118.24607, 33.92779], [-118.24611, 33.92784], [-118.24611, 33.9282]]]]} | 4 | 45850 | 117th and Compton | 28898 | 305 | 16 | 3 | 3 | http://parks.lacounty.gov | 3 | 305 | 16 | 3 | 3 | 6 | 2.884 | 117th and Compton | 387 | |||
8162 | {"type": "Polygon", "coordinates": [[[-118.34102, 33.92741], [-118.34102, 33.92741], [-118.34058, 33.92712], [-118.34101, 33.92713], [-118.34102, 33.92741]]]} | 1 | 46481 | 118th Street Mini Park | 29761 | 1130 | 299 | 2 | 2 | http://www.cityofhawthorne.com/ | 2 | 1130 | 295 | 2 | 2 | 6 | 0.154 | 118th Street MP | 0 | 2 | 4 | |
4362 | {"type": "Polygon", "coordinates": [[[-118.32926, 33.98393], [-118.32926, 33.98408], [-118.32896, 33.98418], [-118.32863, 33.98434], [-118.32863, 33.98418], [-118.3287, 33.98418], [-118.32926, 33.98393]]]} | 1 | 45774 | 11th Avenue Park | 28781 | 1188 | 24 | 2 | 2 | http://lacity.org/ | 2 | 1188 | 24 | 2 | 2 | http://www.lanlt.org/parks-and-gardens.php#11th | 6 | 0.207 | 11th Avenue Park | 0 | 2 | 4 |
6335 | {"type": "Polygon", "coordinates": [[[-118.0693, 33.71722], [-118.06917, 33.71732], [-118.06861, 33.71687], [-118.06878, 33.71676], [-118.0693, 33.71722]]]} | 1 | 47442 | 11th Street Beach Park | 31159 | 1142 | 85 | 2 | 2 | http://www.hpca.gov/index.aspx?nid=14 | 2 | 1142 | 83 | 2 | 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/11th-street-beach-park.cfm | 3 | 0.322 | 11th Street Beach Park | 0 | 2 | 4 |
3611 | {"type": "Polygon", "coordinates": [[[-120.4815, 37.29325], [-120.48128, 37.29362], [-120.48113, 37.29357], [-120.48134, 37.29319], [-120.4815, 37.29325]]]} | 1 | 47309 | 11th Street Neighborhood Park | 31016 | 1203 | 474 | 2 | 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | 2 | 1203 | 467 | 2 | 2 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | 37 | 0.172 | 11th Street Neighborhood Park | 0 | 2 | 4 |
6510 | {"type": "Polygon", "coordinates": [[[-117.64341, 34.11057], [-117.64175, 34.11057], [-117.6417, 34.11053], [-117.6417, 34.11008], [-117.64338, 34.11007], [-117.64341, 34.11011], [-117.64341, 34.11057]]]} | 1 | 2522 | 13th Street Reservoir Park | 15171 | 1363 | 145 | 2 | 2 | http://www.ci.upland.ca.us/asp/Site/Recreation/GeneralInfo/index.asp | 2 | 1363 | 141 | 2 | 2 | 22 | 2.129 | 13th Street Reservoir Park | 0 | 2 | 4 | |
4898 | {"type": "MultiPolygon", "coordinates": [[[[-122.47227, 37.75682], [-122.47215, 37.75701], [-122.47202, 37.75727], [-122.47195, 37.75729], [-122.47141, 37.75706], [-122.47129, 37.75698], [-122.4712, 37.7569], [-122.47111, 37.75678], [-122.47106, 37.75665], [-122.47105, 37.75655], [-122.47106, 37.75638], [-122.47147, 37.75639], [-122.47146, 37.75656], [-122.47151, 37.75669], [-122.47162, 37.75678], [-122.47179, 37.75685], [-122.47194, 37.75665], [-122.47227, 37.75682]]], [[[-122.47149, 37.75605], [-122.47147, 37.75632], [-122.47108, 37.75631], [-122.47109, 37.75604], [-122.47149, 37.75605]]], [[[-122.47257, 37.75623], [-122.47259, 37.75633], [-122.47257, 37.75647], [-122.47252, 37.75655], [-122.47232, 37.75676], [-122.47199, 37.75659], [-122.47219, 37.75636], [-122.4722, 37.75634], [-122.47197, 37.75608], [-122.47171, 37.7559], [-122.47192, 37.75563], [-122.47207, 37.75572], [-122.47224, 37.75585], [-122.47238, 37.756], [-122.47257, 37.75623]]]]} | 1 | 5586 | 14th & 15th Avenue Open Space | 15172 | 1300 | 21 | 2 | 2 | http://sfrecpark.org/ | 2 | 1300 | 21 | 2 | 2 | 13 | 2.665 | 14th & 15th Avenue OS | 0 | 3 | 4 | |
7326 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | 1 | 6641 | 14th Street Park and Playground | 15173 | 1184 | 298 | 2 | 2 | http://www.longbeach.gov/park/default.asp | 2 | 1184 | 294 | 2 | 2 | 6 | 1.661 | 14th Street Park and Playground | 0 | 3 | 4 | |
6952 | {"type": "Polygon", "coordinates": [[[-122.47276, 37.75963], [-122.47241, 37.75965], [-122.47242, 37.75992], [-122.47229, 37.75993], [-122.47227, 37.75965], [-122.47186, 37.75967], [-122.47184, 37.75949], [-122.47225, 37.75947], [-122.47223, 37.75917], [-122.47237, 37.75919], [-122.4724, 37.75955], [-122.47275, 37.75954], [-122.47276, 37.75963]]]} | 1 | 5859 | 15th Avenue Steps | 15174 | 1300 | 21 | 2 | 2 | http://sfrecpark.org/ | 2 | 1300 | 21 | 2 | 2 | 13 | 0.516 | 15th Avenue Steps | 568 | |||
12383 | {"type": "Polygon", "coordinates": [[[-120.61198, 35.11407], [-120.61192, 35.1148], [-120.60972, 35.11469], [-120.60972, 35.11439], [-120.60966, 35.11409], [-120.61027, 35.11394], [-120.61038, 35.11396], [-120.6107, 35.11398], [-120.61068, 35.114], [-120.61069, 35.11401], [-120.61198, 35.11407]]]} | 1 | 26521 | 16th Street Park | 15175 | 1452 | 654 | 2 | 2 | http://www.grover.org/index.aspx?nid=141 | 2 | 1452 | 643 | 2 | 2 | 1 | 4.082 | 16th Street Park | 0 | 2 | 4 | |
1537 | {"type": "Polygon", "coordinates": [[[-119.7988, 36.28916], [-119.79442, 36.28915], [-119.79441, 36.289], [-119.79335, 36.289], [-119.79335, 36.28889], [-119.79441, 36.28841], [-119.79847, 36.28677], [-119.7987, 36.28683], [-119.79873, 36.28803], [-119.79881, 36.28828], [-119.7988, 36.28916]]]} | 1 | 11241 | 19th Avenue Park | 15176 | 1174 | 380 | 2 | 2 | http://www.lemoore.com/parks/default.html | 2 | 1174 | 375 | 2 | 2 | 44 | 18.284 | 19th Avenue Park | 0 | 2 | 4 | |
17043 | {"type": "Polygon", "coordinates": [[[-118.24477, 34.05427], [-118.24461, 34.05444], [-118.24459, 34.05443], [-118.24454, 34.05449], [-118.24455, 34.05451], [-118.24403, 34.05507], [-118.2432, 34.05453], [-118.24394, 34.05373], [-118.24477, 34.05427]]]} | 1 | 45773 | 1st and Broadway Civic Center Park | 29093 | 1716 | 660 | 2 | 2 | http://www.laparks.org/ | 2 | 1716 | 647 | 2 | 2 | 6 | 2.682 | 1st and Broadway Civic Ctr. Park | 0 | 2 | 4 | |
12068 | {"type": "Polygon", "coordinates": [[[-124.174, 40.78401], [-124.174, 40.78456], [-124.17298, 40.78455], [-124.17297, 40.78439], [-124.17198, 40.78439], [-124.17198, 40.78413], [-124.17249, 40.78413], [-124.1725, 40.78384], [-124.17297, 40.78384], [-124.17298, 40.78375], [-124.17379, 40.78376], [-124.17379, 40.784], [-124.174, 40.78401]]]} | 1 | 24769 | 20-30 Park and Playground | 15177 | 1419 | 715 | 2 | 2 | http://www.ci.eureka.ca.gov/depts/pnr/default.asp | 2 | 1419 | 698 | 2 | 2 | 45 | 2.7 | 20-30 Park and Playground | 0 | 3 | 4 | |
1828 | {"type": "MultiPolygon", "coordinates": [[[[-121.81612, 39.73135], [-121.81386, 39.73158], [-121.81325, 39.73086], [-121.81256, 39.72996], [-121.81236, 39.72969], [-121.81298, 39.72941], [-121.81278, 39.72916], [-121.81233, 39.72845], [-121.81238, 39.72843], [-121.81242, 39.72694], [-121.81242, 39.72644], [-121.81291, 39.72644], [-121.81431, 39.72746], [-121.81522, 39.72735], [-121.81532, 39.72743], [-121.81549, 39.72741], [-121.81549, 39.72792], [-121.81551, 39.72812], [-121.81561, 39.72812], [-121.81612, 39.73135]]], [[[-121.81639, 39.73299], [-121.81549, 39.73308], [-121.81469, 39.73241], [-121.81424, 39.73197], [-121.8139, 39.73162], [-121.81613, 39.7314], [-121.81639, 39.73299]]]]} | 1 | 15710 | 20th Street Park | 15178 | 1052 | 430 | 2 | 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | 2 | 1052 | 424 | 2 | 2 | 42 | 37.854 | 20th Street Park | 0 | 2 | 4 | |
3652 | {"type": "Polygon", "coordinates": [[[-121.64347, 37.11265], [-121.64347, 37.11268], [-121.64305, 37.11279], [-121.64285, 37.11264], [-121.64329, 37.11251], [-121.64336, 37.1126], [-121.64341, 37.11259], [-121.64345, 37.11265], [-121.64347, 37.11265]]]} | 1 | 29875 | 21 Mile Park | 15179 | 1217 | 416 | 2 | 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | 2 | 1217 | 410 | 2 | 2 | 19 | 0.221 | 21 Mile Park | 0 | 2 | 4 | |
11025 | {"type": "MultiPolygon", "coordinates": [[[[-121.41422, 38.53219], [-121.41307, 38.5322], [-121.41293, 38.53216], [-121.41289, 38.53211], [-121.41292, 38.53205], [-121.41299, 38.53202], [-121.41418, 38.53201], [-121.41422, 38.53203], [-121.41423, 38.53216], [-121.41422, 38.53219]]], [[[-121.41671, 38.53219], [-121.41443, 38.53219], [-121.41441, 38.53218], [-121.41439, 38.53203], [-121.41442, 38.53202], [-121.41666, 38.53202], [-121.4167, 38.53204], [-121.41671, 38.53219]]], [[[-121.41912, 38.53205], [-121.41898, 38.53229], [-121.4189, 38.53231], [-121.41792, 38.53231], [-121.4169, 38.5322], [-121.41688, 38.53218], [-121.41688, 38.53204], [-121.41691, 38.53202], [-121.41909, 38.53202], [-121.41912, 38.53205]]], [[[-121.42107, 38.53205], [-121.42106, 38.53229], [-121.42104, 38.53231], [-121.41918, 38.5323], [-121.41933, 38.53204], [-121.41937, 38.53202], [-121.42105, 38.53202], [-121.42107, 38.53205]]], [[[-121.42604, 38.53216], [-121.42604, 38.53227], [-121.42601, 38.53228], [-121.42297, 38.53227], [-121.42248, 38.53232], [-121.42127, 38.53231], [-121.42124, 38.53229], [-121.42125, 38.53205], [-121.42128, 38.53203], [-121.42312, 38.53203], [-121.42419, 38.53215], [-121.42604, 38.53216]]], [[[-121.42712, 38.53223], [-121.42711, 38.53225], [-121.42691, 38.53224], [-121.42678, 38.53228], [-121.42624, 38.53228], [-121.42622, 38.53227], [-121.42623, 38.53217], [-121.42624, 38.53215], [-121.42663, 38.53217], [-121.42712, 38.53223]]], [[[-121.4294, 38.53226], [-121.42938, 38.53227], [-121.42797, 38.53227], [-121.42796, 38.53226], [-121.42797, 38.53225], [-121.42818, 38.53225], [-121.4284, 38.53221], [-121.42899, 38.53215], [-121.42939, 38.53214], [-121.4294, 38.53226]]], [[[-121.43268, 38.53204], [-121.43268, 38.53227], [-121.43264, 38.5323], [-121.43224, 38.5323], [-121.43202, 38.53227], [-121.4296, 38.53227], [-121.42959, 38.53226], [-121.42959, 38.53215], [-121.42962, 38.53214], [-121.43036, 38.53214], [-121.43129, 38.53203], [-121.43265, 38.53202], [-121.43268, 38.53204]]], [[[-121.43516, 38.5322], [-121.43456, 38.53227], [-121.43288, 38.5323], [-121.43286, 38.53229], [-121.43286, 38.53204], [-121.43289, 38.53201], [-121.43512, 38.53199], [-121.43515, 38.53201], [-121.43518, 38.53217], [-121.43516, 38.5322]]], [[[-121.43863, 38.53196], [-121.43864, 38.53198], [-121.43853, 38.53212], [-121.43848, 38.53213], [-121.43566, 38.53216], [-121.4354, 38.53219], [-121.43537, 38.53217], [-121.43533, 38.53201], [-121.43535, 38.53198], [-121.43863, 38.53196]]], [[[-121.44204, 38.53208], [-121.44201, 38.53209], [-121.43875, 38.53213], [-121.43874, 38.53211], [-121.43884, 38.53197], [-121.43888, 38.53195], [-121.44129, 38.53192], [-121.44158, 38.53195], [-121.44202, 38.53194], [-121.44204, 38.53195], [-121.44204, 38.53208]]], [[[-121.44318, 38.53193], [-121.44319, 38.53196], [-121.44319, 38.53205], [-121.44317, 38.53206], [-121.44224, 38.53209], [-121.44222, 38.53208], [-121.44222, 38.53196], [-121.44224, 38.53194], [-121.44318, 38.53193]]], [[[-121.44435, 38.53195], [-121.44434, 38.53204], [-121.44432, 38.53206], [-121.44339, 38.53206], [-121.44337, 38.53204], [-121.44338, 38.53195], [-121.4434, 38.53194], [-121.44435, 38.53195]]], [[[-121.44543, 38.53192], [-121.44542, 38.53194], [-121.4452, 38.53199], [-121.4449, 38.53204], [-121.44455, 38.53206], [-121.44453, 38.53203], [-121.44453, 38.53195], [-121.44456, 38.53193], [-121.44543, 38.53192]]]]} | 1 | 21183 | 21st Avenue Parkway | 15182 | 1287 | 541 | 2 | 2 | http://portal.cityofsacramento.org/ParksandRec | 2 | 1287 | 534 | 2 | 2 | 41 | 13.339 | 21st Avenue Parkway | 0 | 3 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW units_with_maps_view AS select id, AsGeoJSON(geometry) as 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 from CPAD_2020a_Units order by id;