calands: units_with_maps: 2 rows where COUNTY = 36 and DES

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

2 rows where COUNTY = 36 and DES_TP = 39

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
8105	8105	8104	{"type": "Polygon", "coordinates": [[[-118.90767, 34.78905], [-118.90757, 34.79947], [-118.89858, 34.79949], [-118.89846, 34.79591], [-118.89136, 34.7959], [-118.88534, 34.79582], [-118.88555, 34.79909], [-118.88494, 34.79799], [-118.88038, 34.7886], [-118.89876, 34.7886], [-118.89887, 34.78849], [-118.89887, 34.78888], [-118.90767, 34.78905]]]}	Open Access 1	12197	Hungry Valley State Vehicular Recreation Area	1574	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/?page_id=405	Kern 36	545.61	Hungry Valley SVRA	1978	State Recreation Area 39	4
16695	16695	16694	{"type": "MultiPolygon", "coordinates": [[[[-118.0362, 35.3479], [-118.03618, 35.35503], [-118.03587, 35.36078], [-118.02227, 35.36093], [-118.02225, 35.37268], [-118.01273, 35.37258], [-118.01328, 35.37135], [-118.00941, 35.36101], [-118.01842, 35.36095], [-118.01852, 35.35432], [-118.0184, 35.34711], [-118.00965, 35.34718], [-118.00429, 35.34742], [-118.00073, 35.33791], [-118.00063, 35.33312], [-118.00952, 35.33307], [-118.01847, 35.33272], [-118.01855, 35.32552], [-118.01823, 35.31888], [-118.01917, 35.31887], [-118.01978, 35.31939], [-118.02019, 35.32032], [-118.02142, 35.32138], [-118.02182, 35.32229], [-118.02158, 35.32309], [-118.0221, 35.32467], [-118.02217, 35.325], [-118.02218, 35.32533], [-118.02214, 35.32567], [-118.02207, 35.32591], [-118.02158, 35.32705], [-118.02268, 35.32825], [-118.02374, 35.33163], [-118.02405, 35.33299], [-118.01847, 35.33272], [-118.01836, 35.33991], [-118.0184, 35.3471], [-118.02733, 35.34786], [-118.0362, 35.3479]]], [[[-118.00343, 35.34746], [-118.00094, 35.34757], [-118.00078, 35.34039], [-118.00343, 35.34746], [-118.00343, 35.34746]]], [[[-118.01051, 35.30115], [-118.00788, 35.3084], [-118.00787, 35.30831], [-118.00345, 35.30826], [-118.00343, 35.30111], [-118.01051, 35.30115]]], [[[-118.00662, 35.31188], [-118.00533, 35.31544], [-118.00347, 35.31541], [-118.00346, 35.31184], [-118.00662, 35.31188]]], [[[-118.017, 35.31562], [-118.0062, 35.31545], [-118.00749, 35.31189], [-118.00789, 35.31189], [-118.00788, 35.3108], [-118.01138, 35.30115], [-118.01402, 35.30116], [-118.01553, 35.30397], [-118.01532, 35.31007], [-118.01532, 35.3106], [-118.01537, 35.31112], [-118.01541, 35.31138], [-118.01552, 35.3119], [-118.01568, 35.31241], [-118.01588, 35.31291], [-118.01691, 35.31526], [-118.017, 35.31562]]], [[[-118.01239, 35.37133], [-118.01184, 35.37257], [-118.00878, 35.37255], [-118.00868, 35.36143], [-118.01239, 35.37133]]], [[[-118.02119, 35.30119], [-118.02116, 35.31568], [-118.01768, 35.31563], [-118.01756, 35.31511], [-118.01651, 35.31272], [-118.01632, 35.31226], [-118.01618, 35.31179], [-118.01607, 35.31131], [-118.01604, 35.31106], [-118.01599, 35.31058], [-118.01599, 35.31009], [-118.0162, 35.30387], [-118.01476, 35.30116], [-118.02119, 35.30119]]], [[[-118.04909, 35.30498], [-118.04812, 35.30564], [-118.04669, 35.30749], [-118.0444, 35.31531], [-118.04461, 35.31878], [-118.03596, 35.3188], [-118.03604, 35.32597], [-118.0361, 35.33319], [-118.04328, 35.33335], [-118.04322, 35.3337], [-118.04311, 35.33409], [-118.04296, 35.33448], [-118.04279, 35.33479], [-118.04263, 35.33502], [-118.04241, 35.33531], [-118.04172, 35.33603], [-118.04147, 35.33633], [-118.04115, 35.33682], [-118.04101, 35.33707], [-118.04085, 35.33741], [-118.04067, 35.33795], [-118.04055, 35.33849], [-118.04051, 35.3389], [-118.04052, 35.33942], [-118.04048, 35.33975], [-118.04043, 35.34007], [-118.0401, 35.34073], [-118.03956, 35.34158], [-118.03922, 35.34216], [-118.03892, 35.34275], [-118.03874, 35.34316], [-118.03843, 35.34397], [-118.03825, 35.3446], [-118.03811, 35.34522], [-118.03799, 35.34595], [-118.0377, 35.34568], [-118.03616, 35.34415], [-118.0361, 35.3332], [-118.02709, 35.33314], [-118.02473, 35.33303], [-118.0244, 35.33151], [-118.0233, 35.32801], [-118.02233, 35.32696], [-118.02271, 35.32606], [-118.02282, 35.32566], [-118.02285, 35.32536], [-118.02284, 35.32495], [-118.02278, 35.32464], [-118.02227, 35.32308], [-118.02251, 35.32226], [-118.022, 35.32109], [-118.02078, 35.32002], [-118.02036, 35.31909], [-118.02008, 35.31885], [-118.02724, 35.31874], [-118.03595, 35.31879], [-118.0361, 35.31156], [-118.03621, 35.30399], [-118.02722, 35.30437], [-118.02802, 35.29647], [-118.01931, 35.29651], [-118.02018, 35.28868], [-118.03743, 35.28886], [-118.03621, 35.30399], [-118.04521, 35.30501], [-118.04909, 35.30498]]], [[[-118.28957, 35.42176], [-118.27153, 35.42156], [-118.27123, 35.40692], [-118.25332, 35.40691], [-118.25358, 35.42148], [-118.24466, 35.42139], [-118.24483, 35.42866], [-118.23591, 35.4286], [-118.2359, 35.42861], [-118.23608, 35.43584], [-118.25392, 35.43605], [-118.25422, 35.45063], [-118.23638, 35.45036], [-118.23607, 35.43584], [-118.21823, 35.43565], [-118.2183, 35.43927], [-118.21385, 35.43922], [-118.21377, 35.4356], [-118.21822, 35.43564], [-118.21789, 35.42119], [-118.20013, 35.42101], [-118.20042, 35.43545], [-118.20487, 35.43551], [-118.20495, 35.43912], [-118.2094, 35.43917], [-118.20957, 35.4464], [-118.21402, 35.44645], [-118.2141, 35.45002], [-118.2024, 35.44985], [-118.2024, 35.44986], [-118.20245, 35.44988], [-118.20234, 35.44984], [-118.20074, 35.44982], [-118.20073, 35.44926], [-118.20071, 35.44924], [-118.20073, 35.44923], [-118.20041, 35.43546], [-118.18259, 35.4352], [-118.18292, 35.44955], [-118.16511, 35.44928], [-118.16483, 35.43492], [-118.14695, 35.43469], [-118.1467, 35.42036], [-118.12889, 35.42022], [-118.12908, 35.4345], [-118.1114, 35.43428], [-118.11158, 35.44848], [-118.09373, 35.44821], [-118.09364, 35.43411], [-118.07589, 35.4334], [-118.07588, 35.43341], [-118.07588, 35.44794], [-118.06231, 35.44774], [-118.05803, 35.44774], [-118.05815, 35.43325], [-118.07588, 35.43339], [-118.07592, 35.41887], [-118.05827, 35.41875], [-118.05837, 35.40428], [-118.07597, 35.40432], [-118.07601, 35.38978], [-118.05846, 35.38979], [-118.05858, 35.37529], [-118.04025, 35.37531], [-118.03977, 35.38255], [-118.03055, 35.3835], [-118.03059, 35.38305], [-118.03182, 35.38103], [-118.03189, 35.38083], [-118.03192, 35.38065], [-118.03191, 35.38044], [-118.03184, 35.38011], [-118.03185, 35.38], [-118.03188, 35.37986], [-118.03198, 35.37967], [-118.03264, 35.37878], [-118.03279, 35.37851], [-118.03292, 35.37815], [-118.03305, 35.37745], [-118.03313, 35.37727], [-118.03326, 35.3771], [-118.03459, 35.37599], [-118.03486, 35.3757], [-118.04024, 35.3753], [-118.04031, 35.36929], [-118.04272, 35.36733], [-118.04333, 35.36582], [-118.04389, 35.36287], [-118.04623, 35.36082], [-118.05868, 35.36076], [-118.05861, 35.35361], [-118.06717, 35.35358], [-118.06675, 35.34644], [-118.07496, 35.34641], [-118.07533, 35.33214], [-118.05837, 35.33215], [-118.05821, 35.31783], [-118.07503, 35.31785], [-118.07533, 35.33214], [-118.09218, 35.33396], [-118.09141, 35.34866], [-118.07497, 35.34642], [-118.07651, 35.3607], [-118.09144, 35.3633], [-118.09136, 35.37053], [-118.09151, 35.3778], [-118.10945, 35.37742], [-118.11393, 35.37742], [-118.11466, 35.38454], [-118.11022, 35.38453], [-118.111, 35.39163], [-118.12852, 35.3917], [-118.12824, 35.38813], [-118.13711, 35.38815], [-118.13735, 35.39172], [-118.12853, 35.3917], [-118.12869, 35.40595], [-118.1464, 35.40603], [-118.14623, 35.39531], [-118.15062, 35.39534], [-118.15069, 35.39892], [-118.15509, 35.39896], [-118.15516, 35.40255], [-118.15956, 35.40259], [-118.15949, 35.399], [-118.16405, 35.39905], [-118.16421, 35.40624], [-118.18198, 35.40639], [-118.18168, 35.39198], [-118.1639, 35.39186], [-118.16356, 35.37747], [-118.18138, 35.37756], [-118.18169, 35.39198], [-118.19951, 35.3921], [-118.19952, 35.39209], [-118.19922, 35.37765], [-118.21707, 35.37774], [-118.21732, 35.39223], [-118.19952, 35.39211], [-118.1998, 35.40655], [-118.2176, 35.40671], [-118.2179, 35.42119], [-118.23572, 35.42129], [-118.23544, 35.40676], [-118.25332, 35.4069], [-118.25305, 35.39233], [-118.23517, 35.39224], [-118.23492, 35.37773], [-118.25278, 35.37771], [-118.25306, 35.39232], [-118.271, 35.39226], [-118.27078, 35.37763], [-118.28847, 35.37768], [-118.28937, 35.39241], [-118.27101, 35.39226], [-118.27112, 35.39959], [-118.26655, 35.3996], [-118.26661, 35.40324], [-118.27118, 35.40325], [-118.27125, 35.40692], [-118.28945, 35.40707], [-118.28957, 35.42176]], [[-118.07498, 35.37161], [-118.07549, 35.36797], [-118.07128, 35.36799], [-118.0709, 35.37162], [-118.07498, 35.37161]], [[-118.07601, 35.38977], [-118.09351, 35.39185], [-118.0915, 35.3778], [-118.08247, 35.37781], [-118.07449, 35.37525], [-118.07601, 35.38977]], [[-118.12888, 35.42022], [-118.12889, 35.42021], [-118.12868, 35.40595], [-118.11114, 35.40585], [-118.11099, 35.39163], [-118.09353, 35.39185], [-118.09352, 35.39529], [-118.08039, 35.39391], [-118.08037, 35.40473], [-118.07597, 35.40433], [-118.07593, 35.41887], [-118.0936, 35.42003], [-118.09356, 35.40593], [-118.09808, 35.40589], [-118.09809, 35.40933], [-118.10247, 35.40938], [-118.1025, 35.41309], [-118.10693, 35.41309], [-118.10693, 35.41651], [-118.11122, 35.41657], [-118.11126, 35.42006], [-118.12888, 35.42022]], [[-118.11125, 35.42007], [-118.09361, 35.42004], [-118.09365, 35.43411], [-118.11139, 35.43428], [-118.11125, 35.42007]], [[-118.16452, 35.42058], [-118.16453, 35.42057], [-118.1642, 35.40624], [-118.14641, 35.40603], [-118.14672, 35.42036], [-118.16452, 35.42058]], [[-118.18232, 35.42081], [-118.16454, 35.42058], [-118.16484, 35.43491], [-118.18258, 35.4352], [-118.18232, 35.42081]], [[-118.20012, 35.42101], [-118.20013, 35.421], [-118.1998, 35.40656], [-118.18199, 35.4064], [-118.18232, 35.4208], [-118.20012, 35.42101]]], [[[-118.0542, 35.34845], [-118.04002, 35.348], [-118.03993, 35.34784], [-118.03976, 35.34746], [-118.03964, 35.34729], [-118.03951, 35.34712], [-118.03924, 35.34688], [-118.03861, 35.34642], [-118.0387, 35.34562], [-118.03882, 35.34502], [-118.03898, 35.34442], [-118.03925, 35.34363], [-118.03949, 35.34305], [-118.03978, 35.34248], [-118.0401, 35.34192], [-118.04065, 35.34105], [-118.04087, 35.34064], [-118.04107, 35.34021], [-118.04114, 35.33986], [-118.04118, 35.33944], [-118.04118, 35.33891], [-118.04121, 35.33858], [-118.04131, 35.33809], [-118.04147, 35.33762], [-118.04173, 35.33708], [-118.04202, 35.33665], [-118.04225, 35.33636], [-118.043, 35.33557], [-118.04325, 35.33525], [-118.04342, 35.33498], [-118.0436, 35.33463], [-118.04377, 35.33419], [-118.04386, 35.33381], [-118.04393, 35.33336], [-118.04481, 35.33338], [-118.05384, 35.33371], [-118.0542, 35.34845]]], [[[-118.05422, 35.30494], [-118.05421, 35.319], [-118.04939, 35.31888], [-118.04942, 35.31538], [-118.0451, 35.31527], [-118.04732, 35.30771], [-118.04863, 35.30601], [-118.05015, 35.30497], [-118.05422, 35.30494]]], [[[-118.1458, 35.38458], [-118.13688, 35.38457], [-118.13664, 35.38101], [-118.13216, 35.381], [-118.13189, 35.37743], [-118.14543, 35.37743], [-118.1458, 35.38458]]]]}	Open Access 1	47036	Eastern Kern County Onyx Ranch State Vehicular Recreation Area	30689	204	California Department of Parks and Recreation 48	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://ohv.parks.ca.gov/?page_id=28617	Kern 36	25130.205	Eastern Kern County Onyx Ranch SVRA	2014	State Recreation Area 39	4

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