units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
99 rows where AGNCY_NAME = 298 and DES_TP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
963 | 963 | 962 | {"type": "Polygon", "coordinates": [[[-118.13204, 33.83966], [-118.13203, 33.84296], [-118.1306, 33.84295], [-118.13062, 33.83966], [-118.13204, 33.83966]]]} | Open Access 1 | 6576 | Pan American Park | 23383 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 11.97 | Pan American Park | 0 | Local Park 2 | 4 | |
965 | 965 | 964 | {"type": "Polygon", "coordinates": [[[-118.17515, 33.78271], [-118.17514, 33.78433], [-118.17425, 33.78433], [-118.17426, 33.78271], [-118.17515, 33.78271]]]} | Open Access 1 | 6588 | Douglas MacArthur Park | 18245 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.648 | Douglas MacArthur Park | 0 | Local Park 2 | 4 | |
967 | 967 | 966 | {"type": "Polygon", "coordinates": [[[-118.18557, 33.87069], [-118.18217, 33.87067], [-118.18215, 33.86744], [-118.1851, 33.86743], [-118.18557, 33.87069]]]} | Open Access 1 | 6603 | Houghton Park | 20109 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 26.14 | Houghton Park | 0 | Local Park 2 | 4 | |
969 | 969 | 968 | {"type": "MultiPolygon", "coordinates": [[[[-118.19734, 33.76719], [-118.19543, 33.76709], [-118.19542, 33.76707], [-118.19499, 33.76705], [-118.19499, 33.76694], [-118.19543, 33.76696], [-118.1963, 33.76696], [-118.19734, 33.76699], [-118.19734, 33.76719]]], [[[-118.19792, 33.767], [-118.19792, 33.76721], [-118.19746, 33.7672], [-118.19745, 33.76699], [-118.19792, 33.767]]], [[[-118.19929, 33.76702], [-118.19929, 33.76707], [-118.19921, 33.76714], [-118.19825, 33.76714], [-118.19821, 33.7671], [-118.1982, 33.76721], [-118.19814, 33.76721], [-118.19814, 33.76703], [-118.19929, 33.76702]]], [[[-118.20049, 33.76703], [-118.20049, 33.76709], [-118.20043, 33.76714], [-118.19954, 33.76714], [-118.19949, 33.76707], [-118.19949, 33.76702], [-118.20049, 33.76703]]], [[[-118.20174, 33.76703], [-118.20174, 33.76709], [-118.20167, 33.76714], [-118.20076, 33.76714], [-118.2007, 33.76709], [-118.2007, 33.76703], [-118.20174, 33.76703]]]]} | Open Access 1 | 6608 | Santa Cruz Park | 25082 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.096 | Santa Cruz Park | 0 | Local Park 2 | 4 | |
970 | 970 | 969 | {"type": "Polygon", "coordinates": [[[-118.19511, 33.76865], [-118.19493, 33.76865], [-118.19494, 33.76918], [-118.19389, 33.76918], [-118.19389, 33.76817], [-118.1949, 33.76817], [-118.19491, 33.76828], [-118.19494, 33.76834], [-118.19502, 33.76837], [-118.19511, 33.76837], [-118.19511, 33.76865]]]} | Open Access 1 | 6609 | Lincoln Park | 21264 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.816 | Lincoln Park | 0 | Local Park 2 | 4 | |
972 | 972 | 971 | {"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.84001], [-118.18012, 33.84], [-118.18037, 33.84032]]]} | Open Access 1 | 6613 | Bixby Knolls Park | 16130 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 4.268 | Bixby Knolls Park | 0 | Local Park 2 | 4 | |
973 | 973 | 972 | {"type": "Polygon", "coordinates": [[[-118.15882, 33.78532], [-118.15882, 33.78581], [-118.15806, 33.78532], [-118.15684, 33.78532], [-118.15684, 33.78449], [-118.15846, 33.78449], [-118.15846, 33.78475], [-118.15833, 33.78476], [-118.15833, 33.78497], [-118.15846, 33.78497], [-118.15846, 33.7853], [-118.15849, 33.78532], [-118.15882, 33.78532]]]} | Open Access 1 | 6614 | Orizaba Park | 23204 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.776 | Orizaba Park | 0 | Local Park 2 | 4 | |
977 | 977 | 976 | {"type": "Polygon", "coordinates": [[[-118.1256, 33.75282], [-118.12556, 33.75298], [-118.12512, 33.75279], [-118.1256, 33.75282], [-118.1256, 33.75282]]]} | Open Access 1 | 6656 | Treasure Island Park | 26519 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.102 | Treasure Island Park | 0 | Local Park 2 | 4 | |
981 | 981 | 980 | {"type": "Polygon", "coordinates": [[[-118.15763, 33.85724], [-118.15761, 33.85725], [-118.15761, 33.85746], [-118.15552, 33.85747], [-118.15552, 33.85685], [-118.1555, 33.85684], [-118.15551, 33.85637], [-118.15762, 33.85637], [-118.15763, 33.85724]]]} | Open Access 1 | 6678 | Davenport Park | 28713 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 5.858 | Davenport Park | 0 | Local Park 2 | 4 | |
982 | 982 | 981 | {"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 | 6681 | Alamitos Park | 15315 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.225 | Alamitos Park | 0 | Local Park 2 | 4 | |
1120 | 1120 | 1119 | {"type": "MultiPolygon", "coordinates": [[[[-118.13088, 33.75291], [-118.13072, 33.75313], [-118.12914, 33.75219], [-118.12927, 33.75199], [-118.13088, 33.75291]]], [[[-118.13211, 33.75514], [-118.13039, 33.75789], [-118.13018, 33.75781], [-118.1303, 33.75771], [-118.13125, 33.75618], [-118.13149, 33.75596], [-118.13175, 33.7552], [-118.13179, 33.75507], [-118.1318, 33.7548], [-118.13162, 33.75434], [-118.13155, 33.75402], [-118.13074, 33.7533], [-118.13079, 33.75324], [-118.13095, 33.75332], [-118.13107, 33.7532], [-118.13126, 33.75329], [-118.13114, 33.75345], [-118.13128, 33.75352], [-118.13152, 33.75325], [-118.13174, 33.75337], [-118.1315, 33.75376], [-118.13193, 33.75398], [-118.13176, 33.75425], [-118.13211, 33.75514]]]]} | Open Access 1 | 6585 | Bayshore Beach | 29929 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 4.159 | Bayshore Beach | 0 | Local Park 2 | 4 | |
1124 | 1124 | 1123 | {"type": "Polygon", "coordinates": [[[-118.17408, 33.83155], [-118.17408, 33.83229], [-118.1721, 33.83229], [-118.1721, 33.83155], [-118.17408, 33.83155]]]} | Open Access 1 | 6590 | Somerset Park | 25602 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 3.726 | Somerset Park | 0 | Local Park 2 | 4 | |
1125 | 1125 | 1124 | {"type": "Polygon", "coordinates": [[[-118.19523, 33.85437], [-118.19505, 33.85468], [-118.19468, 33.85468], [-118.19486, 33.85437], [-118.19523, 33.85437]]]} | Open Access 1 | 6599 | Burton W. Chace Park | 28711 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Burton W. Chace Park | 0 | Local Park 2 | 4 | |
1127 | 1127 | 1126 | {"type": "Polygon", "coordinates": [[[-118.15552, 33.87377], [-118.15359, 33.87378], [-118.15358, 33.87208], [-118.15446, 33.87208], [-118.15457, 33.87214], [-118.15466, 33.87229], [-118.15471, 33.87236], [-118.15487, 33.87246], [-118.15506, 33.8725], [-118.15552, 33.8725], [-118.15552, 33.87377]]]} | Open Access 1 | 6602 | Ramona Park | 24119 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 7.46 | Ramona Park | 0 | Local Park 2 | 4 | |
1134 | 1134 | 1133 | {"type": "Polygon", "coordinates": [[[-118.22322, 33.79713], [-118.2227, 33.79832], [-118.22143, 33.79833], [-118.22142, 33.79884], [-118.21988, 33.79884], [-118.21988, 33.7972], [-118.22031, 33.7972], [-118.22032, 33.79714], [-118.22322, 33.79713]]]} | Open Access 1 | 6632 | Hudson Park | 20134 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 11.236 | Hudson Park | 0 | Local Park 2 | 4 | |
1135 | 1135 | 1134 | {"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.16349, 33.76263], [-118.16446, 33.76279]]]} | Open Access 1 | 6644 | Bluff Park | 16198 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 18.611 | Bluff Park | 0 | Local Park 2 | 4 | |
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 45873 | 21st to Hill Mini Park | 28944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | Los Angeles 6 | 0.91 | 21st to Hill MP | 0 | Local Park 2 | 4 |
2714 | 2714 | 2713 | {"type": "MultiPolygon", "coordinates": [[[[-118.21183, 33.82355], [-118.21117, 33.82355], [-118.21118, 33.82341], [-118.21183, 33.82341], [-118.21183, 33.82355]]], [[[-118.21441, 33.82237], [-118.21313, 33.8242], [-118.21309, 33.82422], [-118.21282, 33.82418], [-118.21282, 33.82385], [-118.21441, 33.82237]]]]} | Open Access 1 | 6689 | Tanaka Park | 26179 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.624 | Tanaka Park | 0 | Local Park 2 | 4 | |
2951 | 2951 | 2950 | {"type": "Polygon", "coordinates": [[[-118.16535, 33.78974], [-118.16492, 33.78974], [-118.16342, 33.78877], [-118.16342, 33.78849], [-118.16535, 33.78974]]]} | Open Access 1 | 20230 | Rotary Centennial Park | 24683 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.209 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
3647 | 3647 | 3646 | {"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.1839, 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.18039, 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.18193, 33.84976], [-118.18192, 33.84935], [-118.18226, 33.84923], [-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.18271, 33.84886], [-118.18251, 33.84906], [-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 | 29559 | Atlantic Plaza Park | 15675 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 6.585 | Atlantic Plaza 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]);