units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, COUNTY = 41 and DES_TP = 16
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11275 | 11275 | 11274 | {"type": "Polygon", "coordinates": [[[-121.46596, 38.66791], [-121.46595, 38.66872], [-121.46583, 38.66866], [-121.46595, 38.66841], [-121.46579, 38.66833], [-121.46512, 38.6682], [-121.46418, 38.66813], [-121.46331, 38.66809], [-121.463, 38.66824], [-121.46235, 38.66836], [-121.46193, 38.66838], [-121.46111, 38.66833], [-121.46048, 38.66832], [-121.45968, 38.66858], [-121.45913, 38.66879], [-121.45875, 38.66888], [-121.45845, 38.66893], [-121.45814, 38.66895], [-121.4572, 38.66894], [-121.45713, 38.66904], [-121.45712, 38.66929], [-121.4569, 38.66927], [-121.4569, 38.66844], [-121.45715, 38.66844], [-121.4573, 38.66859], [-121.45804, 38.6686], [-121.45838, 38.66858], [-121.45884, 38.66849], [-121.45949, 38.66826], [-121.46, 38.66809], [-121.4603, 38.66801], [-121.46073, 38.66797], [-121.46113, 38.66797], [-121.46194, 38.66802], [-121.46228, 38.66801], [-121.46282, 38.6679], [-121.46319, 38.66773], [-121.46422, 38.66777], [-121.46423, 38.6678], [-121.46516, 38.66788], [-121.46575, 38.66796], [-121.46584, 38.6679], [-121.46596, 38.66791]]]} | Restricted Access 2 | 21781 | Dry Creek Watershed | 18286 | 3061 | Sacramento Valley Conservancy 972 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sacramentovalleyconservancy.org/ | Non Governmental Organization 10 | 3061 | Sacramento Valley Conservancy 937 | Non Profit 6 | Non Profit - Land Trust 10 | Sacramento 41 | 8.226 | Dry Creek Watershed | 0 | Private Conservation 16 | 2 | |
| 13925 | 13925 | 13924 | {"type": "MultiPolygon", "coordinates": [[[[-121.42884, 38.25745], [-121.42668, 38.25702], [-121.42528, 38.25894], [-121.42541, 38.26004], [-121.42473, 38.26004], [-121.42481, 38.26013], [-121.42492, 38.26134], [-121.42445, 38.26133], [-121.4244, 38.26068], [-121.4242, 38.26048], [-121.42356, 38.2608], [-121.42246, 38.26102], [-121.42229, 38.26121], [-121.42249, 38.26133], [-121.41767, 38.26132], [-121.41768, 38.26086], [-121.4176, 38.26002], [-121.41054, 38.26001], [-121.41046, 38.2696], [-121.40484, 38.26957], [-121.40485, 38.26886], [-121.40495, 38.26879], [-121.40595, 38.26827], [-121.40645, 38.26804], [-121.40687, 38.26777], [-121.40753, 38.26743], [-121.40777, 38.26728], [-121.40786, 38.26716], [-121.40863, 38.26543], [-121.40884, 38.26455], [-121.40887, 38.26428], [-121.40875, 38.26395], [-121.40855, 38.2636], [-121.4085, 38.26332], [-121.40852, 38.26314], [-121.40874, 38.26284], [-121.40882, 38.26243], [-121.40864, 38.26199], [-121.40843, 38.26173], [-121.40784, 38.2612], [-121.40789, 38.26079], [-121.40811, 38.26037], [-121.40873, 38.25947], [-121.40883, 38.25915], [-121.40879, 38.25872], [-121.40882, 38.25859], [-121.40891, 38.25851], [-121.40987, 38.25812], [-121.41021, 38.25792], [-121.41027, 38.25761], [-121.41019, 38.25731], [-121.40993, 38.25703], [-121.40961, 38.25681], [-121.40928, 38.25665], [-121.40909, 38.25652], [-121.40905, 38.25631], [-121.40906, 38.25616], [-121.40917, 38.25588], [-121.40923, 38.25559], [-121.40919, 38.25522], [-121.40912, 38.25493], [-121.40955, 38.25468], [-121.40923, 38.25439], [-121.40885, 38.2546], [-121.40871, 38.2547], [-121.40861, 38.25487], [-121.40871, 38.25527], [-121.40874, 38.25558], [-121.40869, 38.25579], [-121.40857, 38.25608], [-121.40856, 38.25633], [-121.40863, 38.25672], [-121.40899, 38.25696], [-121.40932, 38.25712], [-121.40957, 38.25729], [-121.40974, 38.25747], [-121.40977, 38.25762], [-121.40976, 38.2577], [-121.40961, 38.25779], [-121.40862, 38.2582], [-121.40836, 38.25841], [-121.4083, 38.2587], [-121.40834, 38.25912], [-121.40827, 38.25933], [-121.40766, 38.2602], [-121.40741, 38.26069], [-121.40734, 38.26132], [-121.40765, 38.26165], [-121.40805, 38.26197], [-121.4082, 38.26215], [-121.40832, 38.26246], [-121.40827, 38.26271], [-121.40805, 38.26301], [-121.408, 38.26333], [-121.40808, 38.26371], [-121.40829, 38.26408], [-121.40837, 38.26431], [-121.40835, 38.2645], [-121.40816, 38.26533], [-121.4074, 38.26702], [-121.40724, 38.26712], [-121.40659, 38.26746], [-121.40618, 38.26772], [-121.40569, 38.26794], [-121.40466, 38.26848], [-121.40446, 38.26861], [-121.40436, 38.26876], [-121.40436, 38.26929], [-121.40432, 38.26956], [-121.39215, 38.26949], [-121.39224, 38.26209], [-121.39776, 38.2621], [-121.39827, 38.26167], [-121.39866, 38.26069], [-121.39865, 38.25957], [-121.39916, 38.25819], [-121.3998, 38.25771], [-121.40069, 38.25608], [-121.40116, 38.25575], [-121.40126, 38.25502], [-121.40216, 38.2541], [-121.4041, 38.25411], [-121.40433, 38.25417], [-121.40522, 38.25423], [-121.40602, 38.25411], [-121.40637, 38.2538], [-121.40648, 38.25364], [-121.40855, 38.25364], [-121.41058, 38.25406], [-121.41059, 38.25414], [-121.42873, 38.25424], [-121.42884, 38.25745]]], [[[-121.42582, 38.27583], [-121.42168, 38.27584], [-121.4222, 38.27507], [-121.42063, 38.26884], [-121.42183, 38.26861], [-121.42579, 38.26863], [-121.42582, 38.27583]]]]} | Restricted Access 2 | 46984 | Cosumnes River Preserve | 30623 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Sacramento 41 | 846.751 | Cosumnes River Preserve | 0 | Private Conservation 16 | 2 |
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]);