superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 180 sorted by SUID_NMA 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13923 | 13923 | 13922 | {"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 | Ishihara Park | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | 32517 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.359 | Ishihara Park | 2017 |
12718 | 12718 | 12717 | {"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.47677, 34.04439], [-118.47647, 34.04414], [-118.47682, 34.04385], [-118.4771, 34.04408], [-118.47729, 34.0442]]]]} | No Public Access 3 | Mount Olivet Reservoir | 29887 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.988 | Mount Olivet Reservoir | ||
12717 | 12717 | 12716 | {"type": "Polygon", "coordinates": [[[-118.48412, 33.99756], [-118.48341, 33.99804], [-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.48266, 33.99704], [-118.48336, 33.99775], [-118.48348, 33.99773], [-118.48387, 33.99748], [-118.48402, 33.99749], [-118.48412, 33.99756]]]} | Open Access 1 | South Beach Park | 29877 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 1.929 | South Beach Park | ||
12716 | 12716 | 12715 | {"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.4863, 34.0], [-118.48639, 34.00011], [-118.48637, 34.00014], [-118.48646, 34.00024], [-118.48644, 34.00028], [-118.48653, 34.00037], [-118.4864, 34.00048], [-118.4864, 34.00049], [-118.48649, 34.00058], [-118.48666, 34.00053], [-118.48676, 34.00061], [-118.48681, 34.00062], [-118.48689, 34.00069], [-118.48693, 34.00069], [-118.48747, 34.00126]]]} | Open Access 1 | Beach Park 1 | 29876 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 3.777 | Beach Park 1 | ||
12715 | 12715 | 12714 | {"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 | Beach Green Park | 29875 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.64 | Beach Green Park | ||
12714 | 12714 | 12713 | {"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 | Chess Park | 29873 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.191 | Chess Park | ||
12713 | 12713 | 12712 | {"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 | Ken Genser Square | 29872 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.733 | Ken Genser Square | ||
11642 | 11642 | 11641 | {"type": "Polygon", "coordinates": [[[-118.49445, 34.01125], [-118.49443, 34.01131], [-118.49405, 34.01142], [-118.4937, 34.01157], [-118.49296, 34.01203], [-118.49172, 34.01097], [-118.49255, 34.01029], [-118.49304, 34.01073], [-118.49346, 34.0104], [-118.49445, 34.01125]]]} | Open Access 1 | Tongva Park | http://www.smgov.net/Departments/CCS/content.aspx?id=32599 | 28201 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 6.164 | Tongva Park | |
11397 | 11397 | 11396 | {"type": "Polygon", "coordinates": [[[-118.47891, 34.01843], [-118.47761, 34.01948], [-118.47633, 34.0184], [-118.47499, 34.01949], [-118.47298, 34.01777], [-118.47616, 34.01607], [-118.47891, 34.01843]]]} | Open Access 1 | Woodlawn Cemetery | 27728 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 26.509 | Woodlawn Cemetery | ||
10934 | 10934 | 10933 | {"type": "Polygon", "coordinates": [[[-118.46924, 34.02156], [-118.46803, 34.02254], [-118.46748, 34.02207], [-118.4677, 34.02187], [-118.46742, 34.02163], [-118.46669, 34.0222], [-118.46596, 34.02158], [-118.46597, 34.02148], [-118.46834, 34.02021], [-118.46879, 34.02059], [-118.46857, 34.02078], [-118.46867, 34.02089], [-118.46857, 34.02099], [-118.46924, 34.02156]]]} | Open Access 1 | Virginia Avenue Park | 27155 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 9.371 | Virginia Avenue Park | ||
9969 | 9969 | 9968 | {"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 | Stewart Street Park | 25849 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 3.94 | Stewart Street Park | ||
9399 | 9399 | 9398 | {"type": "Polygon", "coordinates": [[[-118.47609, 34.03049], [-118.47597, 34.03058], [-118.47565, 34.03031], [-118.47574, 34.03022], [-118.47542, 34.02995], [-118.47544, 34.02993], [-118.47609, 34.03049]]]} | Open Access 1 | Schrader Park | 25193 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.192 | Schrader Park | ||
8609 | 8609 | 8608 | {"type": "Polygon", "coordinates": [[[-118.49687, 34.02277], [-118.49611, 34.02338], [-118.49473, 34.0222], [-118.49549, 34.02159], [-118.49687, 34.02277]]]} | Open Access 1 | Reed Park | 24256 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 4.404 | Reed Park | ||
7928 | 7928 | 7927 | {"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 | Park Drive Park | 23428 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.343 | Park Drive Park | ||
7868 | 7868 | 7867 | {"type": "Polygon", "coordinates": [[[-118.51554, 34.02623], [-118.51524, 34.02694], [-118.51349, 34.02593], [-118.51343, 34.02598], [-118.50911, 34.02349], [-118.50707, 34.02177], [-118.50709, 34.02166], [-118.49823, 34.01407], [-118.49516, 34.01147], [-118.49507, 34.01136], [-118.4953, 34.01117], [-118.49682, 34.01245], [-118.49851, 34.01396], [-118.50012, 34.01525], [-118.50093, 34.01608], [-118.5022, 34.01714], [-118.50307, 34.01784], [-118.50311, 34.0181], [-118.50326, 34.01815], [-118.50549, 34.01979], [-118.50656, 34.02039], [-118.50676, 34.02042], [-118.50747, 34.02098], [-118.50746, 34.02101], [-118.50831, 34.02168], [-118.50835, 34.02167], [-118.51046, 34.02332], [-118.51101, 34.02372], [-118.51159, 34.0241], [-118.51218, 34.02447], [-118.51279, 34.02481], [-118.51554, 34.02623]]]} | Open Access 1 | Palisades Park | 23333 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 32.643 | Palisades Park | ||
6657 | 6657 | 6656 | {"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 | Pacific Street Park | 23306 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.414 | Pacific Street Park | ||
7832 | 7832 | 7831 | {"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 | Ozone Park | 23286 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.714 | Ozone Park | ||
7628 | 7628 | 7627 | {"type": "Polygon", "coordinates": [[[-118.48487, 34.00002], [-118.48432, 34.00041], [-118.48432, 34.00043], [-118.48362, 34.00092], [-118.48361, 34.00091], [-118.48426, 34.00042], [-118.48256, 33.99873], [-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.48243, 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 | Ocean View Park | 23062 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 5.831 | Ocean View Park | ||
6923 | 6923 | 6922 | {"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 | Memorial Park | 22134 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 10.304 | Memorial Park | ||
6669 | 6669 | 6668 | {"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 | Marine Park | 21847 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 6.853 | Marine 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]);