superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 577 and PARK_NAME = "Jacoby Creek-Gannon Slough Wildlife Area"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11684 | 11684 | 11683 | {"type": "Polygon", "coordinates": [[[-124.08173, 40.85366], [-124.08205, 40.85795], [-124.08204, 40.85906], [-124.08207, 40.86057], [-124.08202, 40.86085], [-124.08195, 40.86105], [-124.08189, 40.86114], [-124.08163, 40.8614], [-124.08149, 40.86151], [-124.0813, 40.86161], [-124.08108, 40.8617], [-124.08089, 40.86176], [-124.08045, 40.86184], [-124.08038, 40.85941], [-124.08033, 40.85885], [-124.07891, 40.85886], [-124.07895, 40.86166], [-124.07872, 40.86161], [-124.07846, 40.86153], [-124.07833, 40.86147], [-124.07832, 40.86144], [-124.07796, 40.86131], [-124.07763, 40.86114], [-124.07732, 40.86104], [-124.07701, 40.86099], [-124.07685, 40.86113], [-124.07634, 40.86087], [-124.07601, 40.86066], [-124.07575, 40.86044], [-124.07555, 40.86025], [-124.07351, 40.85798], [-124.07421, 40.85761], [-124.07362, 40.85568], [-124.07233, 40.85574], [-124.07226, 40.85358], [-124.07302, 40.85357], [-124.07299, 40.85048], [-124.07303, 40.84968], [-124.06907, 40.84969], [-124.06897, 40.84952], [-124.06746, 40.84753], [-124.07028, 40.84629], [-124.07029, 40.84627], [-124.06941, 40.8451], [-124.06942, 40.84507], [-124.06847, 40.8444], [-124.06704, 40.84257], [-124.0661, 40.84234], [-124.06497, 40.84145], [-124.06591, 40.84078], [-124.06643, 40.8412], [-124.06667, 40.84104], [-124.06696, 40.84128], [-124.06731, 40.84104], [-124.06894, 40.84233], [-124.07297, 40.8423], [-124.07297, 40.84018], [-124.07238, 40.84001], [-124.07216, 40.83988], [-124.07148, 40.83966], [-124.07063, 40.83907], [-124.07057, 40.83901], [-124.07033, 40.83899], [-124.07015, 40.83906], [-124.07008, 40.83903], [-124.07005, 40.83901], [-124.07005, 40.83896], [-124.07009, 40.83875], [-124.07015, 40.83869], [-124.07016, 40.83864], [-124.07016, 40.83859], [-124.07009, 40.83846], [-124.07041, 40.83803], [-124.07087, 40.8378], [-124.07057, 40.83747], [-124.07097, 40.83718], [-124.07298, 40.83864], [-124.07384, 40.83503], [-124.07993, 40.83507], [-124.08014, 40.83513], [-124.08081, 40.83521], [-124.08097, 40.83527], [-124.08109, 40.83536], [-124.08113, 40.83541], [-124.08122, 40.83563], [-124.08142, 40.83776], [-124.08153, 40.83871], [-124.08151, 40.84041], [-124.08148, 40.84617], [-124.08131, 40.84616], [-124.08129, 40.84617], [-124.0813, 40.84716], [-124.08128, 40.84882], [-124.08144, 40.85059], [-124.08146, 40.8506], [-124.08152, 40.85053], [-124.08161, 40.85091], [-124.08164, 40.85242], [-124.08173, 40.85366]], [[-124.07898, 40.84969], [-124.07899, 40.84967], [-124.07896, 40.8489], [-124.07788, 40.84905], [-124.07789, 40.8497], [-124.07898, 40.84969]]]} | Open Access 1 | Jacoby Creek-Gannon Slough Wildlife Area | 30363 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 587.911 | Jacoby Creek-Gannon Slough Wildlife Area |
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]);