calands: units_with_maps: 25 rows where ACCESS_TYP = 3 and DES

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

25 rows where ACCESS_TYP = 3 and DES_TP = 65

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	COUNTY	ACRES	LABEL_NAME	DES_TP	GAP_STS
2539	2539	2538	{"type": "Polygon", "coordinates": [[[-118.6218, 34.10061], [-118.62167, 34.10067], [-118.6216, 34.10059], [-118.62174, 34.10053], [-118.6218, 34.10061]]]}	No Public Access 3	12510	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.038	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
2577	2577	2576	{"type": "Polygon", "coordinates": [[[-118.61509, 34.08307], [-118.61508, 34.08325], [-118.61399, 34.08325], [-118.61398, 34.08307], [-118.61509, 34.08307]]]}	No Public Access 3	12513	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.501	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
2800	2800	2799	{"type": "Polygon", "coordinates": [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]]}	No Public Access 3	12515	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.042	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
3140	3140	3139	{"type": "MultiPolygon", "coordinates": [[[[-116.60256, 33.11613], [-116.59824, 33.115], [-116.59824, 33.11394], [-116.60131, 33.11356], [-116.60184, 33.11283], [-116.60185, 33.1129], [-116.6019, 33.11298], [-116.60231, 33.11337], [-116.6024, 33.11349], [-116.60246, 33.1136], [-116.60259, 33.11401], [-116.60286, 33.1151], [-116.60287, 33.11531], [-116.60283, 33.11554], [-116.60272, 33.11583], [-116.60256, 33.11613]]], [[[-116.60241, 33.11223], [-116.60228, 33.11229], [-116.6022, 33.11232], [-116.60227, 33.11223], [-116.60241, 33.11223]]]]}	No Public Access 3	25800	San Dieguito River Park	24870	3066	San Dieguito River Valley Land Conservancy 378	Non Profit 6	Non Profit - Land Trust 10	http://www.sdrvc.org/	Non Governmental Organization 10	3066	San Dieguito River Valley Land Conservancy 373	Non Profit 6	Non Profit - Land Trust 10	San Diego 4	22.717	San Dieguito River Park	Private Recreation or Education 65	4
4129	4129	4128	{"type": "Polygon", "coordinates": [[[-118.5962, 34.10228], [-118.59481, 34.10227], [-118.59481, 34.10169], [-118.59619, 34.1017], [-118.5962, 34.10228]]]}	No Public Access 3	12686	Topanga Open Space	29663	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	2.028	Topanga OS	Private Recreation or Education 65	4
5115	5115	5114	{"type": "Polygon", "coordinates": [[[-118.61183, 34.07805], [-118.61181, 34.07986], [-118.61069, 34.07986], [-118.61071, 34.07804], [-118.61183, 34.07805]]]}	No Public Access 3	12499	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	5.129	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
5116	5116	5115	{"type": "Polygon", "coordinates": [[[-118.6151, 34.08172], [-118.61509, 34.08198], [-118.61399, 34.08198], [-118.61399, 34.08171], [-118.6151, 34.08172]]]}	No Public Access 3	12503	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.733	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
5406	5406	5405	{"type": "Polygon", "coordinates": [[[-118.77959, 34.0458], [-118.7791, 34.0458], [-118.7791, 34.04539], [-118.77959, 34.04539], [-118.77959, 34.0458]]]}	No Public Access 3	12498	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.514	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
7240	7240	7239	{"type": "MultiPolygon", "coordinates": [[[[-118.63834, 34.05331], [-118.63828, 34.05338], [-118.63796, 34.05287], [-118.63805, 34.05287], [-118.63822, 34.05318], [-118.63834, 34.05331]]], [[[-118.6403, 34.06405], [-118.63999, 34.06447], [-118.63883, 34.06406], [-118.63887, 34.06394], [-118.63886, 34.06386], [-118.63882, 34.06371], [-118.63874, 34.06362], [-118.63846, 34.06342], [-118.63832, 34.06326], [-118.63943, 34.06277], [-118.63948, 34.06284], [-118.63955, 34.06289], [-118.63962, 34.06291], [-118.63971, 34.06301], [-118.63979, 34.06313], [-118.63977, 34.06316], [-118.64005, 34.06353], [-118.64004, 34.06366], [-118.64009, 34.06377], [-118.6403, 34.06405]]]]}	No Public Access 3	6434	Las Flores Canyon Open Space	29666	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	4.661	Las Flores Canyon OS	Private Recreation or Education 65	4
7266	7266	7265	{"type": "Polygon", "coordinates": [[[-118.61947, 34.11809], [-118.61505, 34.11808], [-118.61507, 34.11444], [-118.61946, 34.11443], [-118.61947, 34.11809]]]}	No Public Access 3	6454	Henry Ridge Open Space	29664	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	40.702	Henry Ridge OS	Private Recreation or Education 65	4
7965	7965	7964	{"type": "Polygon", "coordinates": [[[-116.7891, 33.13878], [-116.78022, 33.1388], [-116.78022, 33.13504], [-116.78472, 33.13503], [-116.78478, 33.13134], [-116.78494, 33.12411], [-116.78899, 33.12409], [-116.78892, 33.13124], [-116.78904, 33.13125], [-116.7891, 33.13878]]]}	No Public Access 3	47728	Corral Mountain Open Space	31528	3066	San Dieguito River Valley Land Conservancy 378	Non Profit 6	Non Profit - Land Trust 10	http://www.sdrvc.org/	Non Governmental Organization 10	3066	San Dieguito River Valley Land Conservancy 373	Non Profit 6	Non Profit - Land Trust 10	San Diego 4	201.771	Corral Mtn. OS	Private Recreation or Education 65	4
8339	8339	8338	{"type": "Polygon", "coordinates": [[[-116.53359, 33.16797], [-116.53794, 33.16809], [-116.53811, 33.17231], [-116.53815, 33.17515], [-116.54258, 33.17521], [-116.54272, 33.17873], [-116.53401, 33.17867], [-116.53373, 33.17153], [-116.52949, 33.17168], [-116.52931, 33.16798], [-116.53359, 33.16797]]]}	No Public Access 3	12844	San Dieguito River Park	24870	3066	San Dieguito River Valley Land Conservancy 378	Non Profit 6	Non Profit - Land Trust 10	http://www.sdrvc.org/	Non Governmental Organization 10	3066	San Dieguito River Valley Land Conservancy 373	Non Profit 6	Non Profit - Land Trust 10	San Diego 4	197.03	San Dieguito River Park	Private Recreation or Education 65	4
12370	12370	12369	{"type": "MultiPolygon", "coordinates": [[[[-122.99606, 38.50153], [-122.99573, 38.50173], [-122.99551, 38.50189], [-122.99444, 38.50252], [-122.99426, 38.50269], [-122.99358, 38.50215], [-122.99512, 38.50083], [-122.99561, 38.50114], [-122.99561, 38.50132], [-122.99606, 38.50153]]], [[[-122.99562, 38.5004], [-122.99561, 38.50099], [-122.99561, 38.50099], [-122.99523, 38.50073], [-122.99562, 38.5004]]]]}	No Public Access 3	26073	Riverkeeper Park	24442	3132	Russian Riverkeeper 1021	Non Profit 6	Non Profit - Conservation 12	http://www.russianriverkeeper.org/	Non Governmental Organization 10	3132	Russian Riverkeeper 983	Non Profit 6	Non Profit - Conservation 12	Sonoma 16	5.046	Riverkeeper Park	Private Recreation or Education 65	4
12454	12454	12453	{"type": "Polygon", "coordinates": [[[-119.76638, 36.87034], [-119.76629, 36.87046], [-119.76408, 36.8694], [-119.76326, 36.86965], [-119.76233, 36.87081], [-119.76208, 36.87074], [-119.7624, 36.87065], [-119.76252, 36.87049], [-119.7625, 36.87038], [-119.76256, 36.87037], [-119.76263, 36.87028], [-119.76271, 36.87026], [-119.7628, 36.87015], [-119.76278, 36.87009], [-119.76286, 36.87007], [-119.76291, 36.87001], [-119.76286, 36.86982], [-119.76309, 36.86977], [-119.76322, 36.86962], [-119.76333, 36.8696], [-119.76338, 36.86952], [-119.76353, 36.86947], [-119.76368, 36.86929], [-119.76359, 36.86895], [-119.76313, 36.86876], [-119.76329, 36.86858], [-119.76333, 36.86848], [-119.76336, 36.86837], [-119.76337, 36.86821], [-119.76329, 36.86781], [-119.76331, 36.86778], [-119.76346, 36.86777], [-119.76382, 36.86776], [-119.76417, 36.86781], [-119.76404, 36.86792], [-119.76406, 36.86877], [-119.7637, 36.86896], [-119.76375, 36.86923], [-119.7638, 36.86933], [-119.76389, 36.86937], [-119.76408, 36.86931], [-119.76411, 36.86937], [-119.76417, 36.8694], [-119.76435, 36.86935], [-119.76442, 36.86951], [-119.76448, 36.8695], [-119.76506, 36.86978], [-119.76509, 36.86975], [-119.76525, 36.86982], [-119.76523, 36.86986], [-119.76555, 36.87001], [-119.76558, 36.86999], [-119.76576, 36.87008], [-119.76574, 36.87013], [-119.76616, 36.87034], [-119.76638, 36.87034]]]}	No Public Access 3	48758	Floyd Boler Park	33798	6130	Park Fort Washington Association 1026	Private 7	Home Owners Association 16	http://parkfortwashington.com/	Private 14	6130	Park Fort Washington Association 988	Private 7	Home Owners Association 15	Fresno 9	3.203	Floyd Boler Park	Private Recreation or Education 65	4
12491	12491	12490	{"type": "Polygon", "coordinates": [[[-118.59323, 34.10829], [-118.59283, 34.10826], [-118.59281, 34.10794], [-118.59295, 34.10796], [-118.59321, 34.10791], [-118.59323, 34.10829]]]}	No Public Access 3	12687	Topanga Open Space	29663	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.339	Topanga OS	Private Recreation or Education 65	4
15805	15805	15804	{"type": "Polygon", "coordinates": [[[-118.77383, 34.04565], [-118.77371, 34.04579], [-118.77369, 34.04597], [-118.77341, 34.04599], [-118.77339, 34.04567], [-118.77383, 34.04565]]]}	No Public Access 3	12523	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.266	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
16520	16520	16519	{"type": "Polygon", "coordinates": [[[-118.64775, 34.04924], [-118.64555, 34.04925], [-118.64555, 34.04925], [-118.64573, 34.0491], [-118.64588, 34.04894], [-118.64619, 34.04853], [-118.64631, 34.04842], [-118.64645, 34.04834], [-118.64775, 34.04924]]]}	No Public Access 3	12521	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	2.56	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
16528	16528	16527	{"type": "Polygon", "coordinates": [[[-118.60253, 34.07222], [-118.60241, 34.07227], [-118.60218, 34.07226], [-118.60217, 34.07263], [-118.60212, 34.07256], [-118.60205, 34.07251], [-118.60191, 34.07248], [-118.60189, 34.07202], [-118.60197, 34.072], [-118.60221, 34.07203], [-118.60233, 34.07199], [-118.6024, 34.07194], [-118.60253, 34.07222]]]}	No Public Access 3	12514	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.564	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
16562	16562	16561	{"type": "Polygon", "coordinates": [[[-118.68988, 34.0683], [-118.68988, 34.06861], [-118.6898, 34.06857], [-118.68979, 34.06857], [-118.6898, 34.06859], [-118.68956, 34.0685], [-118.68902, 34.06837], [-118.689, 34.06726], [-118.68797, 34.06719], [-118.68796, 34.06733], [-118.68653, 34.06724], [-118.68653, 34.06684], [-118.68987, 34.06705], [-118.68988, 34.0683]]]}	No Public Access 3	12516	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	5.347	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	4
16954	16954	16953	{"type": "Polygon", "coordinates": [[[-118.77802, 34.04594], [-118.77704, 34.04594], [-118.77695, 34.0458], [-118.77801, 34.0458], [-118.77802, 34.04594]]]}	No Public Access 3	12522	Mountains Restoration Trust Parkland	29660	3044	Mountains Restoration Trust 533	Non Profit 6	Non Profit - Conservation 12	http://www.mountainstrust.org/	Non Governmental Organization 10	3044	Mountains Restoration Trust 526	Non Profit 6	Non Profit - Conservation 12	Los Angeles 6	0.35	Mtns. Restoration Trust Parkland	Private Recreation or Education 65	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]);