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

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

2 rows where COUNTY = 21 and DES_TP = 132

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
5959	5959	5958	{"type": "MultiPolygon", "coordinates": [[[[-120.41296, 38.02114], [-120.41191, 38.02244], [-120.41194, 38.0243], [-120.40958, 38.0243], [-120.40809, 38.02532], [-120.40786, 38.02554], [-120.40687, 38.02704], [-120.40654, 38.02766], [-120.40601, 38.02671], [-120.40595, 38.02642], [-120.40548, 38.02609], [-120.40499, 38.02582], [-120.40496, 38.02557], [-120.40494, 38.02267], [-120.40487, 38.0207], [-120.41188, 38.02066], [-120.4125, 38.02069], [-120.41287, 38.02084], [-120.41261, 38.02103], [-120.41261, 38.02105], [-120.41296, 38.02114]]], [[[-120.40099, 38.03115], [-120.40097, 38.0312], [-120.40052, 38.03104], [-120.40052, 38.03086], [-120.40099, 38.03115]]], [[[-120.406, 38.0309], [-120.40589, 38.03126], [-120.40579, 38.03169], [-120.40555, 38.03194], [-120.40505, 38.03236], [-120.40448, 38.0325], [-120.40437, 38.03183], [-120.40518, 38.03133], [-120.40518, 38.03132], [-120.40506, 38.03122], [-120.40529, 38.03111], [-120.40544, 38.03119], [-120.406, 38.0309]]], [[[-120.40389, 38.03338], [-120.40324, 38.03329], [-120.40319, 38.0332], [-120.40339, 38.03313], [-120.4035, 38.03325], [-120.40385, 38.03326], [-120.40389, 38.03338]]], [[[-120.40185, 38.03383], [-120.40183, 38.03425], [-120.40145, 38.03426], [-120.4014, 38.03429], [-120.401, 38.03432], [-120.40104, 38.03412], [-120.40154, 38.03388], [-120.40185, 38.03383]]], [[[-120.40082, 38.03436], [-120.40082, 38.03447], [-120.40078, 38.03487], [-120.4, 38.03481], [-120.40001, 38.03444], [-120.40027, 38.03443], [-120.40082, 38.03436]]], [[[-120.40182, 38.03432], [-120.40175, 38.03495], [-120.40097, 38.03487], [-120.40101, 38.03439], [-120.40147, 38.03434], [-120.40182, 38.03432]]], [[[-120.40313, 38.03311], [-120.40301, 38.0335], [-120.40291, 38.03404], [-120.40287, 38.03414], [-120.40285, 38.0343], [-120.40268, 38.03503], [-120.40224, 38.035], [-120.40189, 38.03495], [-120.40194, 38.03453], [-120.40202, 38.03415], [-120.40202, 38.03403], [-120.40214, 38.03385], [-120.40255, 38.03349], [-120.40313, 38.03311]]], [[[-120.40376, 38.03476], [-120.40374, 38.03517], [-120.40351, 38.03514], [-120.40359, 38.03475], [-120.40376, 38.03476]]], [[[-120.40378, 38.03265], [-120.40354, 38.03271], [-120.40315, 38.03283], [-120.40252, 38.03325], [-120.40197, 38.03366], [-120.40185, 38.03367], [-120.40149, 38.03377], [-120.40109, 38.03397], [-120.40103, 38.03354], [-120.40085, 38.03355], [-120.40088, 38.034], [-120.40031, 38.03401], [-120.4001, 38.03403], [-120.40001, 38.03406], [-120.40001, 38.03417], [-120.40032, 38.03411], [-120.40087, 38.03409], [-120.40083, 38.0343], [-120.40001, 38.03437], [-120.39997, 38.03432], [-120.39944, 38.03434], [-120.39869, 38.03433], [-120.39873, 38.03409], [-120.39862, 38.03406], [-120.3986, 38.03421], [-120.3986, 38.03446], [-120.39896, 38.03447], [-120.39992, 38.03441], [-120.39993, 38.03456], [-120.39971, 38.03457], [-120.3997, 38.03471], [-120.39934, 38.03469], [-120.39921, 38.03467], [-120.39869, 38.03463], [-120.39859, 38.03468], [-120.39788, 38.03464], [-120.39787, 38.03469], [-120.39812, 38.0347], [-120.39842, 38.03474], [-120.39838, 38.03517], [-120.39833, 38.0355], [-120.39816, 38.03544], [-120.39752, 38.03529], [-120.39747, 38.03527], [-120.39761, 38.03473], [-120.39771, 38.03471], [-120.39767, 38.03419], [-120.39753, 38.03403], [-120.39675, 38.03279], [-120.39651, 38.03234], [-120.39578, 38.03149], [-120.39589, 38.03148], [-120.39587, 38.02912], [-120.39691, 38.02915], [-120.39697, 38.02921], [-120.39705, 38.02932], [-120.39667, 38.03037], [-120.39663, 38.03072], [-120.39715, 38.0307], [-120.39703, 38.03035], [-120.39724, 38.03028], [-120.39738, 38.0307], [-120.39797, 38.03142], [-120.39803, 38.03146], [-120.39812, 38.03157], [-120.39846, 38.03191], [-120.4, 38.0316], [-120.40048, 38.0316], [-120.40062, 38.03151], [-120.40094, 38.0317], [-120.40117, 38.03172], [-120.4013, 38.03185], [-120.40161, 38.03188], [-120.40166, 38.03212], [-120.40195, 38.03203], [-120.40195, 38.03187], [-120.40204, 38.03187], [-120.40205, 38.03135], [-120.40243, 38.03132], [-120.40268, 38.03109], [-120.40275, 38.03114], [-120.40328, 38.03201], [-120.40308, 38.03204], [-120.40307, 38.03205], [-120.40312, 38.03208], [-120.40324, 38.03207], [-120.4035, 38.0322], [-120.40368, 38.03247], [-120.40378, 38.03265]], [[-120.40198, 38.03226], [-120.40198, 38.03224], [-120.40163, 38.03228], [-120.40129, 38.03235], [-120.40123, 38.03239], [-120.40124, 38.0324], [-120.4016, 38.03236], [-120.40198, 38.03226]]], [[[-120.39979, 38.03489], [-120.39975, 38.03534], [-120.39968, 38.03569], [-120.39902, 38.03557], [-120.39905, 38.03532], [-120.39888, 38.03529], [-120.39894, 38.03479], [-120.39938, 38.03485], [-120.39979, 38.03489]]], [[[-120.40262, 38.03519], [-120.40262, 38.03533], [-120.40246, 38.03584], [-120.4021, 38.03579], [-120.40174, 38.03576], [-120.40177, 38.0356], [-120.40221, 38.03568], [-120.40221, 38.03514], [-120.40262, 38.03519]]], [[[-120.40073, 38.03498], [-120.40069, 38.03518], [-120.40049, 38.03586], [-120.39978, 38.03571], [-120.39988, 38.03506], [-120.40035, 38.03512], [-120.40036, 38.03495], [-120.40073, 38.03498]]], [[[-120.40169, 38.03507], [-120.40167, 38.03538], [-120.40162, 38.03569], [-120.40154, 38.036], [-120.40068, 38.03585], [-120.40092, 38.03501], [-120.40169, 38.03507]]], [[[-120.40201, 38.03593], [-120.40196, 38.03607], [-120.40171, 38.03604], [-120.40172, 38.03588], [-120.40201, 38.03593]]], [[[-120.39961, 38.03603], [-120.39947, 38.03664], [-120.39895, 38.03656], [-120.39907, 38.03627], [-120.39884, 38.03624], [-120.39835, 38.03613], [-120.39841, 38.03587], [-120.3987, 38.03592], [-120.39915, 38.03602], [-120.39927, 38.03574], [-120.3994, 38.03576], [-120.39941, 38.03584], [-120.39937, 38.03599], [-120.39961, 38.03603]]], [[[-120.40229, 38.03622], [-120.40224, 38.03671], [-120.40159, 38.03658], [-120.40168, 38.03613], [-120.40229, 38.03622]]], [[[-120.40048, 38.03594], [-120.40018, 38.03677], [-120.39961, 38.03667], [-120.39974, 38.03582], [-120.40048, 38.03594]]], [[[-120.40154, 38.03611], [-120.40136, 38.03698], [-120.40039, 38.03681], [-120.4004, 38.03668], [-120.40065, 38.03596], [-120.40154, 38.03611]]], [[[-120.40021, 38.03695], [-120.40017, 38.03761], [-120.40014, 38.03785], [-120.39981, 38.03787], [-120.39961, 38.03717], [-120.39959, 38.03681], [-120.40021, 38.03695]]], [[[-120.40223, 38.03682], [-120.40209, 38.03721], [-120.402, 38.03754], [-120.40194, 38.03791], [-120.40193, 38.03806], [-120.40156, 38.03946], [-120.40116, 38.04033], [-120.40063, 38.0402], [-120.40026, 38.04007], [-120.40035, 38.03894], [-120.40028, 38.0382], [-120.40029, 38.03771], [-120.40033, 38.03752], [-120.40033, 38.03729], [-120.40037, 38.03718], [-120.40072, 38.03721], [-120.40099, 38.03727], [-120.40147, 38.03744], [-120.40153, 38.03709], [-120.40162, 38.03668], [-120.40194, 38.03674], [-120.40223, 38.03682]]], [[[-120.40014, 38.03867], [-120.39956, 38.03892], [-120.39933, 38.03845], [-120.39931, 38.03837], [-120.399, 38.03846], [-120.39895, 38.03825], [-120.39893, 38.03825], [-120.39898, 38.03894], [-120.39786, 38.03928], [-120.39782, 38.03939], [-120.39786, 38.03975], [-120.39784, 38.04056], [-120.3981, 38.04056], [-120.39668, 38.04166], [-120.39604, 38.04212], [-120.39605, 38.0409], [-120.39603, 38.04064], [-120.39599, 38.0383], [-120.39628, 38.03786], [-120.39661, 38.03765], [-120.39681, 38.03745], [-120.39697, 38.03716], [-120.39696, 38.03715], [-120.39688, 38.03712], [-120.39703, 38.0362], [-120.39764, 38.03627], [-120.39787, 38.03628], [-120.39792, 38.03613], [-120.39825, 38.03616], [-120.39817, 38.03654], [-120.39808, 38.03736], [-120.39816, 38.03738], [-120.39827, 38.03659], [-120.39859, 38.03662], [-120.39838, 38.03744], [-120.39849, 38.03748], [-120.39885, 38.03755], [-120.39902, 38.03674], [-120.39946, 38.03682], [-120.39946, 38.03721], [-120.39949, 38.03736], [-120.3996, 38.03764], [-120.39971, 38.03795], [-120.39931, 38.03803], [-120.39924, 38.03775], [-120.39924, 38.03767], [-120.39914, 38.03747], [-120.39885, 38.03756], [-120.39888, 38.03792], [-120.39892, 38.03815], [-120.39926, 38.03809], [-120.39938, 38.03805], [-120.39943, 38.03832], [-120.39982, 38.03819], [-120.40012, 38.03816], [-120.40014, 38.03867]]], [[[-120.39738, 38.04545], [-120.39735, 38.04583], [-120.39722, 38.04596], [-120.39692, 38.04564], [-120.39707, 38.04556], [-120.39738, 38.04545]]], [[[-120.39611, 38.04602], [-120.39568, 38.04612], [-120.39555, 38.04616], [-120.39547, 38.04621], [-120.39527, 38.04641], [-120.39479, 38.04708], [-120.39407, 38.04647], [-120.39411, 38.04642], [-120.39432, 38.04631], [-120.39461, 38.04608], [-120.39471, 38.04602], [-120.39511, 38.04582], [-120.39517, 38.0458], [-120.39581, 38.04546], [-120.39609, 38.04534], [-120.39611, 38.04602]]], [[[-120.40087, 38.04556], [-120.40082, 38.04598], [-120.40059, 38.046], [-120.40055, 38.05333], [-120.39616, 38.05338], [-120.39612, 38.04786], [-120.39601, 38.04788], [-120.39573, 38.04798], [-120.39552, 38.04807], [-120.39529, 38.04822], [-120.3952, 38.04832], [-120.39484, 38.04894], [-120.39432, 38.04926], [-120.39403, 38.04894], [-120.39448, 38.04849], [-120.39455, 38.04825], [-120.39458, 38.04803], [-120.39466, 38.0479], [-120.39476, 38.04763], [-120.39487, 38.04743], [-120.39526, 38.04709], [-120.39544, 38.04712], [-120.39559, 38.04717], [-120.39577, 38.04704], [-120.39593, 38.04687], [-120.39609, 38.04674], [-120.39657, 38.04707], [-120.39736, 38.04698], [-120.3976, 38.04599], [-120.39785, 38.046], [-120.39766, 38.04534], [-120.39796, 38.04517], [-120.39824, 38.04499], [-120.39989, 38.04568], [-120.40008, 38.04554], [-120.40031, 38.04547], [-120.40056, 38.04546], [-120.40087, 38.04556]]]]}	Open Access 1	530	Columbia State Historic Park	1483	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/default.asp?page_id=552	Tuolumne 21	277.427	Columbia SHP	1946	State Historic or Cultural Area 132	4
5968	5968	5967	{"type": "MultiPolygon", "coordinates": [[[[-120.41818, 37.94816], [-120.41813, 37.94932], [-120.41806, 37.95236], [-120.41787, 37.95236], [-120.41787, 37.95204], [-120.41789, 37.95195], [-120.41788, 37.95181], [-120.41785, 37.95165], [-120.41678, 37.9511], [-120.41636, 37.95086], [-120.41561, 37.9507], [-120.4149, 37.95048], [-120.41488, 37.94984], [-120.41569, 37.94982], [-120.41568, 37.94894], [-120.41563, 37.94836], [-120.41567, 37.94814], [-120.41695, 37.94817], [-120.41771, 37.94818], [-120.41818, 37.94816]]], [[[-120.41871, 37.95345], [-120.41837, 37.95344], [-120.41832, 37.95273], [-120.41827, 37.95255], [-120.41863, 37.95256], [-120.41869, 37.95279], [-120.41871, 37.95345]]], [[[-120.41871, 37.95354], [-120.41871, 37.95377], [-120.41859, 37.95379], [-120.41858, 37.95444], [-120.41852, 37.95444], [-120.41851, 37.95376], [-120.41837, 37.95375], [-120.41837, 37.95355], [-120.41871, 37.95354]]], [[[-120.41876, 37.95476], [-120.41842, 37.95474], [-120.4184, 37.95457], [-120.41875, 37.95457], [-120.41876, 37.95476]]]]}	Open Access 1	540	Railtown 1897 State Historic Park	1701	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=491	Tuolumne 21	20.748	Railtown 1897 SHP	1982	State Historic or Cultural Area 132	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]);