units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 1225, LAYER = 2 and MNG_AGENCY = 577
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14416 | 14416 | 14415 | {"type": "Polygon", "coordinates": [[[-124.08511, 40.88587], [-124.08396, 40.88873], [-124.08299, 40.8885], [-124.08291, 40.88869], [-124.08254, 40.8887], [-124.08248, 40.88872], [-124.08231, 40.88899], [-124.08225, 40.889], [-124.08209, 40.88899], [-124.0825, 40.88849], [-124.08255, 40.88846], [-124.08271, 40.88841], [-124.08299, 40.8884], [-124.08333, 40.88846], [-124.08346, 40.88813], [-124.08351, 40.88808], [-124.0837, 40.88795], [-124.08381, 40.8877], [-124.08407, 40.88743], [-124.08412, 40.88735], [-124.08413, 40.88722], [-124.08402, 40.88687], [-124.08407, 40.88654], [-124.08409, 40.88648], [-124.08416, 40.8864], [-124.08428, 40.88634], [-124.08431, 40.88628], [-124.08427, 40.88623], [-124.08392, 40.88608], [-124.08335, 40.88579], [-124.08313, 40.88574], [-124.08272, 40.88605], [-124.0824, 40.88632], [-124.08238, 40.88637], [-124.08241, 40.8865], [-124.0824, 40.8867], [-124.08231, 40.88697], [-124.08161, 40.88806], [-124.08155, 40.88806], [-124.0815, 40.88804], [-124.08147, 40.888], [-124.08147, 40.88788], [-124.08148, 40.88782], [-124.08156, 40.88762], [-124.08194, 40.88677], [-124.08197, 40.88667], [-124.08197, 40.88643], [-124.08192, 40.8863], [-124.08184, 40.88613], [-124.08275, 40.88537], [-124.08511, 40.88587]]]} | Open Access 1 | 47031 | Janes Creek Meadows Openspace | 30682 | 1432 | Arcata, City of 587 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | Humboldt 45 | 8.926 | Janes Creek Meadows Openspace | None 1225 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);