calands: units_with_maps: 10 rows where AGNCY_TYP = 3, DES_TP = 2, MNG_AGENCY = 545 and YR

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

10 rows where AGNCY_TYP = 3, DES_TP = 2, MNG_AGENCY = 545 and YR_EST = 0

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	DES_TP	GAP_STS
2781	2781	2780	{"type": "Polygon", "coordinates": [[[-124.21445, 40.77156], [-124.2134, 40.7727], [-124.21288, 40.77334], [-124.21022, 40.77332], [-124.21322, 40.77091], [-124.21357, 40.77045], [-124.21445, 40.77156]]]}	Open Access 1	21608	Samoa Boat Ramp County Park	30519	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3		Humboldt 45	12.044	Samoa Boat Ramp County Park	Local Park 2	4
3316	3316	3315	{"type": "MultiPolygon", "coordinates": [[[[-124.11554, 40.98526], [-124.11482, 40.98939], [-124.1139, 40.99205], [-124.11328, 40.99308], [-124.11305, 40.99355], [-124.11235, 40.99342], [-124.11214, 40.99293], [-124.11195, 40.99348], [-124.11188, 40.99344], [-124.1118, 40.99337], [-124.11179, 40.99327], [-124.11184, 40.99315], [-124.11196, 40.993], [-124.11209, 40.99287], [-124.11209, 40.99279], [-124.11201, 40.99212], [-124.11194, 40.99179], [-124.11196, 40.99167], [-124.11169, 40.99137], [-124.11135, 40.99082], [-124.11125, 40.9907], [-124.11021, 40.98912], [-124.1104, 40.98913], [-124.11356, 40.98921], [-124.11359, 40.98887], [-124.11172, 40.98595], [-124.11127, 40.98529], [-124.11284, 40.98529], [-124.11554, 40.98526]]], [[[-124.1101, 40.9927], [-124.11013, 40.99039], [-124.11077, 40.9904], [-124.11142, 40.99138], [-124.11163, 40.99163], [-124.11185, 40.99267], [-124.11182, 40.99282], [-124.11173, 40.99291], [-124.11153, 40.99316], [-124.11153, 40.9933], [-124.11157, 40.99346], [-124.11191, 40.99371], [-124.11229, 40.99415], [-124.11238, 40.99434], [-124.11197, 40.9942], [-124.11155, 40.99394], [-124.11106, 40.99357], [-124.11072, 40.99337], [-124.11036, 40.99314], [-124.11011, 40.99306], [-124.1101, 40.9927]]], [[[-124.11253, 40.99492], [-124.1125, 40.99629], [-124.11235, 40.99698], [-124.11014, 40.99694], [-124.11015, 40.99329], [-124.11047, 40.99343], [-124.11077, 40.99358], [-124.111, 40.99378], [-124.11158, 40.99418], [-124.11211, 40.99443], [-124.11239, 40.9945], [-124.11252, 40.9946], [-124.11253, 40.99492]]], [[[-124.12799, 40.95635], [-124.12792, 40.95711], [-124.12754, 40.95802], [-124.12705, 40.95878], [-124.12667, 40.95964], [-124.12598, 40.96113], [-124.1258, 40.96174], [-124.12572, 40.96226], [-124.1255, 40.96276], [-124.1254, 40.96332], [-124.12539, 40.96377], [-124.12473, 40.96575], [-124.124, 40.96809], [-124.12261, 40.97101], [-124.12089, 40.97536], [-124.1205, 40.97811], [-124.12029, 40.98041], [-124.11816, 40.98046], [-124.11779, 40.98205], [-124.12014, 40.982], [-124.11935, 40.98526], [-124.11842, 40.98926], [-124.11778, 40.99153], [-124.1173, 40.99425], [-124.11721, 40.99439], [-124.11715, 40.9946], [-124.11718, 40.99501], [-124.11692, 40.99575], [-124.11676, 40.9963], [-124.11664, 40.99644], [-124.11664, 40.99676], [-124.11647, 40.99779], [-124.11616, 40.99931], [-124.11613, 40.99977], [-124.116, 41.0004], [-124.11584, 41.00151], [-124.11552, 41.00338], [-124.11518, 41.0051], [-124.11492, 41.00587], [-124.11479, 41.00679], [-124.11381, 41.00676], [-124.11166, 41.00675], [-124.11202, 41.00575], [-124.11257, 41.00368], [-124.11309, 41.00035], [-124.11346, 40.99776], [-124.11345, 40.99775], [-124.11316, 40.99775], [-124.1136, 40.99545], [-124.11438, 40.99282], [-124.11473, 40.99282], [-124.11472, 40.99264], [-124.11512, 40.99162], [-124.11587, 40.98928], [-124.11684, 40.9853], [-124.11683, 40.98529], [-124.11659, 40.9853], [-124.11757, 40.98077], [-124.11775, 40.97935], [-124.11776, 40.97838], [-124.11761, 40.97571], [-124.11856, 40.9709], [-124.11884, 40.97091], [-124.12008, 40.96751], [-124.12054, 40.96633], [-124.12079, 40.96562], [-124.1209, 40.96506], [-124.12084, 40.96415], [-124.12107, 40.96259], [-124.12139, 40.96171], [-124.1213, 40.96168], [-124.12179, 40.96025], [-124.12239, 40.95866], [-124.12262, 40.95793], [-124.12278, 40.95701], [-124.12297, 40.95632], [-124.12799, 40.95635]]]]}	Open Access 1	29672	Clam Beach County Park	4510	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/default.asp?parkID=CLAM	Humboldt 45	462.281	Clam Beach County Park	Local Park 2	4
3317	3317	3316	{"type": "Polygon", "coordinates": [[[-124.1405, 40.9168], [-124.13948, 40.91945], [-124.13918, 40.92099], [-124.13862, 40.92235], [-124.13723, 40.92536], [-124.1361, 40.92829], [-124.13591, 40.92864], [-124.13588, 40.92955], [-124.1358, 40.93084], [-124.13559, 40.93173], [-124.13514, 40.93311], [-124.135, 40.93361], [-124.13459, 40.93468], [-124.13457, 40.93442], [-124.13005, 40.93436], [-124.13004, 40.93449], [-124.12991, 40.9342], [-124.12991, 40.93361], [-124.12993, 40.93336], [-124.12993, 40.93311], [-124.13003, 40.93278], [-124.13008, 40.93251], [-124.13002, 40.93218], [-124.12999, 40.93184], [-124.12972, 40.9315], [-124.12972, 40.9312], [-124.12966, 40.93091], [-124.12956, 40.92928], [-124.12961, 40.92819], [-124.12975, 40.92698], [-124.13003, 40.92698], [-124.12996, 40.9278], [-124.12996, 40.92822], [-124.13013, 40.92835], [-124.13075, 40.92864], [-124.13105, 40.92873], [-124.13128, 40.92879], [-124.13189, 40.92884], [-124.13227, 40.92893], [-124.13306, 40.9292], [-124.13326, 40.92933], [-124.13343, 40.92951], [-124.13347, 40.9294], [-124.13357, 40.92927], [-124.13412, 40.92958], [-124.13494, 40.9274], [-124.13702, 40.92214], [-124.1392, 40.91654], [-124.1405, 40.9168]]]}	Open Access 1	29674	Mad River County Park	21640	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3		Humboldt 45	116.352	Mad River County Park	Local Park 2	4
3660	3660	3659	{"type": "Polygon", "coordinates": [[[-124.05116, 40.7557], [-124.05103, 40.75618], [-124.04968, 40.75812], [-124.04942, 40.75783], [-124.0492, 40.75749], [-124.04903, 40.75714], [-124.04894, 40.75682], [-124.04935, 40.75622], [-124.04959, 40.75585], [-124.04975, 40.75546], [-124.04981, 40.75519], [-124.0507, 40.75519], [-124.05116, 40.7557]]]}	Open Access 1	46916	Freshwater Park	30520	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/default.asp?parkID=FP	Humboldt 45	8.276	Freshwater Park	Local Park 2	4
12235	12235	12234	{"type": "Polygon", "coordinates": [[[-124.35159, 40.57354], [-124.35147, 40.57383], [-124.35065, 40.57366], [-124.35064, 40.57382], [-124.3494, 40.57383], [-124.34941, 40.57334], [-124.35087, 40.57312], [-124.35076, 40.57344], [-124.35159, 40.57354]]]}	Open Access 1	25766	Centerville Beach	17041	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3		Humboldt 45	2.34	Centerville Beach	Local Park 2	4
12250	12250	12249	{"type": "Polygon", "coordinates": [[[-123.98647, 40.49898], [-123.98241, 40.49898], [-123.97733, 40.49932], [-123.9773, 40.4995], [-123.97607, 40.49958], [-123.97481, 40.49962], [-123.97472, 40.49964], [-123.97325, 40.4994], [-123.97166, 40.49876], [-123.97059, 40.49784], [-123.97027, 40.49748], [-123.96992, 40.49649], [-123.96947, 40.49486], [-123.96915, 40.49332], [-123.96936, 40.49281], [-123.96941, 40.49162], [-123.96928, 40.4893], [-123.96926, 40.48925], [-123.96865, 40.48863], [-123.9678, 40.48729], [-123.96424, 40.48356], [-123.9651, 40.48276], [-123.96537, 40.48234], [-123.96645, 40.48135], [-123.96749, 40.48067], [-123.96847, 40.4811], [-123.96835, 40.48206], [-123.96841, 40.48325], [-123.96842, 40.48452], [-123.96814, 40.48581], [-123.9682, 40.48695], [-123.96854, 40.48777], [-123.96878, 40.48789], [-123.97058, 40.48784], [-123.9724, 40.48728], [-123.97416, 40.48663], [-123.97595, 40.48657], [-123.97741, 40.48698], [-123.97872, 40.48785], [-123.97866, 40.48895], [-123.9771, 40.48895], [-123.97454, 40.48917], [-123.9726, 40.49005], [-123.97195, 40.49104], [-123.97175, 40.49173], [-123.97174, 40.49269], [-123.97193, 40.49387], [-123.9721, 40.49487], [-123.97299, 40.49584], [-123.974, 40.49668], [-123.97488, 40.49747], [-123.97611, 40.49812], [-123.97683, 40.4987], [-123.97767, 40.49848], [-123.97942, 40.49699], [-123.98167, 40.49559], [-123.98244, 40.49577], [-123.98336, 40.49653], [-123.98467, 40.49758], [-123.98544, 40.49776], [-123.98593, 40.49717], [-123.98641, 40.49678], [-123.98651, 40.49858], [-123.98647, 40.49898]]]}	Open Access 1	25767	Van Duzen Park	4515	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3	http://www.humboldtgov.org/1592/County-Parks-Facilities	Humboldt 45	212.133	Van Duzen Park	Local Park 2	4
12693	12693	12692	{"type": "MultiPolygon", "coordinates": [[[[-124.11352, 41.03153], [-124.11281, 41.03154], [-124.1125, 41.03149], [-124.11199, 41.03171], [-124.11142, 41.03101], [-124.11142, 41.03073], [-124.11175, 41.03043], [-124.11175, 41.03018], [-124.11109, 41.03014], [-124.11109, 41.02998], [-124.11142, 41.03006], [-124.11152, 41.03006], [-124.11161, 41.03002], [-124.11164, 41.02993], [-124.11161, 41.02986], [-124.1115, 41.02976], [-124.11194, 41.02927], [-124.11252, 41.02921], [-124.11268, 41.02967], [-124.11292, 41.02999], [-124.11297, 41.03043], [-124.11352, 41.03153]]], [[[-124.11154, 41.02993], [-124.11152, 41.02998], [-124.11143, 41.02999], [-124.11111, 41.02991], [-124.11137, 41.02992], [-124.11145, 41.02982], [-124.1115, 41.02986], [-124.11154, 41.02993]]]]}	Open Access 1	29670	Moonstone Beach County Park	22454	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3		Humboldt 45	7.599	Moonstone Beach County Park	Local Park 2	4
14293	14293	14292	{"type": "Polygon", "coordinates": [[[-124.23254, 40.26773], [-124.2322, 40.26879], [-124.2322, 40.26882], [-124.23085, 40.26907], [-124.23083, 40.26963], [-124.22952, 40.26963], [-124.22932, 40.26935], [-124.22906, 40.2691], [-124.22878, 40.26892], [-124.22853, 40.2688], [-124.22824, 40.26872], [-124.22783, 40.26872], [-124.22766, 40.26887], [-124.22753, 40.26908], [-124.22742, 40.2694], [-124.22737, 40.26964], [-124.22653, 40.26964], [-124.22663, 40.26911], [-124.22669, 40.2689], [-124.22677, 40.26883], [-124.22695, 40.26874], [-124.22713, 40.26859], [-124.22729, 40.26842], [-124.22743, 40.26818], [-124.22764, 40.26797], [-124.22769, 40.2677], [-124.22769, 40.26741], [-124.22774, 40.26713], [-124.22776, 40.26676], [-124.22796, 40.2665], [-124.22833, 40.26628], [-124.22869, 40.2662], [-124.23016, 40.26621], [-124.23062, 40.26624], [-124.23162, 40.26643], [-124.23196, 40.26648], [-124.2323, 40.26669], [-124.23243, 40.2669], [-124.23252, 40.26726], [-124.23254, 40.26773]]]}	Open Access 1	44227	Arthur W. Way Park	15641	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3		Humboldt 45	33.368	Arthur W. Way Park	Local Park 2	4
14296	14296	14295	{"type": "Polygon", "coordinates": [[[-123.79899, 40.09038], [-123.79816, 40.09043], [-123.79723, 40.09053], [-123.79654, 40.09066], [-123.79587, 40.09113], [-123.79544, 40.08958], [-123.79611, 40.08922], [-123.79669, 40.08901], [-123.79717, 40.08896], [-123.79765, 40.0889], [-123.79809, 40.08892], [-123.79853, 40.08904], [-123.79868, 40.08913], [-123.79883, 40.08954], [-123.79898, 40.09026], [-123.79899, 40.09038]]]}	Open Access 1	44230	Tooby Memorial Park	26400	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3		Humboldt 45	11.824	Tooby Memorial Park	Local Park 2	4
14918	14918	14917	{"type": "Polygon", "coordinates": [[[-124.13354, 41.16255], [-124.1334, 41.16295], [-124.13222, 41.1637], [-124.13198, 41.1638], [-124.13182, 41.16385], [-124.13171, 41.16386], [-124.13145, 41.16382], [-124.13112, 41.16353], [-124.13059, 41.16298], [-124.13059, 41.16293], [-124.13063, 41.16285], [-124.13182, 41.16266], [-124.13212, 41.1625], [-124.13219, 41.16248], [-124.13249, 41.16255], [-124.13277, 41.16255], [-124.13325, 41.16251], [-124.13354, 41.16255]]]}	Open Access 1	45488	Big Lagoon Park	28318	348	Humboldt, County of 552	County 3	County Agency 3	http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp	County 3	348	Humboldt, County of 545	County 3	County Agency 3	http://www.redwoods.info/showrecord.asp?id=1581	Humboldt 45	5.585	Big Lagoon Park	Local Park 2	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]);