calands: units_with_maps: 4 rows where ACCESS_TYP = 1, MNG_AGENCY = 703 and MNG_AG

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

4 rows where ACCESS_TYP = 1, MNG_AGENCY = 703 and MNG_AG_TYP = 10

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
4064	4064	4063	{"type": "Polygon", "coordinates": [[[-120.3848, 39.80942], [-120.38431, 39.80942], [-120.38434, 39.81012], [-120.37919, 39.81011], [-120.37917, 39.81285], [-120.36803, 39.81173], [-120.36148, 39.81104], [-120.36147, 39.81004], [-120.37073, 39.81007], [-120.37074, 39.80281], [-120.37087, 39.79921], [-120.37563, 39.79923], [-120.37805, 39.79919], [-120.37787, 39.80285], [-120.38036, 39.80287], [-120.38012, 39.80642], [-120.38429, 39.80655], [-120.38472, 39.80744], [-120.3848, 39.80942]]]}	Open Access 1	47066	Feather River Ranch	30718	3123	Feather River Land Trust 720	Non Profit 6	Non Profit - Land Trust 10	http://www.frlt.org/	Non Governmental Organization 10	3123	Feather River Land Trust 703	Non Profit 6	Non Profit - Land Trust 10	Plumas 57	338.36	Feather River Ranch	Private Conservation 16	2
14421	14421	14420	{"type": "MultiPolygon", "coordinates": [[[[-120.3804, 39.79567], [-120.38036, 39.7964], [-120.38025, 39.79925], [-120.37805, 39.79919], [-120.37563, 39.79923], [-120.37087, 39.79921], [-120.37074, 39.80281], [-120.37073, 39.81007], [-120.35191, 39.81], [-120.35191, 39.81036], [-120.34327, 39.80946], [-120.34323, 39.79552], [-120.34339, 39.79198], [-120.34341, 39.78848], [-120.35202, 39.78821], [-120.36156, 39.78817], [-120.36172, 39.78096], [-120.36631, 39.78096], [-120.36637, 39.77731], [-120.37111, 39.77735], [-120.37998, 39.77723], [-120.37999, 39.77749], [-120.37999, 39.79566], [-120.3804, 39.79567]]], [[[-120.3567, 39.81713], [-120.35425, 39.81716], [-120.34768, 39.81717], [-120.34782, 39.81026], [-120.35191, 39.81069], [-120.3534, 39.81099], [-120.35669, 39.81355], [-120.3567, 39.81713]]]]}	Open Access 1	47034	Sierra Valley Preserve	30685	3123	Feather River Land Trust 720	Non Profit 6	Non Profit - Land Trust 10	http://www.frlt.org/	Non Governmental Organization 10	3123	Feather River Land Trust 703	Non Profit 6	Non Profit - Land Trust 10	Plumas 57	2200.819	Sierra Valley Preserve	Private Conservation 16	2
14456	14456	14455	{"type": "Polygon", "coordinates": [[[-120.7219, 40.05271], [-120.72186, 40.05619], [-120.71244, 40.05613], [-120.71233, 40.05961], [-120.70762, 40.05953], [-120.70754, 40.0624], [-120.70371, 40.06239], [-120.70365, 40.06603], [-120.69406, 40.06603], [-120.69399, 40.06951], [-120.68457, 40.0695], [-120.68457, 40.06876], [-120.68539, 40.06875], [-120.68537, 40.06702], [-120.68457, 40.06706], [-120.68456, 40.06598], [-120.68954, 40.06601], [-120.68957, 40.06236], [-120.6933, 40.06236], [-120.69344, 40.05938], [-120.69364, 40.0526], [-120.6937, 40.04825], [-120.71704, 40.04853], [-120.71713, 40.05268], [-120.7219, 40.05271]]]}	Open Access 1	47076	Heart K Ranch	30730	3123	Feather River Land Trust 720	Non Profit 6	Non Profit - Land Trust 10	http://www.frlt.org/	Non Governmental Organization 10	3123	Feather River Land Trust 703	Non Profit 6	Non Profit - Land Trust 10	Plumas 57	904.84	Heart K Ranch	Private Conservation 16	2
14461	14461	14460	{"type": "MultiPolygon", "coordinates": [[[[-121.22252, 40.31078], [-121.22234, 40.31082], [-121.22234, 40.31244], [-121.21829, 40.31287], [-121.21776, 40.31256], [-121.21823, 40.31224], [-121.21838, 40.31208], [-121.21838, 40.31207], [-121.21784, 40.31203], [-121.21747, 40.31174], [-121.21775, 40.31162], [-121.21816, 40.31165], [-121.21801, 40.3114], [-121.21819, 40.31108], [-121.21785, 40.31078], [-121.21836, 40.31078], [-121.21846, 40.31048], [-121.21802, 40.3103], [-121.21835, 40.30991], [-121.21831, 40.30977], [-121.21884, 40.3096], [-121.21883, 40.30958], [-121.2184, 40.3095], [-121.21846, 40.30891], [-121.21846, 40.30843], [-121.2186, 40.30816], [-121.21866, 40.30782], [-121.21894, 40.30745], [-121.21913, 40.30715], [-121.21911, 40.30694], [-121.21916, 40.30681], [-121.22156, 40.30685], [-121.2219, 40.30715], [-121.22246, 40.30748], [-121.22252, 40.30979], [-121.22252, 40.31078]]], [[[-121.22266, 40.32148], [-121.22212, 40.32148], [-121.22206, 40.32084], [-121.22192, 40.32077], [-121.22135, 40.32061], [-121.22117, 40.3204], [-121.22083, 40.32055], [-121.22063, 40.32057], [-121.22055, 40.32044], [-121.2208, 40.32025], [-121.22073, 40.32014], [-121.2205, 40.32006], [-121.22102, 40.31986], [-121.2211, 40.31976], [-121.22105, 40.3196], [-121.22087, 40.31955], [-121.2208, 40.31943], [-121.2213, 40.3193], [-121.22129, 40.31814], [-121.22128, 40.31813], [-121.22081, 40.31841], [-121.22059, 40.31849], [-121.22048, 40.31844], [-121.22051, 40.31839], [-121.22049, 40.31835], [-121.22041, 40.31833], [-121.22035, 40.31835], [-121.22027, 40.3183], [-121.22027, 40.31817], [-121.22033, 40.3181], [-121.22066, 40.31789], [-121.22076, 40.31785], [-121.22089, 40.31773], [-121.22107, 40.3175], [-121.22112, 40.31734], [-121.22078, 40.31758], [-121.22052, 40.3178], [-121.22035, 40.31792], [-121.21999, 40.31802], [-121.21983, 40.318], [-121.21957, 40.31786], [-121.21928, 40.31737], [-121.21899, 40.31698], [-121.21886, 40.31692], [-121.21872, 40.31693], [-121.21855, 40.3169], [-121.21863, 40.31678], [-121.21933, 40.31659], [-121.21938, 40.31659], [-121.21955, 40.31664], [-121.21967, 40.3167], [-121.21977, 40.31666], [-121.21961, 40.31653], [-121.21942, 40.31648], [-121.21925, 40.31648], [-121.21868, 40.31664], [-121.21853, 40.31643], [-121.21867, 40.31617], [-121.21878, 40.31605], [-121.21878, 40.31594], [-121.21868, 40.31584], [-121.21847, 40.31589], [-121.21837, 40.31581], [-121.21837, 40.3157], [-121.2185, 40.31551], [-121.21862, 40.31548], [-121.21882, 40.31556], [-121.21898, 40.31555], [-121.21962, 40.31534], [-121.21985, 40.31529], [-121.21985, 40.31527], [-121.21962, 40.31515], [-121.21969, 40.31503], [-121.21988, 40.31485], [-121.21973, 40.3148], [-121.21978, 40.31467], [-121.22005, 40.31459], [-121.21985, 40.31451], [-121.21985, 40.3144], [-121.22015, 40.31431], [-121.22053, 40.31428], [-121.22069, 40.31432], [-121.22092, 40.31433], [-121.22093, 40.31432], [-121.22073, 40.31416], [-121.22015, 40.31415], [-121.21981, 40.3142], [-121.21968, 40.31428], [-121.21957, 40.31447], [-121.21954, 40.3146], [-121.2195, 40.31468], [-121.21941, 40.31478], [-121.21926, 40.31487], [-121.2189, 40.3147], [-121.21921, 40.31447], [-121.2192, 40.31424], [-121.21942, 40.31415], [-121.21933, 40.31408], [-121.21955, 40.31405], [-121.21983, 40.31407], [-121.22027, 40.31387], [-121.22028, 40.31385], [-121.21964, 40.3139], [-121.21944, 40.31383], [-121.21925, 40.31367], [-121.21903, 40.31356], [-121.21864, 40.31343], [-121.21851, 40.31326], [-121.2212, 40.31293], [-121.22213, 40.31275], [-121.22218, 40.31323], [-121.22238, 40.31321], [-121.22238, 40.31391], [-121.22266, 40.32148]]]]}	Open Access 1	47078	Olsen Barn	30732	3123	Feather River Land Trust 720	Non Profit 6	Non Profit - Land Trust 10	http://www.frlt.org/	Non Governmental Organization 10	3123	Feather River Land Trust 703	Non Profit 6	Non Profit - Land Trust 10	Plumas 57	103.048	Olsen Barn	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]);