units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where AGNCY_ID = 321, AGNCY_WEB = "http://sfwater.org/" and MNG_AG_TYP = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16624 | 16624 | 16623 | {"type": "Polygon", "coordinates": [[[-121.87428, 37.53505], [-121.87423, 37.5359], [-121.87414, 37.53845], [-121.87396, 37.54089], [-121.87396, 37.54203], [-121.8701, 37.54196], [-121.86955, 37.54176], [-121.86885, 37.5417], [-121.86885, 37.54142], [-121.86879, 37.54132], [-121.86353, 37.54128], [-121.8583, 37.54118], [-121.85764, 37.54027], [-121.85813, 37.53995], [-121.8586, 37.53948], [-121.85881, 37.53898], [-121.85889, 37.53895], [-121.85897, 37.53881], [-121.85912, 37.53863], [-121.85894, 37.53812], [-121.85795, 37.53698], [-121.85796, 37.53576], [-121.8569, 37.53481], [-121.8564, 37.53431], [-121.85545, 37.53365], [-121.85473, 37.53091], [-121.85356, 37.53043], [-121.85308, 37.53044], [-121.85304, 37.53025], [-121.85296, 37.53001], [-121.85259, 37.52957], [-121.85242, 37.52932], [-121.85221, 37.52907], [-121.85197, 37.52883], [-121.85173, 37.52861], [-121.85152, 37.52838], [-121.85112, 37.52787], [-121.8504, 37.52725], [-121.85003, 37.52682], [-121.84984, 37.52663], [-121.84971, 37.52644], [-121.84964, 37.52623], [-121.84954, 37.526], [-121.849, 37.52561], [-121.84881, 37.52536], [-121.84845, 37.52483], [-121.84831, 37.52456], [-121.84807, 37.524], [-121.84798, 37.52372], [-121.84791, 37.52344], [-121.84793, 37.52314], [-121.8479, 37.52282], [-121.84795, 37.52218], [-121.84789, 37.52187], [-121.84773, 37.52161], [-121.84769, 37.52139], [-121.84782, 37.5212], [-121.84802, 37.52104], [-121.86052, 37.52093], [-121.8695, 37.5209], [-121.86968, 37.535], [-121.87428, 37.53505]]]} | No Public Access 3 | 46962 | Sunol Regional Wilderness | 30582 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 864.645 | Sunol Reg. Wilderness | 1962 | Local Conservation Area 4 | 2 | |
| 16850 | 16850 | 16849 | {"type": "MultiPolygon", "coordinates": [[[[-121.79156, 37.50476], [-121.79134, 37.51904], [-121.77329, 37.51942], [-121.77349, 37.50472], [-121.79132, 37.50475], [-121.79156, 37.50476]]], [[[-121.87405, 37.50648], [-121.87397, 37.51447], [-121.86949, 37.51447], [-121.86944, 37.51803], [-121.86487, 37.5181], [-121.86496, 37.52091], [-121.86052, 37.52093], [-121.84804, 37.52104], [-121.84802, 37.52104], [-121.84789, 37.52089], [-121.84764, 37.52114], [-121.84773, 37.52161], [-121.84789, 37.52188], [-121.84795, 37.52219], [-121.8479, 37.52282], [-121.84792, 37.52308], [-121.84791, 37.52344], [-121.84757, 37.52368], [-121.84771, 37.52423], [-121.84792, 37.52445], [-121.84807, 37.52452], [-121.84827, 37.5249], [-121.84836, 37.52516], [-121.84844, 37.52517], [-121.84862, 37.52509], [-121.849, 37.52561], [-121.84932, 37.52585], [-121.84964, 37.52624], [-121.84971, 37.52644], [-121.84984, 37.52663], [-121.85003, 37.52681], [-121.84991, 37.52694], [-121.85014, 37.52694], [-121.85003, 37.52711], [-121.85056, 37.5274], [-121.85086, 37.52788], [-121.85115, 37.52822], [-121.85145, 37.52836], [-121.85152, 37.52838], [-121.85173, 37.52861], [-121.85198, 37.52883], [-121.85229, 37.52915], [-121.85217, 37.5293], [-121.85244, 37.52935], [-121.8526, 37.52988], [-121.85281, 37.53021], [-121.85271, 37.5302], [-121.85276, 37.53032], [-121.85277, 37.53054], [-121.85263, 37.5307], [-121.85212, 37.53148], [-121.85209, 37.5316], [-121.85203, 37.53169], [-121.85168, 37.53269], [-121.85171, 37.5335], [-121.8519, 37.53405], [-121.85216, 37.53445], [-121.85237, 37.5348], [-121.85267, 37.53514], [-121.85287, 37.53547], [-121.85305, 37.53569], [-121.8528, 37.53564], [-121.85263, 37.53557], [-121.85226, 37.53555], [-121.85196, 37.53559], [-121.85142, 37.53574], [-121.85089, 37.53583], [-121.85049, 37.53588], [-121.85023, 37.5359], [-121.85, 37.53589], [-121.84978, 37.53595], [-121.8493, 37.53591], [-121.84871, 37.53615], [-121.84833, 37.53615], [-121.84796, 37.53606], [-121.84773, 37.53609], [-121.84735, 37.53629], [-121.84716, 37.53648], [-121.84685, 37.53674], [-121.84646, 37.53688], [-121.84617, 37.53694], [-121.84582, 37.53694], [-121.84552, 37.53705], [-121.84521, 37.53709], [-121.84463, 37.53699], [-121.84444, 37.53701], [-121.84434, 37.53704], [-121.84415, 37.53703], [-121.84384, 37.53693], [-121.84343, 37.5369], [-121.84339, 37.53685], [-121.84323, 37.53683], [-121.84325, 37.5352], [-121.83885, 37.5352], [-121.8389, 37.52886], [-121.83433, 37.52892], [-121.83432, 37.52138], [-121.83435, 37.51299], [-121.8282, 37.51317], [-121.82799, 37.51335], [-121.82789, 37.51329], [-121.82778, 37.51319], [-121.82478, 37.51328], [-121.82498, 37.50593], [-121.81606, 37.50569], [-121.81589, 37.50578], [-121.81578, 37.52129], [-121.80715, 37.52064], [-121.80686, 37.50545], [-121.81386, 37.50563], [-121.81415, 37.5054], [-121.81492, 37.50464], [-121.81576, 37.50409], [-121.81698, 37.5036], [-121.81907, 37.50437], [-121.81948, 37.50513], [-121.81977, 37.50495], [-121.81956, 37.50443], [-121.81987, 37.50434], [-121.82052, 37.5033], [-121.8222, 37.50333], [-121.82486, 37.50313], [-121.82524, 37.50319], [-121.82543, 37.50361], [-121.82565, 37.50399], [-121.82603, 37.50385], [-121.82641, 37.50342], [-121.82703, 37.50361], [-121.82791, 37.50396], [-121.82867, 37.50442], [-121.82899, 37.5048], [-121.83019, 37.50608], [-121.84289, 37.50646], [-121.85985, 37.50665], [-121.85999, 37.50648], [-121.86938, 37.50648], [-121.86939, 37.50649], [-121.87405, 37.50648]], [[-121.85612, 37.51725], [-121.85397, 37.51724], [-121.85395, 37.5181], [-121.85611, 37.51811], [-121.85612, 37.51725]]]]} | Open Access 1 | 29545 | Sunol Regional Wilderness | 10841 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/sunol | Alameda 17 | 2997.505 | Sunol Reg. Wilderness | 1962 | Local Conservation Area 4 | 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]);