calands: units_with_maps: 5 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AG

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

5 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AG_TYP = 14

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
500	500	499	{"type": "Polygon", "coordinates": [[[-117.1728, 32.71668], [-117.17278, 32.71676], [-117.17262, 32.71679], [-117.17261, 32.71695], [-117.1722, 32.71685], [-117.17129, 32.71683], [-117.17128, 32.71657], [-117.17223, 32.71657], [-117.17231, 32.71653], [-117.17235, 32.71589], [-117.17279, 32.71589], [-117.1728, 32.71668]]]}	Open Access 1	47486	Lane Field Park	31204	2133	San Diego Unified Port District 186	Special District 4	Port/Harbor District 15	http://www.portofsandiego.org/	Special District 4	2133	San Diego Unified Port District 182	Special District 4	Port/Harbor District 14	https://www.portofsandiego.org/parks/lane-field-park.html	San Diego 4	1.887	Lane Field Park	Local Recreation Area 3	4
5716	5716	5715	{"type": "Polygon", "coordinates": [[[-120.76127, 35.1596], [-120.76127, 35.16227], [-120.75687, 35.16244], [-120.75682, 35.16235], [-120.75667, 35.1622], [-120.75662, 35.16211], [-120.75658, 35.16201], [-120.75658, 35.16191], [-120.75659, 35.16181], [-120.75663, 35.16172], [-120.75678, 35.16151], [-120.75683, 35.16138], [-120.75691, 35.16091], [-120.75688, 35.16085], [-120.75668, 35.16071], [-120.75661, 35.16063], [-120.75654, 35.16037], [-120.75654, 35.16029], [-120.75655, 35.16023], [-120.75658, 35.16025], [-120.75665, 35.16025], [-120.75773, 35.16026], [-120.75792, 35.16018], [-120.75792, 35.15968], [-120.75812, 35.15964], [-120.75861, 35.15959], [-120.75888, 35.15961], [-120.75923, 35.15968], [-120.75951, 35.15963], [-120.75963, 35.15963], [-120.75974, 35.15965], [-120.75986, 35.1597], [-120.75999, 35.15967], [-120.7603, 35.15954], [-120.76051, 35.15949], [-120.76067, 35.15951], [-120.76078, 35.15955], [-120.76098, 35.15956], [-120.76127, 35.1596]]]}	Open Access 1	48514	Point San Luis Lighthouse Public Access	33227	2114	Port San Luis Harbor District 509	Special District 4	Port/Harbor District 15	http://www.portsanluis.com/	Special District 4	2114	Port San Luis Harbor District 501	Special District 4	Port/Harbor District 14	http://pointsanluislighthouse.org/	San Luis Obispo 1	29.329	Point San Luis Lighthouse PA	Local Recreation Area 3	4
7019	7019	7018	{"type": "Polygon", "coordinates": [[[-118.28592, 33.71434], [-118.28588, 33.71469], [-118.28592, 33.71498], [-118.28564, 33.71556], [-118.28542, 33.71631], [-118.28546, 33.71662], [-118.28435, 33.7181], [-118.28417, 33.7184], [-118.28345, 33.71926], [-118.28338, 33.71977], [-118.28316, 33.72016], [-118.28318, 33.72028], [-118.28308, 33.72031], [-118.28345, 33.7209], [-118.28395, 33.72204], [-118.28411, 33.72244], [-118.28426, 33.72301], [-118.28445, 33.7239], [-118.28434, 33.72394], [-118.28389, 33.72397], [-118.28306, 33.72182], [-118.28152, 33.72222], [-118.28118, 33.72129], [-118.28269, 33.72088], [-118.28241, 33.72004], [-118.28248, 33.72002], [-118.28236, 33.71965], [-118.28222, 33.71969], [-118.28216, 33.71947], [-118.28226, 33.71943], [-118.28193, 33.71853], [-118.28185, 33.71854], [-118.28176, 33.71823], [-118.28044, 33.71852], [-118.28044, 33.7186], [-118.28016, 33.71866], [-118.27982, 33.71774], [-118.28155, 33.71727], [-118.28161, 33.71721], [-118.28173, 33.71692], [-118.28178, 33.71669], [-118.2815, 33.71617], [-118.28043, 33.71566], [-118.28029, 33.71561], [-118.2791, 33.71561], [-118.279, 33.71563], [-118.27841, 33.71586], [-118.27837, 33.71586], [-118.27833, 33.71583], [-118.27831, 33.71578], [-118.27832, 33.71575], [-118.2784, 33.7157], [-118.27901, 33.71552], [-118.27912, 33.7155], [-118.28029, 33.71548], [-118.28042, 33.71549], [-118.28159, 33.71607], [-118.2819, 33.71666], [-118.28264, 33.71686], [-118.28323, 33.71682], [-118.28341, 33.71662], [-118.28376, 33.71619], [-118.28391, 33.71596], [-118.28418, 33.71546], [-118.28439, 33.71495], [-118.28448, 33.71454], [-118.2845, 33.71434], [-118.28592, 33.71434]]]}	Open Access 1	5954	Cabrillo Beach Marina and Recreation Complex	29073	2384	Port of Los Angeles 289	Special District 4	Port/Harbor District 15	http://www.portoflosangeles.org/	Special District 4	2384	Port of Los Angeles 286	Special District 4	Port/Harbor District 14	https://www.portoflosangeles.org	Los Angeles 6	45.403	Cabrillo Beach Marina and Rec. Complex	Local Recreation Area 3	4
7021	7021	7020	{"type": "Polygon", "coordinates": [[[-118.27952, 33.74733], [-118.2791, 33.74733], [-118.27909, 33.74602], [-118.2791, 33.74184], [-118.2791, 33.74155], [-118.27906, 33.7414], [-118.27932, 33.74155], [-118.2794, 33.74155], [-118.27939, 33.74317], [-118.27943, 33.74318], [-118.27946, 33.74316], [-118.27948, 33.7434], [-118.27939, 33.74341], [-118.27938, 33.74663], [-118.27939, 33.74687], [-118.27944, 33.7471], [-118.27952, 33.74733]]]}	Open Access 1	5963	Harbor Boulevard Parkway	29110	2384	Port of Los Angeles 289	Special District 4	Port/Harbor District 15	http://www.portoflosangeles.org/	Special District 4	2384	Port of Los Angeles 286	Special District 4	Port/Harbor District 14		Los Angeles 6	4.463	Harbor Boulevard Parkway	Local Recreation Area 3	4
15055	15055	15054	{"type": "Polygon", "coordinates": [[[-120.75792, 35.15968], [-120.75792, 35.16019], [-120.75773, 35.16026], [-120.75658, 35.16025], [-120.75652, 35.16021], [-120.75651, 35.16016], [-120.75654, 35.15984], [-120.75647, 35.15959], [-120.75648, 35.15954], [-120.75651, 35.15949], [-120.75663, 35.15949], [-120.75677, 35.15953], [-120.75692, 35.15961], [-120.75725, 35.15965], [-120.75753, 35.15962], [-120.75792, 35.15968]]]}	Open Access 1	48515	Point San Luis Lighthouse Public Access	33227	104	United States Coast Guard 511	Federal 1	Federal Agency 1	http://www.uscg.mil/	Other Federal 13	2114	Port San Luis Harbor District 501	Special District 4	Port/Harbor District 14	http://pointsanluislighthouse.org/	San Luis Obispo 1	2.258	Point San Luis Lighthouse PA	Local Recreation Area 3	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]);