superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "39.189"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9802 | 9802 | 9801 | {"type": "Polygon", "coordinates": [[[-117.80678, 33.67139], [-117.80676, 33.67142], [-117.80666, 33.67141], [-117.80656, 33.67144], [-117.80646, 33.67151], [-117.80539, 33.67258], [-117.80528, 33.67274], [-117.80528, 33.67281], [-117.80501, 33.67291], [-117.8049, 33.67309], [-117.80474, 33.67323], [-117.80456, 33.67333], [-117.80429, 33.6734], [-117.80403, 33.67352], [-117.80388, 33.6736], [-117.80365, 33.67384], [-117.80366, 33.67387], [-117.8036, 33.67393], [-117.80357, 33.67392], [-117.80345, 33.67404], [-117.80346, 33.67406], [-117.8034, 33.67414], [-117.80342, 33.67417], [-117.80335, 33.67426], [-117.80327, 33.67431], [-117.8031, 33.67449], [-117.80206, 33.67384], [-117.80145, 33.67352], [-117.80054, 33.67312], [-117.8005, 33.67302], [-117.80105, 33.67324], [-117.80186, 33.67363], [-117.80209, 33.67336], [-117.80218, 33.67339], [-117.80228, 33.67324], [-117.80228, 33.67306], [-117.8022, 33.67293], [-117.80268, 33.67314], [-117.80284, 33.67297], [-117.80289, 33.67289], [-117.80291, 33.6728], [-117.8029, 33.67248], [-117.803, 33.67226], [-117.80308, 33.67216], [-117.80315, 33.67219], [-117.80328, 33.67205], [-117.8034, 33.6721], [-117.80349, 33.67199], [-117.80344, 33.67194], [-117.8035, 33.67188], [-117.80346, 33.67182], [-117.80358, 33.67167], [-117.80355, 33.67163], [-117.8036, 33.67159], [-117.80364, 33.67147], [-117.80363, 33.67132], [-117.8036, 33.67123], [-117.80344, 33.671], [-117.80343, 33.67095], [-117.80345, 33.67081], [-117.80349, 33.67074], [-117.80286, 33.67062], [-117.80222, 33.67035], [-117.80216, 33.67031], [-117.80251, 33.66998], [-117.80268, 33.66977], [-117.80276, 33.66963], [-117.80281, 33.66949], [-117.80282, 33.66935], [-117.80308, 33.66934], [-117.80461, 33.6678], [-117.80616, 33.66797], [-117.80611, 33.66836], [-117.80628, 33.66839], [-117.80625, 33.66865], [-117.80628, 33.66868], [-117.80625, 33.66873], [-117.80626, 33.6688], [-117.80622, 33.66884], [-117.80614, 33.66937], [-117.80609, 33.66942], [-117.80609, 33.66949], [-117.8056, 33.66944], [-117.80556, 33.66951], [-117.80544, 33.66951], [-117.80541, 33.66969], [-117.8053, 33.66969], [-117.80527, 33.66986], [-117.80521, 33.66988], [-117.8052, 33.66996], [-117.8053, 33.66998], [-117.80527, 33.67015], [-117.80535, 33.67017], [-117.80531, 33.6703], [-117.80518, 33.6705], [-117.80506, 33.67057], [-117.80489, 33.67059], [-117.80488, 33.6706], [-117.80491, 33.67067], [-117.80602, 33.67119], [-117.80631, 33.67127], [-117.80655, 33.67131], [-117.80678, 33.67139]]]} | Restricted Access 2 | South Lake Park | 25662 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | http://www.wva.org/ | Private 14 | 39.189 | South Lake 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]);