calands: units_with_maps: 1 row where MNG_AG_TYP = 5 and SUID

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

1 row where MNG_AG_TYP = 5 and SUID_NMA = 30507

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
16755	16755	16754	{"type": "Polygon", "coordinates": [[[-124.27609, 40.69783], [-124.276, 40.69801], [-124.27585, 40.69821], [-124.27527, 40.69871], [-124.27511, 40.69892], [-124.27494, 40.69918], [-124.2748, 40.69943], [-124.27463, 40.69967], [-124.27435, 40.69997], [-124.27409, 40.70045], [-124.27371, 40.70092], [-124.27345, 40.7012], [-124.27303, 40.70175], [-124.27284, 40.70203], [-124.27256, 40.70256], [-124.27225, 40.70306], [-124.27211, 40.70322], [-124.27152, 40.70403], [-124.27126, 40.70431], [-124.2711, 40.70454], [-124.27091, 40.70476], [-124.27069, 40.70506], [-124.27025, 40.70556], [-124.27001, 40.70582], [-124.2694, 40.70642], [-124.26919, 40.70666], [-124.26883, 40.70718], [-124.26843, 40.70787], [-124.26805, 40.70844], [-124.26744, 40.70914], [-124.267, 40.70962], [-124.26687, 40.70983], [-124.26645, 40.71037], [-124.2659, 40.71096], [-124.26565, 40.71115], [-124.26503, 40.71182], [-124.26433, 40.71262], [-124.26421, 40.71284], [-124.26393, 40.71325], [-124.26339, 40.71394], [-124.26322, 40.71426], [-124.26303, 40.71455], [-124.26266, 40.71528], [-124.26247, 40.71555], [-124.26194, 40.71613], [-124.26176, 40.71639], [-124.26162, 40.71668], [-124.26131, 40.71713], [-124.26108, 40.71761], [-124.26098, 40.71775], [-124.26072, 40.71803], [-124.26043, 40.71841], [-124.26001, 40.71902], [-124.25991, 40.71921], [-124.25867, 40.72062], [-124.25822, 40.72123], [-124.25779, 40.72189], [-124.25753, 40.72215], [-124.25722, 40.72251], [-124.25699, 40.72288], [-124.25686, 40.72304], [-124.25624, 40.72376], [-124.25614, 40.72391], [-124.25576, 40.72463], [-124.25512, 40.72575], [-124.25485, 40.72608], [-124.25471, 40.72621], [-124.25447, 40.72649], [-124.25413, 40.72697], [-124.25402, 40.72719], [-124.25371, 40.7277], [-124.25313, 40.72834], [-124.25282, 40.72878], [-124.25272, 40.72896], [-124.25244, 40.72933], [-124.25187, 40.72992], [-124.25171, 40.73017], [-124.25162, 40.7304], [-124.25148, 40.73064], [-124.25117, 40.73066], [-124.25099, 40.73082], [-124.24962, 40.73299], [-124.24935, 40.73332], [-124.24917, 40.73366], [-124.24897, 40.73416], [-124.24854, 40.73494], [-124.24812, 40.73533], [-124.24753, 40.73615], [-124.24708, 40.73693], [-124.2464, 40.73788], [-124.24619, 40.73828], [-124.24596, 40.73867], [-124.24563, 40.73911], [-124.24555, 40.73926], [-124.24551, 40.73942], [-124.24541, 40.73961], [-124.24518, 40.73992], [-124.24486, 40.74024], [-124.24463, 40.74057], [-124.24435, 40.74103], [-124.24425, 40.74123], [-124.2437, 40.74196], [-124.24264, 40.74351], [-124.24255, 40.74357], [-124.2425, 40.74371], [-124.24225, 40.74407], [-124.2416, 40.74521], [-124.24128, 40.74569], [-124.24102, 40.74596], [-124.24079, 40.74632], [-124.2405, 40.74671], [-124.24045, 40.74685], [-124.24046, 40.74696], [-124.24046, 40.74728], [-124.24038, 40.74767], [-124.24031, 40.74786], [-124.23913, 40.74985], [-124.23757, 40.7526], [-124.23504, 40.75618], [-124.23459, 40.75662], [-124.23437, 40.75653], [-124.23423, 40.75635], [-124.23338, 40.75493], [-124.23208, 40.75284], [-124.23133, 40.75181], [-124.23025, 40.74996], [-124.22994, 40.74951], [-124.22951, 40.74883], [-124.22944, 40.74875], [-124.22923, 40.74868], [-124.22899, 40.74866], [-124.22843, 40.74864], [-124.22812, 40.74864], [-124.2279, 40.74861], [-124.22729, 40.74857], [-124.22706, 40.7486], [-124.22669, 40.74857], [-124.226, 40.74834], [-124.22581, 40.74819], [-124.22588, 40.74804], [-124.22593, 40.74802], [-124.22607, 40.74803], [-124.22629, 40.74811], [-124.22664, 40.74828], [-124.22683, 40.74834], [-124.227, 40.74836], [-124.22708, 40.74832], [-124.22715, 40.74819], [-124.22713, 40.74794], [-124.2276, 40.74734], [-124.22772, 40.74702], [-124.22777, 40.74684], [-124.22777, 40.74674], [-124.23145, 40.74648], [-124.23146, 40.74599], [-124.23176, 40.74589], [-124.23266, 40.74547], [-124.23292, 40.74534], [-124.23321, 40.74526], [-124.23359, 40.7451], [-124.23385, 40.74489], [-124.23428, 40.74442], [-124.23454, 40.74425], [-124.23482, 40.74412], [-124.23511, 40.74385], [-124.23535, 40.7436], [-124.23535, 40.7439], [-124.23624, 40.74327], [-124.23625, 40.74304], [-124.23656, 40.74282], [-124.23688, 40.74239], [-124.23721, 40.7417], [-124.23753, 40.74125], [-124.23783, 40.74125], [-124.23809, 40.74055], [-124.23819, 40.74035], [-124.23847, 40.74035], [-124.23877, 40.74013], [-124.23909, 40.73968], [-124.23911, 40.73945], [-124.23942, 40.73922], [-124.23973, 40.73879], [-124.24033, 40.73879], [-124.24065, 40.73834], [-124.24081, 40.73823], [-124.24119, 40.73823], [-124.24139, 40.73807], [-124.24133, 40.73757], [-124.24498, 40.73418], [-124.2453, 40.7317], [-124.24544, 40.7316], [-124.24605, 40.73139], [-124.24822, 40.72983], [-124.24855, 40.72915], [-124.24917, 40.72871], [-124.24962, 40.72818], [-124.24974, 40.72801], [-124.24978, 40.72797], [-124.24991, 40.72783], [-124.25001, 40.72766], [-124.2501, 40.72748], [-124.25011, 40.72738], [-124.25006, 40.72729], [-124.25004, 40.7269], [-124.25014, 40.7269], [-124.25045, 40.72668], [-124.25078, 40.72624], [-124.25138, 40.72602], [-124.25152, 40.72546], [-124.25272, 40.72489], [-124.25292, 40.72406], [-124.25294, 40.72401], [-124.25298, 40.72378], [-124.2531, 40.72362], [-124.25313, 40.72352], [-124.25315, 40.72335], [-124.25322, 40.72317], [-124.25338, 40.72293], [-124.25344, 40.72273], [-124.25376, 40.72218], [-124.25431, 40.72155], [-124.25492, 40.72109], [-124.25529, 40.7205], [-124.25567, 40.72022], [-124.25581, 40.71999], [-124.25595, 40.7198], [-124.25647, 40.71948], [-124.25668, 40.71932], [-124.25759, 40.71932], [-124.2579, 40.71862], [-124.25807, 40.71818], [-124.25847, 40.71776], [-124.2586, 40.71751], [-124.25869, 40.7173], [-124.25867, 40.71718], [-124.25855, 40.71705], [-124.25856, 40.71696], [-124.25861, 40.71684], [-124.25886, 40.71646], [-124.25899, 40.71612], [-124.25902, 40.71587], [-124.25901, 40.71585], [-124.25917, 40.71547], [-124.2595, 40.71509], [-124.25969, 40.71478], [-124.25979, 40.71454], [-124.25972, 40.71433], [-124.25966, 40.71425], [-124.25974, 40.71405], [-124.25992, 40.71374], [-124.26017, 40.71358], [-124.26065, 40.71335], [-124.26079, 40.71326], [-124.26247, 40.71324], [-124.26323, 40.71086], [-124.26294, 40.71018], [-124.26294, 40.70967], [-124.26283, 40.70865], [-124.26459, 40.70864], [-124.26546, 40.70739], [-124.26604, 40.70662], [-124.26704, 40.70517], [-124.26844, 40.70423], [-124.27007, 40.7031], [-124.27062, 40.70276], [-124.27059, 40.7016], [-124.27078, 40.70147], [-124.27193, 40.70146], [-124.27381, 40.69903], [-124.27411, 40.69859], [-124.27413, 40.69784], [-124.27609, 40.69783]]]}	Open Access 1	21615	South Spit Wildlife Area	30507	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/	California Department of Fish and Wildlife 6	201	California Department of Fish and Wildlife 25	State 5	State Agency 5	https://www.wildlife.ca.gov/Lands/Places-to-Visit/South-Spit-WA	Humboldt 45	609.37	South Spit Wildlife Area	2007	State Conservation Area 8	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]);