calands: units_with_maps: 4 rows where ACCESS_TYP = 1, AGNCY_NAME = 604 and MNG

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

4 rows where ACCESS_TYP = 1, AGNCY_NAME = 604 and MNG_AGENCY = 593

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
5907	5907	5906	{"type": "Polygon", "coordinates": [[[-121.06313, 38.76897], [-121.063, 38.78367], [-121.04442, 38.78347], [-121.03528, 38.78363], [-121.03172, 38.78365], [-121.03101, 38.78349], [-121.03062, 38.78361], [-121.03056, 38.78366], [-121.03018, 38.78366], [-121.03031, 38.78355], [-121.03046, 38.78347], [-121.03063, 38.78341], [-121.03081, 38.78338], [-121.03105, 38.78339], [-121.03198, 38.78357], [-121.03218, 38.78356], [-121.03238, 38.78351], [-121.03253, 38.78342], [-121.03264, 38.78332], [-121.0327, 38.78321], [-121.03277, 38.78301], [-121.03282, 38.7829], [-121.03291, 38.78279], [-121.03303, 38.78269], [-121.03326, 38.78258], [-121.03436, 38.78226], [-121.03471, 38.78212], [-121.03494, 38.78197], [-121.03512, 38.7818], [-121.03527, 38.78162], [-121.03538, 38.7814], [-121.03545, 38.78114], [-121.03546, 38.78089], [-121.03537, 38.78001], [-121.03533, 38.77972], [-121.03524, 38.77934], [-121.03506, 38.77878], [-121.03503, 38.77865], [-121.03503, 38.77844], [-121.0351, 38.778], [-121.03509, 38.77787], [-121.03505, 38.77773], [-121.03497, 38.7776], [-121.03487, 38.77748], [-121.03475, 38.77737], [-121.03459, 38.77728], [-121.03432, 38.77719], [-121.03365, 38.77709], [-121.0335, 38.77703], [-121.03337, 38.77695], [-121.03326, 38.77681], [-121.03319, 38.77666], [-121.03318, 38.77655], [-121.03321, 38.77623], [-121.0443, 38.77626], [-121.04433, 38.77443], [-121.04566, 38.77464], [-121.04634, 38.77454], [-121.04646, 38.77509], [-121.04578, 38.77583], [-121.0456, 38.77662], [-121.04612, 38.77759], [-121.04686, 38.77789], [-121.04769, 38.77781], [-121.04823, 38.77663], [-121.04941, 38.77578], [-121.04986, 38.77431], [-121.05193, 38.77346], [-121.05274, 38.77289], [-121.05339, 38.77455], [-121.05382, 38.77492], [-121.05405, 38.77539], [-121.0549, 38.77568], [-121.05579, 38.7753], [-121.05608, 38.77364], [-121.05591, 38.77206], [-121.05759, 38.77248], [-121.05837, 38.7723], [-121.05906, 38.77063], [-121.05972, 38.77035], [-121.06003, 38.76924], [-121.06079, 38.76894], [-121.06313, 38.76897]]]}	Open Access 1	47298	Salmon Falls Ranch	31005	3003	American River Conservancy 604	Non Profit 6	Non Profit - Land Trust 10	http://www.arconservancy.org/	Non Governmental Organization 10	3003	American River Conservancy 593	Non Profit 6	Non Profit - Land Trust 10		El Dorado 34	622.913	Salmon Falls Ranch	Private Conservation 16	2
11496	11496	11495	{"type": "Polygon", "coordinates": [[[-121.08536, 38.70069], [-121.0853, 38.70071], [-121.08483, 38.70132], [-121.08466, 38.7015], [-121.08379, 38.70283], [-121.08379, 38.70288], [-121.08377, 38.7029], [-121.08366, 38.70297], [-121.08362, 38.70298], [-121.08357, 38.70297], [-121.08354, 38.70298], [-121.08285, 38.70248], [-121.08283, 38.70233], [-121.08305, 38.70197], [-121.08363, 38.70054], [-121.0837, 38.70015], [-121.08377, 38.70014], [-121.08398, 38.70016], [-121.08437, 38.70024], [-121.08455, 38.70031], [-121.08536, 38.70069]]]}	Open Access 1	23334	Wild Oaks Park	30312	3003	American River Conservancy 604	Non Profit 6	Non Profit - Land Trust 10	http://www.arconservancy.org/	Non Governmental Organization 10	3003	American River Conservancy 593	Non Profit 6	Non Profit - Land Trust 10	http://www.eldoradohillscsd.org/images/park_detail_popups/wild-oaks/index.html	El Dorado 34	8.397	Wild Oaks Park	Private Recreation or Education 65	4
14367	14367	14366	{"type": "Polygon", "coordinates": [[[-120.89575, 38.77206], [-120.89569, 38.7757], [-120.89226, 38.77559], [-120.88668, 38.7755], [-120.88666, 38.77689], [-120.88636, 38.77689], [-120.88533, 38.77673], [-120.8842, 38.77672], [-120.88374, 38.77607], [-120.88346, 38.77538], [-120.8834, 38.77513], [-120.88364, 38.77442], [-120.8838, 38.77408], [-120.88402, 38.77386], [-120.88412, 38.77373], [-120.88422, 38.77354], [-120.88464, 38.7725], [-120.88339, 38.77217], [-120.88247, 38.77199], [-120.88103, 38.7716], [-120.88074, 38.77155], [-120.88022, 38.77076], [-120.87982, 38.77018], [-120.88005, 38.76937], [-120.88022, 38.76839], [-120.87781, 38.76803], [-120.87784, 38.76644], [-120.87907, 38.76639], [-120.87951, 38.76636], [-120.87988, 38.76637], [-120.88248, 38.76627], [-120.88339, 38.76626], [-120.88371, 38.76645], [-120.88383, 38.76683], [-120.88563, 38.76669], [-120.88553, 38.76647], [-120.88536, 38.76627], [-120.88498, 38.76597], [-120.88571, 38.76604], [-120.88809, 38.76659], [-120.88843, 38.76763], [-120.8883, 38.76776], [-120.88845, 38.76799], [-120.88889, 38.76804], [-120.89269, 38.76882], [-120.8928, 38.7691], [-120.89288, 38.76925], [-120.89318, 38.76973], [-120.89326, 38.76973], [-120.89396, 38.77094], [-120.8947, 38.77132], [-120.89538, 38.77175], [-120.89546, 38.77197], [-120.89575, 38.77206]], [[-120.88918, 38.77107], [-120.88858, 38.772], [-120.88999, 38.77375], [-120.89141, 38.77284], [-120.89124, 38.77239], [-120.8911, 38.77213], [-120.89067, 38.77179], [-120.89046, 38.77168], [-120.8901, 38.77139], [-120.88985, 38.77128], [-120.88918, 38.77107]]]}	Open Access 1	44452	Wakamatsu Tea and Silk Colony Farm	29217	3003	American River Conservancy 604	Non Profit 6	Non Profit - Land Trust 10	http://www.arconservancy.org/	Non Governmental Organization 10	3003	American River Conservancy 593	Non Profit 6	Non Profit - Land Trust 10	http://www.arconservancy.org/site/c.psKZL3PFLrF/b.7719191/k.2889/Wakamatsu_Tea_and_Silk_Colony_Farm_historic_site_of_the_first_Japanese_Colony_in_the_United_States.htm	El Dorado 34	263.063	Wakamatsu Tea and Silk Colony Farm	Private Agricultural 354	4
15148	15148	15147	{"type": "MultiPolygon", "coordinates": [[[[-120.41957, 39.20187], [-120.4169, 39.21534], [-120.4075, 39.2155], [-120.39824, 39.21551], [-120.40113, 39.22913], [-120.38195, 39.22954], [-120.37973, 39.21554], [-120.36287, 39.21575], [-120.36267, 39.22994], [-120.3575, 39.22992], [-120.34426, 39.22975], [-120.34426, 39.22825], [-120.34441, 39.21377], [-120.32839, 39.21429], [-120.32899, 39.20107], [-120.34482, 39.20103], [-120.34478, 39.20247], [-120.35234, 39.20247], [-120.35053, 39.18017], [-120.35009, 39.17281], [-120.34973, 39.16545], [-120.34941, 39.15824], [-120.34919, 39.15288], [-120.349, 39.14735], [-120.34886, 39.14376], [-120.36876, 39.14361], [-120.36801, 39.1291], [-120.35794, 39.12885], [-120.34815, 39.12868], [-120.34857, 39.13618], [-120.34878, 39.14199], [-120.33091, 39.14182], [-120.33022, 39.12723], [-120.34808, 39.12751], [-120.34775, 39.12113], [-120.34739, 39.1135], [-120.36773, 39.11396], [-120.36793, 39.10676], [-120.3676, 39.09886], [-120.38773, 39.09918], [-120.38759, 39.11378], [-120.37751, 39.11395], [-120.36774, 39.11397], [-120.36773, 39.11398], [-120.3679, 39.12173], [-120.36801, 39.12909], [-120.37794, 39.12928], [-120.38774, 39.12921], [-120.38806, 39.13639], [-120.38842, 39.14358], [-120.36876, 39.14362], [-120.36957, 39.15815], [-120.35927, 39.15824], [-120.35956, 39.16914], [-120.37014, 39.16917], [-120.37033, 39.17276], [-120.37065, 39.18017], [-120.3719, 39.20244], [-120.37657, 39.20243], [-120.37625, 39.19484], [-120.38104, 39.19484], [-120.38084, 39.18746], [-120.38574, 39.18741], [-120.3857, 39.18373], [-120.39066, 39.18369], [-120.39065, 39.18737], [-120.39989, 39.18729], [-120.40931, 39.18725], [-120.40928, 39.20208], [-120.41957, 39.20187]], [[-120.40087, 39.2021], [-120.40086, 39.20209], [-120.39789, 39.20215], [-120.3906, 39.20226], [-120.39063, 39.19106], [-120.38579, 39.1911], [-120.38583, 39.19479], [-120.38104, 39.19485], [-120.38125, 39.20242], [-120.38208, 39.20242], [-120.38091, 39.20906], [-120.37974, 39.21554], [-120.38901, 39.21574], [-120.39823, 39.2155], [-120.40087, 39.2021]]], [[[-120.45621, 39.20083], [-120.45598, 39.21519], [-120.44679, 39.21526], [-120.44217, 39.21531], [-120.43751, 39.21546], [-120.43762, 39.20166], [-120.44631, 39.20136], [-120.45621, 39.20083]]]]}	Open Access 1	45990	American River Headwaters	29161	3003	American River Conservancy 604	Non Profit 6	Non Profit - Land Trust 10	http://www.arconservancy.org/	Non Governmental Organization 10	3003	American River Conservancy 593	Non Profit 6	Non Profit - Land Trust 10	http://northernsierrapartnership.org/american-river-headwaters/	Placer 35	10210.918	American River Headwaters	Private Conservation 16	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]);