units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 180 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3970 | 3970 | 3969 | {"type": "Polygon", "coordinates": [[[-118.44788, 34.01608], [-118.44784, 34.01622], [-118.44658, 34.01731], [-118.44615, 34.01671], [-118.4444, 34.01766], [-118.44401, 34.01714], [-118.44734, 34.01539], [-118.44788, 34.01608]]]} | Open Access 1 | 20672 | Airport Park | 15304 | 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 | 8.341 | Airport 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 | |
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 | |
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 | |
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 | |||
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 | |
3969 | 3969 | 3968 | {"type": "Polygon", "coordinates": [[[-118.45832, 34.01723], [-118.4583, 34.01727], [-118.45684, 34.01811], [-118.45488, 34.01577], [-118.45484, 34.01579], [-118.45475, 34.0156], [-118.45409, 34.01503], [-118.45554, 34.0138], [-118.45587, 34.01428], [-118.4563, 34.01483], [-118.45632, 34.01484], [-118.45832, 34.01723]]]} | Open Access 1 | 20671 | Clover Park | 17437 | 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 | 18.672 | Clover 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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 | |
678 | 678 | 677 | {"type": "Polygon", "coordinates": [[[-118.46693, 34.00551], [-118.46499, 34.00664], [-118.46418, 34.00567], [-118.46618, 34.00461], [-118.46693, 34.00551]]]} | Open Access 1 | 5125 | Marine Park | 21847 | 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 | 6.853 | Marine Park | 0 | Local Park 2 | 4 | |
886 | 886 | 885 | {"type": "Polygon", "coordinates": [[[-118.48199, 34.02107], [-118.48103, 34.02182], [-118.48014, 34.02248], [-118.47881, 34.02134], [-118.48061, 34.01989], [-118.48199, 34.02107]]]} | Open Access 1 | 5717 | Memorial Park | 22134 | 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 | 10.305 | Memorial 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 | |
644 | 644 | 643 | {"type": "Polygon", "coordinates": [[[-118.48487, 34.00002], [-118.48431, 34.00041], [-118.48432, 34.00043], [-118.48362, 34.00092], [-118.48361, 34.00091], [-118.48427, 34.00043], [-118.48255, 33.99872], [-118.48188, 33.99919], [-118.48168, 33.99899], [-118.48193, 33.99882], [-118.48199, 33.99882], [-118.48202, 33.9988], [-118.48202, 33.99875], [-118.48244, 33.99846], [-118.4818, 33.99782], [-118.48189, 33.99776], [-118.4827, 33.99855], [-118.4832, 33.99821], [-118.48338, 33.99844], [-118.48487, 34.00002]]]} | Open Access 1 | 2850 | Ocean View Park | 23062 | 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 | 5.802 | Ocean View 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 |
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]);