superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "34.507" and MNG_AGENCY = 89
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11298 | 11298 | 11297 | {"type": "MultiPolygon", "coordinates": [[[[-117.2969, 33.27804], [-117.29646, 33.2786], [-117.29624, 33.27872], [-117.29594, 33.2788], [-117.29568, 33.27881], [-117.29448, 33.27868], [-117.29422, 33.2787], [-117.29408, 33.27873], [-117.29393, 33.27878], [-117.29303, 33.27854], [-117.29268, 33.27852], [-117.29234, 33.27861], [-117.29184, 33.27881], [-117.29146, 33.27904], [-117.29121, 33.27923], [-117.29094, 33.27957], [-117.29084, 33.27975], [-117.29072, 33.27991], [-117.29056, 33.28004], [-117.29037, 33.28016], [-117.28988, 33.28057], [-117.28949, 33.28103], [-117.28855, 33.28165], [-117.28834, 33.28194], [-117.28822, 33.2822], [-117.28816, 33.28223], [-117.28809, 33.28225], [-117.28762, 33.28224], [-117.28756, 33.28226], [-117.28747, 33.28234], [-117.2873, 33.28264], [-117.28701, 33.28261], [-117.2864, 33.28272], [-117.28622, 33.28272], [-117.28603, 33.2827], [-117.28685, 33.28185], [-117.28685, 33.28148], [-117.28793, 33.28148], [-117.28794, 33.28004], [-117.28835, 33.28021], [-117.2885, 33.28009], [-117.28852, 33.27965], [-117.28895, 33.27946], [-117.28922, 33.27931], [-117.28955, 33.27906], [-117.29028, 33.27873], [-117.2906, 33.27852], [-117.29073, 33.2783], [-117.2906, 33.27805], [-117.28989, 33.2781], [-117.28969, 33.27818], [-117.28946, 33.27822], [-117.28869, 33.27818], [-117.28849, 33.27826], [-117.28835, 33.27843], [-117.28795, 33.27842], [-117.28796, 33.27782], [-117.29663, 33.27789], [-117.2969, 33.27804]]], [[[-117.29783, 33.27845], [-117.29668, 33.27933], [-117.29645, 33.27916], [-117.29631, 33.27911], [-117.29625, 33.27904], [-117.29624, 33.279], [-117.29646, 33.27892], [-117.29673, 33.27875], [-117.29714, 33.2784], [-117.29719, 33.27839], [-117.29723, 33.27848], [-117.29731, 33.27855], [-117.29742, 33.27858], [-117.29748, 33.27857], [-117.29755, 33.27854], [-117.29762, 33.27848], [-117.29772, 33.27825], [-117.29783, 33.27845]]]]} | No Public Access 3 | Wilmont Preserve | 27601 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 34.507 | Wilmont Preserve |
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]);