units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 180 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10828 | 10828 | 10827 | {"type": "Polygon", "coordinates": [[[-118.47609, 34.03049], [-118.47597, 34.03058], [-118.47565, 34.03031], [-118.47575, 34.03022], [-118.47542, 34.02995], [-118.47544, 34.02993], [-118.47609, 34.03049]]]} | Open Access 1 | 20668 | Schrader Park | 25193 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.19 | Schrader Park | 0 | Local Park 2 | 4 | |
4829 | 4829 | 4828 | {"type": "Polygon", "coordinates": [[[-118.49504, 34.00947], [-118.49495, 34.00953], [-118.49455, 34.00915], [-118.49465, 34.00908], [-118.4947, 34.0091], [-118.49498, 34.00936], [-118.49504, 34.00947]]]} | Open Access 1 | 46569 | Chess Park | 29873 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.191 | Chess Park | 0 | Local Park 2 | 4 | |
5218 | 5218 | 5217 | {"type": "Polygon", "coordinates": [[[-118.48466, 34.02177], [-118.48429, 34.02207], [-118.48409, 34.0219], [-118.48445, 34.02159], [-118.48466, 34.02177]]]} | Open Access 1 | 20669 | Euclid Park | 18745 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.321 | Euclid Park | 0 | Local Park 2 | 4 | |
10815 | 10815 | 10814 | {"type": "Polygon", "coordinates": [[[-118.47532, 34.03118], [-118.47521, 34.03127], [-118.47452, 34.03068], [-118.47463, 34.03059], [-118.47532, 34.03118]]]} | Open Access 1 | 20667 | Park Drive Park | 23428 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.344 | Park Drive Park | 0 | Local Park 2 | 4 | |
3989 | 3989 | 3988 | {"type": "Polygon", "coordinates": [[[-118.46534, 34.00959], [-118.46482, 34.00989], [-118.46458, 34.00965], [-118.46523, 34.00949], [-118.46534, 34.00959]]]} | Open Access 1 | 20673 | Ashland Park | 15653 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.364 | Ashland Park | 0 | Local Park 2 | 4 | |
4011 | 4011 | 4010 | {"type": "Polygon", "coordinates": [[[-118.48814, 34.00558], [-118.48776, 34.00585], [-118.4875, 34.0056], [-118.48788, 34.00533], [-118.48814, 34.00558]]]} | Open Access 1 | 20674 | Pacific Street Park | 23306 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.414 | Pacific Street Park | 0 | Local Park 2 | 4 | |
5717 | 5717 | 5716 | {"type": "Polygon", "coordinates": [[[-118.48814, 34.00196], [-118.48792, 34.00211], [-118.48726, 34.0014], [-118.48747, 34.00126], [-118.48814, 34.00196]]]} | Open Access 1 | 46572 | Beach Green Park | 29875 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.64 | Beach Green Park | 0 | Local Park 2 | 4 | |
1338 | 1338 | 1337 | {"type": "Polygon", "coordinates": [[[-118.4728, 34.00128], [-118.47142, 34.00207], [-118.47128, 34.00191], [-118.47271, 34.00116], [-118.4728, 34.00128]]]} | Open Access 1 | 7397 | Ozone Park | 23286 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.715 | Ozone Park | 0 | Local Park 2 | 4 | |
15361 | 15361 | 15360 | {"type": "Polygon", "coordinates": [[[-118.4923, 34.01178], [-118.49207, 34.01197], [-118.49131, 34.01131], [-118.49152, 34.01112], [-118.4923, 34.01178]]]} | Open Access 1 | 46568 | Ken Genser Square | 29872 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 0.733 | Ken Genser Square | 0 | Local Park 2 | 4 | |
5719 | 5719 | 5718 | {"type": "Polygon", "coordinates": [[[-118.48412, 33.99756], [-118.4834, 33.99805], [-118.48337, 33.99812], [-118.48332, 33.99811], [-118.48328, 33.99809], [-118.48292, 33.99767], [-118.48257, 33.99731], [-118.4825, 33.99717], [-118.48233, 33.99697], [-118.48232, 33.9969], [-118.48229, 33.99684], [-118.48218, 33.99678], [-118.48205, 33.99672], [-118.4818, 33.99666], [-118.48179, 33.99661], [-118.48206, 33.99641], [-118.48212, 33.99647], [-118.48242, 33.99654], [-118.48248, 33.99657], [-118.48259, 33.99669], [-118.48265, 33.99679], [-118.48267, 33.99687], [-118.48265, 33.99704], [-118.48336, 33.99775], [-118.48347, 33.99773], [-118.48387, 33.99748], [-118.48402, 33.99749], [-118.48412, 33.99756]]]} | Open Access 1 | 46574 | South Beach Park | 29877 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 1.927 | South Beach Park | 0 | Local Park 2 | 4 | |
2696 | 2696 | 2695 | {"type": "Polygon", "coordinates": [[[-118.49096, 34.00562], [-118.49044, 34.00597], [-118.49013, 34.0062], [-118.49006, 34.00619], [-118.48993, 34.0057], [-118.48986, 34.00537], [-118.48974, 34.00526], [-118.49025, 34.0049], [-118.49096, 34.00562]]]} | Open Access 1 | 18262 | Crescent Bay Park | 17791 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.05 | Crescent Bay Park | 0 | Local Park 2 | 4 | |
492 | 492 | 491 | {"type": "Polygon", "coordinates": [[[-118.48488, 34.0059], [-118.48412, 34.00642], [-118.48348, 34.00578], [-118.48423, 34.00526], [-118.48488, 34.0059]]]} | Open Access 1 | 1976 | Hotchkiss Park | 20105 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.08 | Hotchkiss Park | 0 | Local Park 2 | 4 | |
5274 | 5274 | 5273 | {"type": "Polygon", "coordinates": [[[-118.48223, 34.00832], [-118.48111, 34.00898], [-118.48056, 34.00851], [-118.48172, 34.00782], [-118.48223, 34.00832]]]} | Open Access 1 | 2576 | Joslyn Park | 20508 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.299 | Joslyn Park | 0 | Local Park 2 | 4 | |
11232 | 11232 | 11231 | {"type": "Polygon", "coordinates": [[[-118.46481, 34.02853], [-118.4639, 34.02872], [-118.46352, 34.02864], [-118.46131, 34.02909], [-118.46102, 34.02931], [-118.46054, 34.02941], [-118.46045, 34.02911], [-118.46466, 34.02825], [-118.46471, 34.02825], [-118.46473, 34.02828], [-118.46481, 34.02853]]]} | Open Access 1 | 48030 | Ishihara Park | 32517 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | Los Angeles 6 | 2.358 | Ishihara Park | 2017 | Local Park 2 | 4 |
6660 | 6660 | 6659 | {"type": "Polygon", "coordinates": [[[-118.48239, 34.00642], [-118.48168, 34.00691], [-118.48093, 34.00617], [-118.48112, 34.00605], [-118.48105, 34.00596], [-118.48158, 34.00562], [-118.48239, 34.00642]]]} | Open Access 1 | 4709 | Los Amigos Park | 21476 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.418 | Los Amigos Park | 0 | Local Park 2 | 4 | |
4012 | 4012 | 4011 | {"type": "Polygon", "coordinates": [[[-118.48789, 34.00292], [-118.48772, 34.00305], [-118.48765, 34.00305], [-118.48759, 34.00303], [-118.48743, 34.00263], [-118.48732, 34.00241], [-118.48573, 34.00074], [-118.48564, 34.00056], [-118.48456, 33.99943], [-118.48443, 33.99935], [-118.48412, 33.99903], [-118.48337, 33.99821], [-118.48336, 33.99817], [-118.48347, 33.99814], [-118.48499, 33.99976], [-118.48551, 34.00018], [-118.48683, 34.00157], [-118.48696, 34.00176], [-118.48754, 34.00237], [-118.48748, 34.00241], [-118.4875, 34.00246], [-118.48748, 34.0025], [-118.48789, 34.00292]]]} | Open Access 1 | 20675 | Barnard Way Linear Park | 15820 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.746 | Barnard Way Linear Park | 0 | Local Park 2 | 4 | |
12573 | 12573 | 12572 | {"type": "MultiPolygon", "coordinates": [[[[-118.47679, 34.04462], [-118.47644, 34.045], [-118.47629, 34.04491], [-118.47509, 34.04389], [-118.4755, 34.04355], [-118.47659, 34.04447], [-118.47679, 34.04462]]], [[[-118.47729, 34.0442], [-118.47702, 34.04455], [-118.47678, 34.04439], [-118.47647, 34.04414], [-118.47682, 34.04385], [-118.4771, 34.04408], [-118.47729, 34.0442]]]]} | No Public Access 3 | 29309 | Mount Olivet Reservoir | 29887 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 2.989 | Mount Olivet Reservoir | 0 | Local Recreation Area 3 | 4 | |
5718 | 5718 | 5717 | {"type": "Polygon", "coordinates": [[[-118.48747, 34.00126], [-118.48694, 34.00159], [-118.48684, 34.00159], [-118.48551, 34.00018], [-118.48543, 34.0], [-118.48609, 33.99954], [-118.48629, 33.99975], [-118.48623, 33.9998], [-118.48636, 33.99995], [-118.48629, 34.0], [-118.48639, 34.00011], [-118.48636, 34.00014], [-118.48646, 34.00024], [-118.48643, 34.00028], [-118.48653, 34.00037], [-118.4864, 34.00048], [-118.4864, 34.00049], [-118.48649, 34.00059], [-118.48666, 34.00053], [-118.48676, 34.00061], [-118.48681, 34.00062], [-118.48689, 34.0007], [-118.48693, 34.00069], [-118.48747, 34.00126]]]} | Open Access 1 | 46573 | Beach Park 1 | 29876 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 3.774 | Beach Park 1 | None 460 | |||
11356 | 11356 | 11355 | {"type": "Polygon", "coordinates": [[[-118.46638, 34.02705], [-118.46616, 34.02727], [-118.46622, 34.02748], [-118.4648, 34.02781], [-118.46472, 34.02771], [-118.46448, 34.02748], [-118.46478, 34.02703], [-118.46562, 34.02633], [-118.46638, 34.02705]]]} | Open Access 1 | 22159 | Stewart Street Park | 25849 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 3.939 | Stewart Street Park | 0 | Local Park 2 | 4 | |
10545 | 10545 | 10544 | {"type": "Polygon", "coordinates": [[[-118.48061, 34.03614], [-118.47995, 34.03667], [-118.47845, 34.03539], [-118.47912, 34.03486], [-118.48061, 34.03614]]]} | Open Access 1 | 18759 | Douglas Park | 18246 | 1323 | Santa Monica, City of 184 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | Los Angeles 6 | 4.182 | Douglas 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]);