superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AG_TYP = 5 and YR_EST = 2002
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11206 | 11206 | 11205 | {"type": "Polygon", "coordinates": [[[-117.00635, 34.01893], [-117.00623, 34.03414], [-116.99983, 34.03445], [-116.99983, 34.03356], [-116.99977, 34.0335], [-116.99545, 34.03333], [-116.99545, 34.02975], [-116.99022, 34.02962], [-116.99015, 34.03315], [-116.98469, 34.03296], [-116.98051, 34.03284], [-116.98041, 34.0259], [-116.99028, 34.02607], [-116.99035, 34.02244], [-116.98606, 34.02232], [-116.98628, 34.01867], [-116.99042, 34.01879], [-116.99038, 34.0183], [-116.98998, 34.01603], [-116.99139, 34.0165], [-116.9918, 34.01637], [-116.99214, 34.0163], [-116.99254, 34.01631], [-116.993, 34.01627], [-116.99345, 34.01602], [-116.99383, 34.0157], [-116.9941, 34.0157], [-116.99454, 34.01566], [-116.99512, 34.01572], [-116.99546, 34.01578], [-116.99573, 34.01569], [-116.99713, 34.01637], [-116.99777, 34.01644], [-116.99863, 34.01623], [-116.99915, 34.01625], [-116.99968, 34.01638], [-116.99978, 34.01645], [-117.00026, 34.0165], [-117.00066, 34.01657], [-117.00137, 34.01608], [-117.00196, 34.01594], [-117.00204, 34.01569], [-117.00213, 34.01554], [-117.00221, 34.01516], [-117.00269, 34.01519], [-117.00242, 34.01682], [-117.00106, 34.01836], [-117.00129, 34.01856], [-117.00109, 34.01901], [-117.00635, 34.01893]], [[-117.00051, 34.01841], [-117.00053, 34.01822], [-117.00036, 34.01817], [-117.00013, 34.01808], [-116.99983, 34.0183], [-116.99985, 34.01898], [-116.99982, 34.01899], [-116.99982, 34.01901], [-117.00049, 34.019], [-117.00077, 34.01867], [-117.00057, 34.01852], [-117.00051, 34.01841]]]} | Restricted Access 2 | Wildwood Canyon | 27517 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 843.836 | Wildwood Canyon | 2002 |
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]);