calands: units_with_maps: 1 row where COUNTY = 37 and DES

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

1 row where COUNTY = 37 and DES_TP = 13

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
16789	16789	16788	{"type": "MultiPolygon", "coordinates": [[[[-120.74252, 37.27339], [-120.73801, 37.28775], [-120.73803, 37.29353], [-120.72413, 37.29258], [-120.72414, 37.28789], [-120.71512, 37.28784], [-120.71515, 37.2805], [-120.70615, 37.28052], [-120.70625, 37.26775], [-120.70642, 37.25213], [-120.70653, 37.25216], [-120.70654, 37.25215], [-120.70641, 37.2521], [-120.70645, 37.2499], [-120.70639, 37.24428], [-120.70665, 37.24428], [-120.70702, 37.24491], [-120.70732, 37.24525], [-120.71901, 37.2545], [-120.72423, 37.25905], [-120.73083, 37.26454], [-120.73586, 37.26762], [-120.74252, 37.27339]]], [[[-120.85194, 37.24763], [-120.85193, 37.24991], [-120.8519, 37.25195], [-120.85118, 37.25691], [-120.8512, 37.26022], [-120.85118, 37.27587], [-120.85119, 37.29287], [-120.85117, 37.29466], [-120.85051, 37.29446], [-120.84875, 37.29431], [-120.84796, 37.29407], [-120.84712, 37.29378], [-120.84611, 37.29362], [-120.84403, 37.29454], [-120.84249, 37.29477], [-120.84174, 37.29435], [-120.84255, 37.2932], [-120.84234, 37.29211], [-120.84212, 37.29197], [-120.84232, 37.29178], [-120.84266, 37.2917], [-120.84287, 37.29154], [-120.84305, 37.29131], [-120.84329, 37.29097], [-120.84436, 37.29066], [-120.84487, 37.28979], [-120.84492, 37.2888], [-120.84475, 37.28831], [-120.84376, 37.28554], [-120.84296, 37.28441], [-120.84333, 37.28298], [-120.84367, 37.28206], [-120.84364, 37.28158], [-120.84265, 37.28125], [-120.8423, 37.28126], [-120.84202, 37.28155], [-120.84084, 37.28229], [-120.8399, 37.2828], [-120.83792, 37.28341], [-120.83728, 37.28345], [-120.83693, 37.2834], [-120.83652, 37.28314], [-120.8353, 37.28266], [-120.83461, 37.28243], [-120.83346, 37.28186], [-120.83313, 37.28166], [-120.83145, 37.28131], [-120.83075, 37.2804], [-120.82988, 37.28012], [-120.82941, 37.28006], [-120.82891, 37.28012], [-120.82781, 37.28071], [-120.82674, 37.28065], [-120.82668, 37.28014], [-120.82746, 37.27962], [-120.82848, 37.27936], [-120.82902, 37.27931], [-120.82951, 37.27916], [-120.83005, 37.27901], [-120.83074, 37.27865], [-120.83166, 37.27853], [-120.83174, 37.27803], [-120.83153, 37.27737], [-120.83071, 37.27651], [-120.82901, 37.27551], [-120.82839, 37.27501], [-120.828, 37.27449], [-120.82758, 37.27416], [-120.82746, 37.27415], [-120.82721, 37.27384], [-120.82694, 37.2734], [-120.8268, 37.27295], [-120.82683, 37.27157], [-120.82699, 37.27105], [-120.82744, 37.27045], [-120.82822, 37.26968], [-120.82884, 37.26958], [-120.82942, 37.26917], [-120.82932, 37.27003], [-120.82952, 37.27116], [-120.82984, 37.2715], [-120.83055, 37.27171], [-120.83143, 37.27151], [-120.83201, 37.27086], [-120.83243, 37.26846], [-120.83273, 37.26788], [-120.8329, 37.26747], [-120.83266, 37.26632], [-120.83229, 37.26584], [-120.83111, 37.26585], [-120.8306, 37.26615], [-120.82954, 37.26657], [-120.82816, 37.26687], [-120.82773, 37.2667], [-120.82766, 37.26637], [-120.82814, 37.26572], [-120.82941, 37.26468], [-120.83006, 37.26402], [-120.83055, 37.26377], [-120.83075, 37.26342], [-120.83091, 37.26296], [-120.83103, 37.26243], [-120.83123, 37.26215], [-120.83134, 37.26163], [-120.83029, 37.26066], [-120.82984, 37.25999], [-120.82979, 37.25963], [-120.82946, 37.25997], [-120.82945, 37.25983], [-120.81555, 37.25869], [-120.81536, 37.27295], [-120.81281, 37.27297], [-120.81034, 37.27066], [-120.80641, 37.26816], [-120.80429, 37.26568], [-120.80294, 37.26417], [-120.80086, 37.2619], [-120.7972, 37.26047], [-120.79462, 37.26047], [-120.79222, 37.2564], [-120.79063, 37.25607], [-120.7898, 37.25668], [-120.7882, 37.25662], [-120.7863, 37.25551], [-120.78269, 37.25634], [-120.77959, 37.25569], [-120.7768, 37.25676], [-120.76999, 37.2572], [-120.76637, 37.25882], [-120.76432, 37.25878], [-120.76431, 37.25882], [-120.76082, 37.25881], [-120.76082, 37.26605], [-120.75626, 37.26611], [-120.7565, 37.27746], [-120.74319, 37.27327], [-120.74299, 37.2732], [-120.7427, 37.27291], [-120.74264, 37.259], [-120.74261, 37.25898], [-120.74259, 37.25155], [-120.74259, 37.24989], [-120.74269, 37.24434], [-120.74267, 37.24043], [-120.74265, 37.22992], [-120.74917, 37.22993], [-120.751, 37.22997], [-120.75999, 37.22993], [-120.76078, 37.22982], [-120.76081, 37.24439], [-120.77891, 37.24433], [-120.77899, 37.22991], [-120.77942, 37.22992], [-120.77943, 37.22991], [-120.77945, 37.22269], [-120.77944, 37.22268], [-120.77912, 37.22269], [-120.77909, 37.22973], [-120.77898, 37.22973], [-120.77903, 37.22281], [-120.77902, 37.21892], [-120.77904, 37.21359], [-120.77974, 37.21321], [-120.78051, 37.21301], [-120.78131, 37.21298], [-120.78217, 37.21315], [-120.7827, 37.21385], [-120.78281, 37.21451], [-120.78336, 37.21478], [-120.7837, 37.21528], [-120.78312, 37.21704], [-120.78341, 37.21808], [-120.78344, 37.21884], [-120.78296, 37.21992], [-120.7831, 37.22054], [-120.78371, 37.22157], [-120.78507, 37.22288], [-120.7854, 37.2229], [-120.78609, 37.22237], [-120.78768, 37.22177], [-120.78963, 37.22157], [-120.79073, 37.22166], [-120.7915, 37.22221], [-120.79242, 37.22255], [-120.79346, 37.22264], [-120.79384, 37.22172], [-120.79529, 37.22218], [-120.79745, 37.22224], [-120.79819, 37.22262], [-120.79904, 37.22276], [-120.79952, 37.22312], [-120.7999, 37.22391], [-120.79999, 37.22457], [-120.80051, 37.22528], [-120.80091, 37.22561], [-120.80208, 37.22604], [-120.80281, 37.22599], [-120.80388, 37.22556], [-120.8043, 37.22564], [-120.80482, 37.22613], [-120.80484, 37.22691], [-120.80491, 37.22787], [-120.80532, 37.22874], [-120.80597, 37.22945], [-120.80642, 37.22977], [-120.80665, 37.22979], [-120.80793, 37.22805], [-120.80897, 37.22843], [-120.80989, 37.22953], [-120.81019, 37.2304], [-120.80994, 37.23241], [-120.80997, 37.2329], [-120.80995, 37.23294], [-120.80996, 37.23295], [-120.83466, 37.21965], [-120.83507, 37.22048], [-120.83537, 37.22099], [-120.83607, 37.22144], [-120.83635, 37.22194], [-120.83628, 37.22285], [-120.83589, 37.22382], [-120.83618, 37.22416], [-120.83666, 37.22434], [-120.83801, 37.22413], [-120.83924, 37.22397], [-120.8399, 37.22384], [-120.84047, 37.22403], [-120.84204, 37.22424], [-120.84265, 37.22455], [-120.84307, 37.22507], [-120.84316, 37.22596], [-120.8429, 37.22701], [-120.84161, 37.22791], [-120.84124, 37.22828], [-120.84101, 37.2288], [-120.84113, 37.22934], [-120.84163, 37.22975], [-120.84299, 37.22997], [-120.8433, 37.23141], [-120.84375, 37.23193], [-120.84443, 37.23229], [-120.84467, 37.23295], [-120.84448, 37.23427], [-120.84441, 37.23468], [-120.84445, 37.235], [-120.84447, 37.23586], [-120.84527, 37.23647], [-120.84603, 37.23636], [-120.84692, 37.23643], [-120.84749, 37.23689], [-120.84773, 37.23721], [-120.84782, 37.23771], [-120.84776, 37.23829], [-120.84772, 37.2388], [-120.84761, 37.23955], [-120.84745, 37.23979], [-120.84696, 37.24014], [-120.84634, 37.24028], [-120.84501, 37.24012], [-120.8443, 37.24082], [-120.84436, 37.24127], [-120.84425, 37.24161], [-120.84397, 37.24265], [-120.84466, 37.24361], [-120.84533, 37.2439], [-120.84672, 37.24387], [-120.84744, 37.24424], [-120.84785, 37.24463], [-120.84846, 37.24507], [-120.84873, 37.24552], [-120.84868, 37.24578], [-120.84831, 37.24618], [-120.84832, 37.2462], [-120.84907, 37.24651], [-120.84919, 37.24655], [-120.84998, 37.24643], [-120.85036, 37.24607], [-120.85075, 37.24582], [-120.85127, 37.24631], [-120.85123, 37.24707], [-120.85137, 37.24739], [-120.85194, 37.24763]], [[-120.83487, 37.2587], [-120.83483, 37.25799], [-120.83458, 37.25776], [-120.83409, 37.25753], [-120.83398, 37.25719], [-120.83326, 37.257], [-120.833, 37.25675], [-120.83297, 37.25598], [-120.83266, 37.2557], [-120.83177, 37.25559], [-120.83093, 37.25593], [-120.83093, 37.25633], [-120.83094, 37.25634], [-120.83149, 37.25595], [-120.83206, 37.25591], [-120.83237, 37.256], [-120.83257, 37.25668], [-120.83275, 37.2568], [-120.8328, 37.25696], [-120.83312, 37.25717], [-120.83349, 37.25721], [-120.83383, 37.25737], [-120.83378, 37.25767], [-120.83343, 37.25808], [-120.83346, 37.25824], [-120.83426, 37.2587], [-120.83492, 37.2594], [-120.83518, 37.25941], [-120.83521, 37.25922], [-120.83487, 37.2587]], [[-120.83243, 37.25842], [-120.83243, 37.25767], [-120.8312, 37.25698], [-120.83103, 37.25694], [-120.83094, 37.25696], [-120.83094, 37.25742], [-120.83114, 37.25765], [-120.83123, 37.25835], [-120.83277, 37.25929], [-120.83294, 37.25929], [-120.83289, 37.259], [-120.83243, 37.25842]], [[-120.78869, 37.22995], [-120.78863, 37.22968], [-120.78917, 37.22895], [-120.7892, 37.22851], [-120.78869, 37.22792], [-120.78626, 37.22666], [-120.78285, 37.22599], [-120.7826, 37.22597], [-120.78219, 37.22627], [-120.78194, 37.22663], [-120.78194, 37.22712], [-120.78285, 37.22808], [-120.78299, 37.22842], [-120.78302, 37.22902], [-120.78316, 37.22943], [-120.78351, 37.23009], [-120.78382, 37.23029], [-120.78485, 37.23039], [-120.78537, 37.2305], [-120.78643, 37.23162], [-120.78674, 37.23213], [-120.78711, 37.23298], [-120.78746, 37.23345], [-120.78797, 37.23389], [-120.79009, 37.23474], [-120.79055, 37.2348], [-120.79152, 37.23462], [-120.79223, 37.23435], [-120.79324, 37.23353], [-120.79326, 37.23325], [-120.79232, 37.23243], [-120.79052, 37.23119], [-120.78975, 37.23087], [-120.78909, 37.23043], [-120.78869, 37.22995]]]]}	Restricted Access 2	31036	Grasslands Wildlife Management Area	19449	106	United States Fish and Wildlife Service 45	Federal 1	Federal Agency 1	http://www.fws.gov/	US Fish and Wildlife Service 8	106	United States Fish and Wildlife Service 44	Federal 1	Federal Agency 1		Merced 37	12351.617	Grasslands WMA	1979	Conservation Area 13	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]);