superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 180 sorted by map 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
3309 | 3309 | 3308 | {"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 | Crescent Bay Park | 17791 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.049 | Crescent Bay Park | ||
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 | ||
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 | ||
1765 | 1765 | 1764 | {"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.00156], [-118.48696, 34.00176], [-118.48754, 34.00237], [-118.48748, 34.00241], [-118.4875, 34.00246], [-118.48748, 34.00251], [-118.48789, 34.00292]]]} | Open Access 1 | Barnard Way Linear Park | 15820 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.747 | Barnard Way Linear 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 | ||
5261 | 5261 | 5260 | {"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 | Hotchkiss Park | 20105 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.08 | Hotchkiss 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 | ||
4089 | 4089 | 4088 | {"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 | Euclid Park | 18745 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.32 | Euclid Park | ||
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 | ||
5318 | 5318 | 5317 | {"type": "Polygon", "coordinates": [[[-118.48239, 34.00642], [-118.48168, 34.00691], [-118.48093, 34.00617], [-118.48112, 34.00606], [-118.48105, 34.00596], [-118.48158, 34.00562], [-118.48239, 34.00642]]]} | Open Access 1 | Los Amigos Park | 21476 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.419 | Los Amigos Park | ||
5621 | 5621 | 5620 | {"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 | Joslyn Park | 20508 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.298 | Joslyn 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 | ||
3685 | 3685 | 3684 | {"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 | Douglas Park | 18246 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 4.181 | Douglas 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 | ||
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 |
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]);