calands: units_with_maps: 1 row where ACCESS_TYP = 2, COUNTY = 41 and MNG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 2, COUNTY = 41 and MNG_AGENCY = 61

Search:

descending

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
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]);