superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where MNG_AGENCY = 175
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3965 | 3965 | 3964 | {"type": "MultiPolygon", "coordinates": [[[[-119.89148, 34.41936], [-119.89147, 34.4198], [-119.88717, 34.41729], [-119.88483, 34.41438], [-119.88482, 34.41385], [-119.88713, 34.41629], [-119.88811, 34.41724], [-119.89148, 34.41936]]], [[[-119.88558, 34.42219], [-119.88492, 34.42218], [-119.88492, 34.42156], [-119.88557, 34.42156], [-119.88558, 34.42219]]], [[[-119.89287, 34.42218], [-119.89286, 34.42313], [-119.89006, 34.42336], [-119.88953, 34.42329], [-119.88807, 34.4233], [-119.88805, 34.42218], [-119.89287, 34.42218]]]]} | Open Access 1 | Ellwood Mesa | 18594 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 24.884 | Ellwood Mesa | ||
4649 | 4649 | 4648 | {"type": "Polygon", "coordinates": [[[-119.87679, 34.42375], [-119.87675, 34.42404], [-119.87631, 34.42397], [-119.87651, 34.42342], [-119.87657, 34.42341], [-119.8767, 34.42374], [-119.87679, 34.42375]]]} | Open Access 1 | Goleta holding 1 | 19382 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 0.437 | Goleta holding 1 | ||
5779 | 5779 | 5778 | {"type": "Polygon", "coordinates": [[[-119.88971, 34.44276], [-119.88954, 34.44277], [-119.88944, 34.44302], [-119.88909, 34.44301], [-119.88929, 34.44243], [-119.88971, 34.44243], [-119.88971, 34.44276]]]} | Open Access 1 | Koarts Open Space | 20711 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 0.641 | Koarts OS | ||
5941 | 5941 | 5940 | {"type": "Polygon", "coordinates": [[[-119.84965, 34.4455], [-119.84929, 34.44557], [-119.84909, 34.44559], [-119.84889, 34.44558], [-119.8485, 34.44553], [-119.84812, 34.4454], [-119.84777, 34.44522], [-119.8476, 34.4451], [-119.84765, 34.44503], [-119.84859, 34.44517], [-119.84907, 34.44512], [-119.84955, 34.44511], [-119.84965, 34.4455]]]} | Open Access 1 | Lake Los Carneros Park | 20950 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1.771 | Lake Los Carneros Park | ||
9299 | 9299 | 9298 | {"type": "MultiPolygon", "coordinates": [[[[-119.89321, 34.42693], [-119.89319, 34.42694], [-119.89274, 34.42694], [-119.89273, 34.42667], [-119.89219, 34.42657], [-119.89198, 34.42623], [-119.89213, 34.42616], [-119.89227, 34.42607], [-119.89235, 34.42606], [-119.89247, 34.4262], [-119.89285, 34.42648], [-119.89321, 34.42654], [-119.89323, 34.42681], [-119.89322, 34.4269], [-119.89321, 34.42693]]], [[[-119.89454, 34.42867], [-119.89453, 34.42955], [-119.89449, 34.42956], [-119.89409, 34.42957], [-119.89408, 34.42952], [-119.89396, 34.42952], [-119.89394, 34.42959], [-119.89376, 34.42959], [-119.89376, 34.42711], [-119.89343, 34.42703], [-119.89343, 34.42663], [-119.89341, 34.42646], [-119.89374, 34.42645], [-119.89375, 34.42633], [-119.89453, 34.42634], [-119.89453, 34.42636], [-119.89421, 34.42637], [-119.8942, 34.42675], [-119.8942, 34.42865], [-119.89454, 34.42867]]], [[[-119.90032, 34.42473], [-119.89981, 34.42453], [-119.89852, 34.42454], [-119.89757, 34.42465], [-119.89709, 34.4259], [-119.89711, 34.42672], [-119.89781, 34.42862], [-119.89784, 34.42948], [-119.89507, 34.42956], [-119.89505, 34.42082], [-119.89504, 34.42031], [-119.9003, 34.4212], [-119.9003, 34.42294], [-119.90032, 34.42473]]]]} | Open Access 1 | Santa Barbara Shores Park | 25053 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 86.23 | Santa Barbara Shores Park | ||
9856 | 9856 | 9855 | {"type": "MultiPolygon", "coordinates": [[[[-119.88652, 34.4241], [-119.8861, 34.42411], [-119.88609, 34.42296], [-119.88565, 34.42295], [-119.88567, 34.42283], [-119.88572, 34.42274], [-119.8858, 34.42267], [-119.88589, 34.42261], [-119.88606, 34.42258], [-119.88616, 34.42258], [-119.88626, 34.4226], [-119.88638, 34.42268], [-119.88649, 34.42281], [-119.88652, 34.42295], [-119.88652, 34.4241]]], [[[-119.88652, 34.42502], [-119.88649, 34.42503], [-119.88649, 34.42521], [-119.88645, 34.42525], [-119.8861, 34.42526], [-119.8861, 34.42433], [-119.88652, 34.42433], [-119.88652, 34.42502]]], [[[-119.88715, 34.42511], [-119.88666, 34.42512], [-119.88665, 34.42294], [-119.88662, 34.4228], [-119.88652, 34.42265], [-119.88663, 34.42258], [-119.88688, 34.42258], [-119.8869, 34.42255], [-119.88657, 34.42253], [-119.88654, 34.42242], [-119.88657, 34.42238], [-119.88661, 34.42236], [-119.8869, 34.42232], [-119.88714, 34.42233], [-119.88715, 34.42511]]], [[[-119.89286, 34.42346], [-119.892, 34.42346], [-119.89157, 34.42348], [-119.89122, 34.42359], [-119.89106, 34.42379], [-119.89004, 34.4238], [-119.89008, 34.42361], [-119.88957, 34.42349], [-119.88953, 34.42356], [-119.88807, 34.42356], [-119.88807, 34.4233], [-119.88953, 34.42329], [-119.89006, 34.42336], [-119.89286, 34.42313], [-119.89286, 34.42346]]]]} | Open Access 1 | Sperling Preserve | 25723 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 10.195 | Sperling Preserve | ||
10576 | 10576 | 10575 | {"type": "MultiPolygon", "coordinates": [[[[-119.8811, 34.4255], [-119.8809, 34.42576], [-119.88084, 34.42602], [-119.88092, 34.42609], [-119.88088, 34.42616], [-119.88088, 34.42624], [-119.88082, 34.42627], [-119.8807, 34.42651], [-119.88078, 34.42684], [-119.88091, 34.42693], [-119.88087, 34.42703], [-119.88074, 34.42703], [-119.88061, 34.42714], [-119.88059, 34.42731], [-119.88053, 34.4276], [-119.88047, 34.42762], [-119.88043, 34.42768], [-119.88042, 34.42774], [-119.88043, 34.4278], [-119.88033, 34.42785], [-119.88028, 34.42812], [-119.88025, 34.42814], [-119.8802, 34.4284], [-119.87987, 34.42835], [-119.87989, 34.42816], [-119.87985, 34.42803], [-119.8799, 34.428], [-119.87993, 34.42796], [-119.87994, 34.4279], [-119.87992, 34.42784], [-119.88005, 34.42777], [-119.88007, 34.42753], [-119.88018, 34.42752], [-119.88019, 34.42721], [-119.88026, 34.42716], [-119.88029, 34.42708], [-119.88038, 34.42703], [-119.8804, 34.4267], [-119.8804, 34.42636], [-119.88035, 34.42631], [-119.88032, 34.42622], [-119.88047, 34.42611], [-119.88046, 34.42588], [-119.88062, 34.42587], [-119.88073, 34.42542], [-119.88067, 34.42504], [-119.88084, 34.425], [-119.88095, 34.42528], [-119.88105, 34.42533], [-119.88104, 34.42542], [-119.8811, 34.4255]]], [[[-119.881, 34.42866], [-119.88094, 34.42896], [-119.88081, 34.42916], [-119.88074, 34.42909], [-119.88065, 34.42907], [-119.88057, 34.4291], [-119.88053, 34.42919], [-119.88054, 34.42929], [-119.88062, 34.42935], [-119.8805, 34.42959], [-119.88071, 34.4297], [-119.88089, 34.42976], [-119.88088, 34.42983], [-119.88053, 34.42984], [-119.88019, 34.42931], [-119.88011, 34.42913], [-119.88005, 34.42883], [-119.88007, 34.42854], [-119.881, 34.42866]]]]} | Open Access 1 | University Village | 26691 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 4.811 | University Village | ||
11712 | 11712 | 11711 | {"type": "Polygon", "coordinates": [[[-119.81931, 34.43834], [-119.81857, 34.43836], [-119.81841, 34.4382], [-119.81848, 34.43779], [-119.81856, 34.43765], [-119.8193, 34.43764], [-119.81931, 34.43834]]]} | Open Access 1 | Armitos Park | 28315 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1.476 | Armitos Park | ||
14129 | 14129 | 14128 | {"type": "Polygon", "coordinates": [[[-119.82045, 34.43733], [-119.81874, 34.43735], [-119.81907, 34.43679], [-119.81909, 34.43626], [-119.82044, 34.43625], [-119.82045, 34.43733]]]} | Open Access 1 | Jonny D. Wallis Neighborhood Park | https://www.cityofgoleta.org/projects-programs/parks-open-space/old-town-park | 32654 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 3.959 | Jonny D. Wallis Neighborhood Park | 2019 |
14797 | 14797 | 14796 | {"type": "Polygon", "coordinates": [[[-119.85084, 34.43435], [-119.85074, 34.43462], [-119.85038, 34.43485], [-119.85016, 34.43479], [-119.84985, 34.43431], [-119.84984, 34.43376], [-119.85033, 34.43355], [-119.85073, 34.43382], [-119.85084, 34.43435]]]} | Open Access 1 | Willow Springs Open Space | 27587 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 2.39 | Willow Springs OS |
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]);