superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "27.767" and MNG_AGENCY = 122
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1785 | 1785 | 1784 | {"type": "Polygon", "coordinates": [[[-117.98765, 33.67267], [-117.98687, 33.67386], [-117.98688, 33.67419], [-117.98733, 33.67419], [-117.98734, 33.67457], [-117.98688, 33.67459], [-117.9869, 33.67599], [-117.98641, 33.67682], [-117.98645, 33.67935], [-117.98583, 33.67934], [-117.98577, 33.6793], [-117.98576, 33.67902], [-117.98573, 33.67883], [-117.98566, 33.67864], [-117.98556, 33.67846], [-117.98544, 33.6783], [-117.98528, 33.67815], [-117.98511, 33.67802], [-117.98486, 33.67788], [-117.98473, 33.67777], [-117.98478, 33.67771], [-117.98439, 33.67729], [-117.98438, 33.67724], [-117.98457, 33.677], [-117.98469, 33.67675], [-117.98473, 33.67649], [-117.98472, 33.67606], [-117.98474, 33.6759], [-117.98479, 33.67575], [-117.98565, 33.67392], [-117.98579, 33.67354], [-117.98585, 33.67328], [-117.98588, 33.67301], [-117.98588, 33.67237], [-117.98765, 33.67236], [-117.98765, 33.67267]]]} | Open Access 1 | Bartlett Park | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bartlett-park.cfm | 15843 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 27.767 | Bartlett 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]);