units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 2, DES_TP = 1420 and MNG_AG_TYP = 2
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16910 | 16910 | 16909 | {"type": "Polygon", "coordinates": [[[-122.33036, 37.52058], [-122.33006, 37.52091], [-122.32899, 37.52069], [-122.32764, 37.52097], [-122.32656, 37.52146], [-122.32553, 37.52223], [-122.32553, 37.52224], [-122.32578, 37.52241], [-122.32567, 37.52252], [-122.32538, 37.52262], [-122.32526, 37.5227], [-122.32521, 37.52266], [-122.32513, 37.52271], [-122.32518, 37.52276], [-122.32501, 37.52288], [-122.32517, 37.52303], [-122.32506, 37.5232], [-122.32496, 37.52343], [-122.3248, 37.52339], [-122.32441, 37.52369], [-122.32445, 37.52385], [-122.32402, 37.52429], [-122.32415, 37.52442], [-122.32402, 37.52458], [-122.32394, 37.52475], [-122.32391, 37.52494], [-122.32393, 37.52514], [-122.32413, 37.52511], [-122.32418, 37.52525], [-122.32427, 37.52539], [-122.32435, 37.52547], [-122.32441, 37.52548], [-122.32456, 37.5256], [-122.32476, 37.52581], [-122.32498, 37.52623], [-122.32507, 37.52633], [-122.32512, 37.52634], [-122.32524, 37.52648], [-122.32573, 37.5272], [-122.32554, 37.52728], [-122.32526, 37.52685], [-122.32487, 37.52699], [-122.32485, 37.52692], [-122.32439, 37.52702], [-122.32443, 37.52721], [-122.32427, 37.52725], [-122.3243, 37.5275], [-122.32399, 37.52749], [-122.32378, 37.52753], [-122.32371, 37.52736], [-122.32365, 37.52737], [-122.32331, 37.52727], [-122.32215, 37.52724], [-122.32196, 37.52811], [-122.32151, 37.52822], [-122.32126, 37.52752], [-122.32126, 37.52721], [-122.32119, 37.52705], [-122.32095, 37.527], [-122.32063, 37.52711], [-122.32044, 37.52723], [-122.32059, 37.52748], [-122.32045, 37.52773], [-122.32041, 37.52801], [-122.32006, 37.52816], [-122.32001, 37.52815], [-122.3198, 37.52794], [-122.31951, 37.52812], [-122.31953, 37.52823], [-122.31945, 37.52824], [-122.31943, 37.52816], [-122.31874, 37.52819], [-122.31849, 37.52826], [-122.3179, 37.52849], [-122.31767, 37.52852], [-122.31746, 37.52856], [-122.31722, 37.52857], [-122.31683, 37.52877], [-122.31637, 37.52843], [-122.31597, 37.52836], [-122.31579, 37.52842], [-122.31555, 37.52795], [-122.31563, 37.52785], [-122.31581, 37.52781], [-122.31583, 37.52792], [-122.31606, 37.52781], [-122.31626, 37.52772], [-122.31635, 37.52758], [-122.31658, 37.52761], [-122.31667, 37.52757], [-122.3167, 37.52742], [-122.31676, 37.52734], [-122.31694, 37.52746], [-122.31705, 37.52746], [-122.31724, 37.52736], [-122.31725, 37.52726], [-122.31751, 37.52726], [-122.31802, 37.52711], [-122.3184, 37.52708], [-122.31841, 37.52705], [-122.3185, 37.52705], [-122.31857, 37.52702], [-122.31857, 37.5269], [-122.31835, 37.52691], [-122.3183, 37.52677], [-122.31786, 37.52677], [-122.31737, 37.52684], [-122.31705, 37.52693], [-122.31679, 37.52702], [-122.31587, 37.5263], [-122.31625, 37.52599], [-122.31624, 37.52597], [-122.31434, 37.52534], [-122.3142, 37.52521], [-122.31453, 37.52477], [-122.31459, 37.52438], [-122.31429, 37.52405], [-122.31419, 37.52386], [-122.31412, 37.52358], [-122.31328, 37.52356], [-122.31324, 37.52381], [-122.31335, 37.5242], [-122.31331, 37.52455], [-122.3129, 37.52486], [-122.3136, 37.52621], [-122.31334, 37.52678], [-122.31307, 37.5269], [-122.313, 37.52675], [-122.31217, 37.5269], [-122.31232, 37.52669], [-122.31225, 37.5263], [-122.31204, 37.52592], [-122.31169, 37.52551], [-122.31204, 37.52522], [-122.31199, 37.52511], [-122.31215, 37.5251], [-122.31214, 37.52503], [-122.31231, 37.52468], [-122.31189, 37.52452], [-122.312, 37.52426], [-122.31196, 37.52424], [-122.31262, 37.52268], [-122.31339, 37.52159], [-122.31382, 37.52142], [-122.31423, 37.5214], [-122.31455, 37.52114], [-122.31472, 37.52074], [-122.3148, 37.52014], [-122.31492, 37.51953], [-122.31506, 37.51925], [-122.31538, 37.51923], [-122.31606, 37.51943], [-122.31641, 37.51946], [-122.31735, 37.51937], [-122.31782, 37.51923], [-122.3186, 37.51929], [-122.31928, 37.51925], [-122.31963, 37.51946], [-122.32012, 37.51983], [-122.32056, 37.52046], [-122.32155, 37.5212], [-122.32184, 37.52121], [-122.32248, 37.52097], [-122.32277, 37.52082], [-122.32291, 37.52076], [-122.3232, 37.5207], [-122.32329, 37.52074], [-122.32337, 37.52085], [-122.3235, 37.52099], [-122.32375, 37.521], [-122.32441, 37.5205], [-122.32458, 37.52028], [-122.32497, 37.52018], [-122.32533, 37.51988], [-122.32543, 37.51959], [-122.32545, 37.51935], [-122.32554, 37.51908], [-122.32546, 37.51879], [-122.32538, 37.51865], [-122.32525, 37.51853], [-122.32513, 37.51846], [-122.32511, 37.51836], [-122.32516, 37.51809], [-122.32506, 37.51782], [-122.32508, 37.51769], [-122.32505, 37.51753], [-122.32489, 37.51731], [-122.32492, 37.51724], [-122.32519, 37.51715], [-122.32556, 37.51712], [-122.32578, 37.51686], [-122.32585, 37.51672], [-122.32587, 37.51658], [-122.32593, 37.51647], [-122.32675, 37.51559], [-122.32691, 37.51532], [-122.32691, 37.51505], [-122.32736, 37.51541], [-122.32679, 37.51587], [-122.32722, 37.51663], [-122.32694, 37.51683], [-122.32623, 37.51782], [-122.3269, 37.51829], [-122.32788, 37.51813], [-122.32848, 37.5177], [-122.32923, 37.51866], [-122.32761, 37.51891], [-122.32704, 37.51962], [-122.32729, 37.52014], [-122.32815, 37.52034], [-122.3294, 37.5199], [-122.32963, 37.52028], [-122.33036, 37.52058]]]} | Open Access 1 | 14062 | Laurelwood Park and Sugarloaf Mountain | 29306 | 1310 | San Mateo, City of 98 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?nid=324 | City 2 | 1310 | San Mateo, City of 96 | City 2 | City Agency 2 | http://www.cityofsanmateo.org/index.aspx?NID=2449 | San Mateo 15 | 236.587 | Laurelwood Park and Sugarloaf Mtn. | 2000 | None 1420 |
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]);