calands: superunits_with_maps: 148 rows where LAYER = 2 and MNG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

148 rows where LAYER = 2 and MNG_AGENCY = 294

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
506	506	505	{"type": "MultiPolygon", "coordinates": [[[[-118.09899, 33.80339], [-118.09898, 33.80692], [-118.09892, 33.8069], [-118.0986, 33.8069], [-118.09853, 33.80691], [-118.09849, 33.80693], [-118.09845, 33.807], [-118.09844, 33.80738], [-118.09845, 33.80743], [-118.09847, 33.80749], [-118.09857, 33.80755], [-118.09893, 33.80755], [-118.09897, 33.80753], [-118.09896, 33.81027], [-118.09889, 33.81033], [-118.09798, 33.81032], [-118.09751, 33.8103], [-118.09184, 33.81029], [-118.09183, 33.81024], [-118.09172, 33.81024], [-118.0917, 33.80987], [-118.09176, 33.80986], [-118.0925, 33.81009], [-118.09343, 33.81003], [-118.09439, 33.81005], [-118.09542, 33.80984], [-118.09547, 33.8085], [-118.0948, 33.80682], [-118.09427, 33.80608], [-118.09376, 33.80564], [-118.09295, 33.80521], [-118.09249, 33.80501], [-118.0921, 33.8049], [-118.09208, 33.80476], [-118.09184, 33.80467], [-118.09162, 33.80454], [-118.0916, 33.80443], [-118.09178, 33.80441], [-118.09247, 33.80438], [-118.0928, 33.80433], [-118.09295, 33.80427], [-118.09344, 33.80418], [-118.09389, 33.80408], [-118.09567, 33.80357], [-118.09606, 33.80348], [-118.09649, 33.80341], [-118.09702, 33.80335], [-118.09755, 33.80333], [-118.09892, 33.80333], [-118.09899, 33.80339]]], [[[-118.09903, 33.79594], [-118.09899, 33.803], [-118.09892, 33.80306], [-118.09731, 33.80306], [-118.09688, 33.80308], [-118.09646, 33.80313], [-118.09607, 33.80319], [-118.09561, 33.80329], [-118.09451, 33.80361], [-118.09458, 33.80348], [-118.09473, 33.80327], [-118.09538, 33.80256], [-118.09551, 33.80237], [-118.09561, 33.80217], [-118.09568, 33.80195], [-118.0958, 33.80124], [-118.09587, 33.80097], [-118.09597, 33.80071], [-118.09637, 33.80014], [-118.09656, 33.80001], [-118.09686, 33.79988], [-118.09713, 33.7998], [-118.09743, 33.7998], [-118.0977, 33.79976], [-118.09805, 33.79961], [-118.09829, 33.79943], [-118.09852, 33.7992], [-118.09876, 33.79898], [-118.09888, 33.79874], [-118.09886, 33.7985], [-118.09879, 33.7984], [-118.09869, 33.79802], [-118.09858, 33.79781], [-118.09818, 33.79722], [-118.09762, 33.79721], [-118.09753, 33.79691], [-118.09735, 33.79656], [-118.09718, 33.79627], [-118.09701, 33.79609], [-118.09679, 33.79593], [-118.09903, 33.79594]]]]}	Open Access 1	El Dorado Park West	http://www.longbeach.gov/park/parks_and_open_spaces/parks/el_dorado_park_west.asp	5429	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	116.612	El Dorado Park West
694	694	693	{"type": "Polygon", "coordinates": [[[-118.18058, 33.78624], [-118.18058, 33.78705], [-118.17942, 33.78705], [-118.17942, 33.78668], [-118.1799, 33.78668], [-118.17992, 33.78631], [-118.18015, 33.7863], [-118.18015, 33.7856], [-118.18058, 33.7856], [-118.18058, 33.78624]]]}	Open Access 1	Ernest McBride Park & California Recreation Community Center	http://www.longbeach.gov/park/park-and-facilities/directory/mcbride-park/	30888	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	2.487	Ernest McBride Park & California Rec. Community Ctr.
735	735	734	{"type": "MultiPolygon", "coordinates": [[[[-118.13185, 33.7681], [-118.13155, 33.76841], [-118.13116, 33.76817], [-118.13149, 33.76786], [-118.13185, 33.7681]]], [[[-118.13275, 33.76887], [-118.13275, 33.76923], [-118.1317, 33.76851], [-118.13201, 33.7682], [-118.13242, 33.76845], [-118.13275, 33.76887]]]]}	Open Access 1	Will Rogers Mini Park		27529	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1.644	Will Rogers MP
737	737	736	{"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79555], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]}	Open Access 1	21st to Hill Mini Park	http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470	28944	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	0.91	21st to Hill MP
814	814	813	{"type": "Polygon", "coordinates": [[[-118.1834, 33.76411], [-118.18316, 33.76539], [-118.1831, 33.76539], [-118.18307, 33.76547], [-118.18236, 33.76542], [-118.18237, 33.76532], [-118.18187, 33.76524], [-118.18183, 33.76536], [-118.18164, 33.76534], [-118.18145, 33.76534], [-118.17698, 33.76475], [-118.1768, 33.76474], [-118.17179, 33.76407], [-118.1716, 33.76411], [-118.17089, 33.76396], [-118.16946, 33.76377], [-118.16945, 33.76376], [-118.16902, 33.7637], [-118.16918, 33.76281], [-118.16993, 33.76293], [-118.17053, 33.76303], [-118.17088, 33.76311], [-118.17134, 33.76324], [-118.17264, 33.76338], [-118.17411, 33.76338], [-118.17465, 33.76332], [-118.17525, 33.7633], [-118.17654, 33.76338], [-118.17721, 33.76338], [-118.17812, 33.76333], [-118.17907, 33.7632], [-118.17996, 33.76298], [-118.18051, 33.76266], [-118.181, 33.76231], [-118.18149, 33.76159], [-118.18316, 33.76335], [-118.18317, 33.76386], [-118.1834, 33.76411]]]}	Open Access 1	Alamitos Beach		15314	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	56.55	Alamitos Beach
817	817	816	{"type": "Polygon", "coordinates": [[[-118.1171, 33.74531], [-118.11692, 33.74554], [-118.11665, 33.7454], [-118.11684, 33.74516], [-118.1171, 33.74531]]]}	Open Access 1	Alamitos Park		15315	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	0.225	Alamitos Park
891	891	890	{"type": "Polygon", "coordinates": [[[-118.0907, 33.82486], [-118.09069, 33.82685], [-118.09002, 33.82685], [-118.09001, 33.82754], [-118.08923, 33.8273], [-118.08925, 33.82484], [-118.0907, 33.82486]]]}	No Public Access 3	El Dorado East Regional Park		32766	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	8.527	El Dorado East RP
898	898	897	{"type": "Polygon", "coordinates": [[[-118.19678, 33.8389], [-118.19592, 33.84035], [-118.19458, 33.8398], [-118.1951, 33.83894], [-118.19569, 33.83917], [-118.19612, 33.8388], [-118.19607, 33.83861], [-118.19622, 33.83873], [-118.19634, 33.8388], [-118.19678, 33.8389]]]}	Restricted Access 2	Rancho Los Cerritos Historic Site		32776	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	4.79	Rancho Los Cerritos Historic Site
930	930	929	{"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]}	Restricted Access 2	El Dorado Community Gardens		32803	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	8.254	El Dorado Community Gardens
1386	1386	1385	{"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]]]]}	Open Access 1	14th Street Park and Playground		15173	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	1.66	14th Street Park and Playground
1650	1650	1649	{"type": "Polygon", "coordinates": [[[-118.18416, 33.84964], [-118.18416, 33.84977], [-118.1839, 33.84978], [-118.18368, 33.84995], [-118.18366, 33.85], [-118.18366, 33.85103], [-118.18368, 33.85107], [-118.18389, 33.85124], [-118.18415, 33.85125], [-118.18412, 33.8514], [-118.18406, 33.85154], [-118.18391, 33.85147], [-118.18377, 33.85139], [-118.18366, 33.85128], [-118.18358, 33.85119], [-118.18348, 33.85098], [-118.18344, 33.85061], [-118.18338, 33.85051], [-118.18271, 33.85006], [-118.18216, 33.84996], [-118.1804, 33.85003], [-118.18036, 33.85027], [-118.18017, 33.85029], [-118.18011, 33.85019], [-118.18008, 33.84977], [-118.17983, 33.84976], [-118.17975, 33.84957], [-118.17968, 33.84949], [-118.17974, 33.84942], [-118.17984, 33.84936], [-118.18021, 33.84922], [-118.18033, 33.84962], [-118.18037, 33.84983], [-118.18192, 33.84976], [-118.18192, 33.84935], [-118.18225, 33.84922], [-118.18204, 33.84878], [-118.18212, 33.84873], [-118.18233, 33.84879], [-118.18248, 33.84853], [-118.18292, 33.84865], [-118.18288, 33.84873], [-118.1827, 33.84886], [-118.18252, 33.84907], [-118.18305, 33.84956], [-118.18339, 33.84983], [-118.18349, 33.84986], [-118.18356, 33.84986], [-118.18363, 33.84983], [-118.18379, 33.8497], [-118.18388, 33.84966], [-118.18397, 33.84964], [-118.18416, 33.84964]]]}	Open Access 1	Atlantic Plaza Park		15675	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	6.606	Atlantic Plaza Park
1942	1942	1941	{"type": "Polygon", "coordinates": [[[-118.14525, 33.75697], [-118.14496, 33.75754], [-118.14479, 33.75793], [-118.14365, 33.75749], [-118.14336, 33.75801], [-118.13788, 33.7558], [-118.13804, 33.75551], [-118.13804, 33.75549], [-118.1379, 33.75545], [-118.13773, 33.75574], [-118.13625, 33.75515], [-118.13492, 33.75459], [-118.13352, 33.75392], [-118.13251, 33.75341], [-118.13274, 33.75309], [-118.13268, 33.75304], [-118.1339, 33.75143], [-118.13532, 33.75207], [-118.13542, 33.75215], [-118.13585, 33.75238], [-118.13652, 33.75266], [-118.13693, 33.75286], [-118.13741, 33.75313], [-118.13762, 33.75323], [-118.13934, 33.75415], [-118.14089, 33.75501], [-118.14093, 33.75504], [-118.14132, 33.75525], [-118.14136, 33.75528], [-118.14147, 33.75533], [-118.1415, 33.75538], [-118.14142, 33.75557], [-118.14525, 33.75697]]]}	Open Access 1	Belmont Shore Beach		15995	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	64.109	Belmont Shore Beach
2036	2036	2035	{"type": "Polygon", "coordinates": [[[-118.18037, 33.84032], [-118.18037, 33.84033], [-118.17814, 33.84152], [-118.17816, 33.84104], [-118.17814, 33.8409], [-118.17808, 33.84071], [-118.17988, 33.83974], [-118.18009, 33.84], [-118.18012, 33.84], [-118.18037, 33.84032]]]}	Open Access 1	Bixby Knolls Park		16130	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	4.268	Bixby Knolls Park
2037	2037	2036	{"type": "MultiPolygon", "coordinates": [[[[-118.16786, 33.76675], [-118.16779, 33.76716], [-118.16686, 33.76704], [-118.16596, 33.76685], [-118.16609, 33.76645], [-118.16696, 33.76664], [-118.16786, 33.76675]]], [[[-118.16806, 33.76568], [-118.1679, 33.76655], [-118.16701, 33.76644], [-118.16614, 33.76625], [-118.1664, 33.7654], [-118.16722, 33.76558], [-118.16806, 33.76568]]], [[[-118.16849, 33.76328], [-118.16831, 33.76434], [-118.16756, 33.76424], [-118.16632, 33.76398], [-118.16646, 33.76352], [-118.16629, 33.76346], [-118.16642, 33.76296], [-118.16849, 33.76328]]], [[[-118.16827, 33.76461], [-118.1681, 33.76548], [-118.16727, 33.76538], [-118.16646, 33.7652], [-118.16671, 33.76434], [-118.16748, 33.76452], [-118.16827, 33.76461]]]]}	Open Access 1	Bixby Park		16131	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	15.025	Bixby Park
2092	2092	2091	{"type": "Polygon", "coordinates": [[[-118.16446, 33.76279], [-118.1643, 33.76333], [-118.15256, 33.76088], [-118.15255, 33.76085], [-118.15103, 33.76079], [-118.15064, 33.7607], [-118.15091, 33.75983], [-118.15284, 33.76035], [-118.15644, 33.76123], [-118.1582, 33.76158], [-118.15995, 33.76196], [-118.16348, 33.76263], [-118.16446, 33.76279]]]}	Open Access 1	Bluff Park		16198	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	18.611	Bluff Park
2173	2173	2172	{"type": "MultiPolygon", "coordinates": [[[[-118.12869, 33.78809], [-118.12814, 33.78802], [-118.12762, 33.788], [-118.12762, 33.78783], [-118.12856, 33.78792], [-118.12866, 33.78798], [-118.12869, 33.78809]]], [[[-118.12949, 33.78801], [-118.12946, 33.78827], [-118.12881, 33.78811], [-118.12876, 33.78794], [-118.12949, 33.78801]]]]}	Open Access 1	Bouton Creek Park		16303	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	0.769	Bouton Creek Park
2664	2664	2663	{"type": "MultiPolygon", "coordinates": [[[[-118.1632, 33.76891], [-118.16311, 33.76896], [-118.16311, 33.76887], [-118.16315, 33.76889], [-118.1632, 33.76891]]], [[[-118.16334, 33.77076], [-118.16323, 33.77082], [-118.16314, 33.7709], [-118.16315, 33.77079], [-118.16313, 33.77068], [-118.16334, 33.77076]]], [[[-118.16428, 33.76891], [-118.16414, 33.769], [-118.16403, 33.76911], [-118.16392, 33.769], [-118.16378, 33.76891], [-118.16392, 33.76882], [-118.16403, 33.76871], [-118.16414, 33.76882], [-118.16428, 33.76891]]], [[[-118.16441, 33.77044], [-118.16441, 33.77044], [-118.16398, 33.77055], [-118.16404, 33.77047], [-118.16408, 33.77039], [-118.1641, 33.7703], [-118.1641, 33.7702], [-118.16423, 33.77032], [-118.16441, 33.77044]]]]}	Open Access 1	Carroll Parks		16919	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	0.426	Carroll Parks
2812	2812	2811	{"type": "MultiPolygon", "coordinates": [[[[-118.20289, 33.77061], [-118.2028, 33.77063], [-118.2028, 33.77101], [-118.20239, 33.771], [-118.20239, 33.77061], [-118.20257, 33.7706], [-118.20258, 33.77058], [-118.20251, 33.77054], [-118.20225, 33.7705], [-118.20193, 33.7705], [-118.20193, 33.77027], [-118.2019, 33.77026], [-118.20191, 33.77014], [-118.20189, 33.7701], [-118.20183, 33.77008], [-118.20183, 33.76935], [-118.20193, 33.76935], [-118.20195, 33.7694], [-118.20233, 33.7694], [-118.20235, 33.76937], [-118.20278, 33.76942], [-118.20289, 33.77061]], [[-118.20226, 33.76983], [-118.20226, 33.76981], [-118.20194, 33.7698], [-118.20193, 33.76981], [-118.20226, 33.76983]]], [[[-118.20234, 33.77103], [-118.20234, 33.77152], [-118.20192, 33.77152], [-118.20193, 33.77103], [-118.20234, 33.77103]]], [[[-118.2028, 33.7728], [-118.20193, 33.77281], [-118.20192, 33.77254], [-118.20213, 33.77253], [-118.20246, 33.77258], [-118.20265, 33.77258], [-118.20279, 33.77256], [-118.2028, 33.7728]]], [[[-118.20234, 33.771], [-118.20193, 33.77101], [-118.20193, 33.7706], [-118.20226, 33.7706], [-118.20234, 33.77061], [-118.20234, 33.771]]], [[[-118.20234, 33.77347], [-118.20234, 33.77401], [-118.20193, 33.77402], [-118.20193, 33.77303], [-118.20234, 33.77303], [-118.20234, 33.77347]]], [[[-118.20306, 33.77226], [-118.20298, 33.77231], [-118.20278, 33.77239], [-118.20264, 33.77241], [-118.20245, 33.77241], [-118.2021, 33.77236], [-118.20193, 33.77238], [-118.20193, 33.77181], [-118.20222, 33.77181], [-118.20249, 33.77186], [-118.20259, 33.77186], [-118.20279, 33.7718], [-118.20305, 33.77165], [-118.20306, 33.77226]]], [[[-118.20234, 33.77166], [-118.20202, 33.77164], [-118.20196, 33.77163], [-118.20193, 33.77159], [-118.20234, 33.77159], [-118.20234, 33.77166]]], [[[-118.20281, 33.77399], [-118.20277, 33.77402], [-118.20239, 33.77401], [-118.20239, 33.7739], [-118.20238, 33.77303], [-118.20279, 33.77303], [-118.20281, 33.77399]]], [[[-118.2028, 33.77103], [-118.20278, 33.77158], [-118.20256, 33.77168], [-118.20239, 33.77167], [-118.20239, 33.77103], [-118.2028, 33.77103]]]]}	Open Access 1	Cesar E. Chavez Park		17104	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	9.084	Cesar E. Chavez Park
2832	2832	2831	{"type": "Polygon", "coordinates": [[[-118.10504, 33.76752], [-118.10503, 33.76755], [-118.10488, 33.7677], [-118.10487, 33.76774], [-118.10488, 33.76781], [-118.10496, 33.76788], [-118.10478, 33.76807], [-118.10463, 33.76829], [-118.10453, 33.76851], [-118.10446, 33.76881], [-118.10442, 33.76956], [-118.1044, 33.77171], [-118.10433, 33.77169], [-118.10426, 33.7717], [-118.1042, 33.77174], [-118.10418, 33.7718], [-118.1042, 33.77187], [-118.10426, 33.77192], [-118.10435, 33.77192], [-118.10441, 33.77189], [-118.1044, 33.77411], [-118.10409, 33.77412], [-118.10408, 33.77402], [-118.10409, 33.76939], [-118.10411, 33.76887], [-118.10418, 33.76857], [-118.1043, 33.76826], [-118.10441, 33.76807], [-118.10453, 33.7679], [-118.10471, 33.76769], [-118.10488, 33.76753], [-118.10488, 33.76751], [-118.10482, 33.76748], [-118.10486, 33.76746], [-118.105, 33.76749], [-118.10504, 33.76752]]]}	Open Access 1	Channel View Park		17123	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	5.302	Channel View Park	1968
2870	2870	2869	{"type": "Polygon", "coordinates": [[[-118.17036, 33.83866], [-118.16951, 33.84005], [-118.16951, 33.84054], [-118.16776, 33.84055], [-118.16775, 33.8387], [-118.16781, 33.83865], [-118.17036, 33.83866]]]}	Open Access 1	Cherry Avenue Park		17164	1184	Long Beach, City of 294	City 2	City Agency 2	http://www.longbeach.gov/park/default.asp	City 2	9.932	Cherry Avenue Park

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);