calands: units_with_maps: 1 row where ACCESS_TYP = 1, COUNTY = 25 and DES

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

1 row where ACCESS_TYP = 1, COUNTY = 25 and DES_TP = 16

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
5998	5998	5997	{"type": "Polygon", "coordinates": [[[-121.18704, 39.33047], [-121.18689, 39.33154], [-121.18597, 39.3391], [-121.18576, 39.3431], [-121.18577, 39.34311], [-121.18673, 39.34309], [-121.18656, 39.35349], [-121.16714, 39.35344], [-121.16717, 39.35714], [-121.16255, 39.35727], [-121.16249, 39.36088], [-121.15789, 39.36099], [-121.15807, 39.35744], [-121.16254, 39.35727], [-121.16268, 39.35354], [-121.16491, 39.35349], [-121.16492, 39.35347], [-121.15822, 39.35356], [-121.1489, 39.35365], [-121.147, 39.36712], [-121.15585, 39.367], [-121.15691, 39.38178], [-121.14762, 39.38187], [-121.13829, 39.38301], [-121.13886, 39.37266], [-121.14346, 39.3709], [-121.14484, 39.37035], [-121.14519, 39.35587], [-121.14514, 39.35558], [-121.14501, 39.35502], [-121.14498, 39.35444], [-121.14463, 39.35386], [-121.14425, 39.35314], [-121.14386, 39.35264], [-121.14376, 39.35219], [-121.14348, 39.35133], [-121.14349, 39.35067], [-121.14364, 39.35004], [-121.14478, 39.34977], [-121.14546, 39.34952], [-121.14603, 39.34953], [-121.14674, 39.34967], [-121.14749, 39.34973], [-121.14902, 39.34969], [-121.15005, 39.34972], [-121.15183, 39.3499], [-121.15258, 39.34982], [-121.1534, 39.34966], [-121.15448, 39.34912], [-121.15491, 39.34862], [-121.1551, 39.34771], [-121.15529, 39.34705], [-121.15537, 39.34611], [-121.15542, 39.34512], [-121.15553, 39.34423], [-121.15554, 39.34368], [-121.15598, 39.34291], [-121.15645, 39.34228], [-121.15688, 39.34178], [-121.15724, 39.34115], [-121.15778, 39.34058], [-121.16056, 39.34053], [-121.16065, 39.33712], [-121.16385, 39.33712], [-121.16419, 39.33782], [-121.16458, 39.33841], [-121.16514, 39.33869], [-121.1655, 39.33891], [-121.16631, 39.33906], [-121.16706, 39.33887], [-121.1691, 39.33849], [-121.16974, 39.3385], [-121.17045, 39.33848], [-121.17312, 39.3385], [-121.17358, 39.33869], [-121.17447, 39.33878], [-121.17529, 39.33884], [-121.17611, 39.33888], [-121.17689, 39.33883], [-121.1781, 39.3387], [-121.17889, 39.33867], [-121.17971, 39.33843], [-121.18042, 39.3383], [-121.18093, 39.33811], [-121.18247, 39.33701], [-121.18304, 39.33657], [-121.18347, 39.33622], [-121.18384, 39.33567], [-121.18384, 39.33517], [-121.18346, 39.33478], [-121.18332, 39.33389], [-121.18333, 39.33315], [-121.18352, 39.33218], [-121.18395, 39.33152], [-121.18457, 39.33092], [-121.18557, 39.33054], [-121.18628, 39.33038], [-121.18704, 39.33047]], [[-121.173, 39.34586], [-121.17766, 39.346], [-121.17781, 39.34296], [-121.1686, 39.34277], [-121.16792, 39.34905], [-121.17258, 39.34924], [-121.173, 39.34586]]]}	Open Access 1	47332	Rice's Crossing Preserve	31043	3223	Bear Yuba Land Trust 100	Non Profit 6	Non Profit - Land Trust 10	http://www.bylt.org/	Non Governmental Organization 10	3223	Bear Yuba Land Trust 98	Non Profit 6	Non Profit - Land Trust 10	http://www.bylt.org/land/rices-crossing-preserve/	Yuba 25	1879.095	Rice's Crossing 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]);