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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
15162 | 15162 | 15161 | {"type": "MultiPolygon", "coordinates": [[[[-118.51739, 34.02521], [-118.51653, 34.02589], [-118.5144, 34.02481], [-118.51406, 34.02525], [-118.5134, 34.02491], [-118.51238, 34.02435], [-118.51199, 34.02412], [-118.51236, 34.02369], [-118.51161, 34.0232], [-118.5112, 34.0236], [-118.51097, 34.02344], [-118.51137, 34.02303], [-118.50905, 34.02123], [-118.50859, 34.02159], [-118.50852, 34.02154], [-118.50852, 34.0215], [-118.50769, 34.02085], [-118.50808, 34.02048], [-118.50678, 34.01947], [-118.50634, 34.01983], [-118.50632, 34.01982], [-118.50673, 34.01945], [-118.5066, 34.01934], [-118.50617, 34.0197], [-118.50581, 34.01942], [-118.50621, 34.01905], [-118.50588, 34.01877], [-118.50545, 34.01913], [-118.50524, 34.01897], [-118.50565, 34.0186], [-118.50524, 34.01826], [-118.5048, 34.01862], [-118.50458, 34.01846], [-118.505, 34.01808], [-118.50474, 34.01785], [-118.5043, 34.01822], [-118.50403, 34.01802], [-118.50447, 34.01766], [-118.50436, 34.01755], [-118.50388, 34.01791], [-118.50193, 34.01637], [-118.50222, 34.01612], [-118.50373, 34.01741], [-118.50377, 34.01739], [-118.50123, 34.01521], [-118.50097, 34.01506], [-118.49608, 34.0106], [-118.49497, 34.00952], [-118.49503, 34.00947], [-118.49498, 34.00936], [-118.4947, 34.0091], [-118.49464, 34.00908], [-118.49457, 34.00914], [-118.49188, 34.00657], [-118.49169, 34.00641], [-118.49144, 34.00614], [-118.49145, 34.00611], [-118.49135, 34.006], [-118.49133, 34.006], [-118.48736, 34.00198], [-118.48698, 34.00157], [-118.48726, 34.0014], [-118.48791, 34.0021], [-118.48813, 34.00196], [-118.48694, 34.00069], [-118.48689, 34.0007], [-118.48681, 34.00062], [-118.48676, 34.00061], [-118.48666, 34.00054], [-118.48649, 34.00059], [-118.48639, 34.00049], [-118.48652, 34.00036], [-118.48642, 34.00027], [-118.48645, 34.00023], [-118.48635, 34.00013], [-118.48638, 34.0001], [-118.48629, 33.99999], [-118.48635, 33.99995], [-118.48622, 33.99979], [-118.48628, 33.99973], [-118.48611, 33.99955], [-118.48549, 33.99996], [-118.48409, 33.99847], [-118.48355, 33.99794], [-118.4841, 33.99757], [-118.48411, 33.99755], [-118.48402, 33.99749], [-118.48387, 33.99748], [-118.48348, 33.99773], [-118.48336, 33.99775], [-118.48265, 33.99704], [-118.48266, 33.99682], [-118.48261, 33.99671], [-118.48255, 33.99663], [-118.48245, 33.99655], [-118.48212, 33.99647], [-118.48193, 33.99627], [-118.48199, 33.99621], [-118.48163, 33.99581], [-118.48214, 33.99547], [-118.48257, 33.99589], [-118.48352, 33.99534], [-118.48429, 33.99629], [-118.48542, 33.99756], [-118.48626, 33.9987], [-118.48672, 33.99921], [-118.48679, 33.99935], [-118.48711, 33.99973], [-118.48732, 33.99988], [-118.48764, 34.00019], [-118.48802, 34.00047], [-118.48827, 34.00069], [-118.48869, 34.00121], [-118.48893, 34.00156], [-118.48981, 34.00261], [-118.49033, 34.00315], [-118.49117, 34.00405], [-118.49219, 34.00526], [-118.49346, 34.00642], [-118.49467, 34.00733], [-118.49572, 34.00794], [-118.49658, 34.00837], [-118.49746, 34.00864], [-118.49796, 34.00895], [-118.49851, 34.00949], [-118.49904, 34.0098], [-118.49966, 34.00998], [-118.50024, 34.0104], [-118.501, 34.01129], [-118.50147, 34.01199], [-118.5029, 34.01419], [-118.50413, 34.01521], [-118.50517, 34.0161], [-118.50641, 34.0172], [-118.50874, 34.01906], [-118.50938, 34.01951], [-118.51008, 34.02018], [-118.51093, 34.02084], [-118.51237, 34.02183], [-118.51313, 34.02238], [-118.51402, 34.02295], [-118.51468, 34.0234], [-118.51565, 34.02398], [-118.51728, 34.02516], [-118.51739, 34.02521]]], [[[-118.49294, 34.00767], [-118.49265, 34.00791], [-118.49195, 34.00725], [-118.49225, 34.00701], [-118.49294, 34.00767]]], [[[-118.49444, 34.0091], [-118.49414, 34.00934], [-118.49379, 34.00901], [-118.49409, 34.00877], [-118.49444, 34.0091]]], [[[-118.49478, 34.00943], [-118.49449, 34.00967], [-118.49432, 34.0095], [-118.49461, 34.00926], [-118.49478, 34.00943]]], [[[-118.49544, 34.01006], [-118.49512, 34.01031], [-118.49465, 34.00986], [-118.49496, 34.0096], [-118.49544, 34.01006]]], [[[-118.49751, 34.01198], [-118.49725, 34.01217], [-118.497, 34.01196], [-118.49725, 34.01176], [-118.49751, 34.01198]]], [[[-118.49825, 34.01266], [-118.49801, 34.01286], [-118.4974, 34.01231], [-118.49766, 34.01212], [-118.49825, 34.01266]]], [[[-118.50218, 34.01609], [-118.50188, 34.01633], [-118.50134, 34.0159], [-118.50043, 34.01511], [-118.5007, 34.01489], [-118.50095, 34.01512], [-118.50119, 34.01525], [-118.50218, 34.01609]]]]} | Open Access 1 | Santa Monica State Beach | http://www.smgov.net/portals/beach/ | 1737 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 204.234 | Santa Monica SB | 1948 |
1424 | 1424 | 1423 | {"type": "Polygon", "coordinates": [[[-118.44788, 34.01608], [-118.44784, 34.01622], [-118.44658, 34.01731], [-118.44614, 34.01671], [-118.4444, 34.01766], [-118.44401, 34.01714], [-118.44734, 34.01539], [-118.44788, 34.01608]]]} | Open Access 1 | Airport Park | 15304 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 8.348 | Airport Park | ||
3034 | 3034 | 3033 | {"type": "Polygon", "coordinates": [[[-118.45832, 34.01723], [-118.4583, 34.01727], [-118.45684, 34.01811], [-118.45488, 34.01578], [-118.45484, 34.01579], [-118.45475, 34.0156], [-118.45409, 34.01503], [-118.45554, 34.0138], [-118.45587, 34.01428], [-118.45629, 34.01483], [-118.45632, 34.01484], [-118.45832, 34.01723]]]} | Open Access 1 | Clover Park | 17437 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 18.672 | Clover Park | ||
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 |
1633 | 1633 | 1632 | {"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 | Ashland Park | 15653 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 0.364 | Ashland 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);