calands: units_with_maps: 8 rows where ACCESS_TYP = 2, MNG_AG_LEV = 6 and MNG_AG

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

8 rows where ACCESS_TYP = 2, MNG_AG_LEV = 6 and MNG_AG_TYP = 20

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
4103	4103	4102	{"type": "Polygon", "coordinates": [[[-120.13295, 34.59237], [-120.13291, 34.59524], [-120.12773, 34.5952], [-120.12768, 34.59802], [-120.12682, 34.59784], [-120.12694, 34.59711], [-120.12699, 34.59605], [-120.1268, 34.59601], [-120.12734, 34.59501], [-120.12845, 34.59417], [-120.12826, 34.59379], [-120.1283, 34.59233], [-120.13295, 34.59237]]]}	Restricted Access 2	47041	Santa Ines Mission Mill	30693	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	3372	Santa Barbara Trust for Historic Preservation 706	Non Profit 6	Non Profit - Other 20	http://www.sbthp.org/	Santa Barbara 7	40.009	Santa Ines Mission Mill		None 356
4471	4471	4470	{"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]}	Restricted Access 2	1199	Unnamed site - Nonprofit Organization - Unknown	28649	3048	Nonprofit Organization - Unknown 765	Non Profit 6	Non Profit - Other 22		Non Governmental Organization 10	3048	Nonprofit Organization - Unknown 746	Non Profit 6	Non Profit - Other 20		San Diego 4	6.306		0	Private Other or Unknown 399	4
4472	4472	4471	{"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]}	Restricted Access 2	1208	Unnamed site - Nonprofit Organization - Unknown	28649	3048	Nonprofit Organization - Unknown 765	Non Profit 6	Non Profit - Other 22		Non Governmental Organization 10	3048	Nonprofit Organization - Unknown 746	Non Profit 6	Non Profit - Other 20		San Diego 4	638.799		0	Private Other or Unknown 399	4
5753	5753	5752	{"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]}	Restricted Access 2	3683	Kingsburg Historical Park	32675	3138	Kingsburg Historical Society 817	Non Profit 6	Non Profit - Other 22	http://www.kingsburghistoricalpark.org/	Non Governmental Organization 10	3138	Kingsburg Historical Society 795	Non Profit 6	Non Profit - Other 20	http://kingsburghistoricalpark.org/	Fresno 9	4.887	Kingsburg Historical Park	0	Private Recreation or Education 65	4
9507	9507	9506	{"type": "Polygon", "coordinates": [[[-117.77532, 34.12952], [-117.77504, 34.12945], [-117.77433, 34.1294], [-117.77405, 34.12932], [-117.77412, 34.12916], [-117.77405, 34.12898], [-117.77414, 34.12894], [-117.77431, 34.1287], [-117.77434, 34.12868], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12799], [-117.77383, 34.12742], [-117.774, 34.1274], [-117.77418, 34.12741], [-117.77492, 34.12751], [-117.77483, 34.12784], [-117.77483, 34.12796], [-117.77491, 34.12831], [-117.77504, 34.12875], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]}	Restricted Access 2	47831	La Verne Heritage Foundation	31773	1162	La Verne, City of 305	City 2	City Agency 2	http://www.ci.la-verne.ca.us/index.php/residents/parks	City 2	3382	La Verne Heritage Foundation 888	Non Profit 6	Non Profit - Other 20		Los Angeles 6	4.634	La Verne Heritage Foundation		None 788
10925	10925	10924	{"type": "Polygon", "coordinates": [[[-121.81078, 39.71922], [-121.81078, 39.71922], [-121.8073, 39.71927], [-121.80736, 39.71921], [-121.80879, 39.71919], [-121.80878, 39.71845], [-121.81077, 39.71844], [-121.81078, 39.71922]]]}	Restricted Access 2	48675	Silver Dollar BMX	33416	1052	Chico, City of 430	City 2	City Agency 2	http://www.chico.ca.us/general_services_department/park_division/home_page.asp	City 2	3395	Silver Dollar BMX 929	Non Profit 6	Non Profit - Other 20	https://www.usabmx.com/tracks/1344/about	Butte 42	3.937	Silver Dollar BMX		None 953
12587	12587	12586	{"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]}	Restricted Access 2	48772	Murrieta Valley Pony Baseball	33498	3397	Murrieta Valley PONY Baseball, Inc 1031	Non Profit 6	Non Profit - Other 22	https://www.mvpb.org/	Non Governmental Organization 10	3397	Murrieta Valley PONY Baseball, Inc 992	Non Profit 6	Non Profit - Other 20	https://www.mvpb.org/	Riverside 10	8.519	Murrieta Valley Pony Baseball	0	Private Conservation 16	2
16986	16986	16985	{"type": "Polygon", "coordinates": [[[-122.33796, 37.45405], [-122.33784, 37.45482], [-122.3369, 37.45579], [-122.33616, 37.45669], [-122.33589, 37.45776], [-122.33615, 37.45885], [-122.33668, 37.45965], [-122.31809, 37.47368], [-122.31807, 37.47367], [-122.3133, 37.47728], [-122.30701, 37.47208], [-122.30873, 37.47076], [-122.30803, 37.46999], [-122.30845, 37.46868], [-122.30961, 37.46678], [-122.31148, 37.46868], [-122.31435, 37.46651], [-122.3146, 37.46658], [-122.31482, 37.46659], [-122.31543, 37.46654], [-122.3156, 37.46558], [-122.33576, 37.45033], [-122.33575, 37.45149], [-122.33668, 37.45179], [-122.33796, 37.45405]]]}	Restricted Access 2	16413	Filoli Center	18900	3047	National Trust for Historic Preservation 1184	Non Profit 6	Non Profit - Other 22	http://www.preservationnation.org/	Non Governmental Organization 10	3047	National Trust for Historic Preservation 1122	Non Profit 6	Non Profit - Other 20		San Mateo 15	657.331	Filoli Ctr.	1975	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]);