units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_TYP = 9 and DES_TP = 1015
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11443 | 11443 | 11442 | {"type": "MultiPolygon", "coordinates": [[[[-121.94454, 37.59589], [-121.9445, 37.5966], [-121.93814, 37.59689], [-121.93805, 37.59691], [-121.93803, 37.59707], [-121.93759, 37.59703], [-121.93756, 37.59685], [-121.93765, 37.59503], [-121.9375, 37.59448], [-121.93727, 37.59404], [-121.93713, 37.59343], [-121.93704, 37.59338], [-121.93704, 37.59322], [-121.93638, 37.59218], [-121.93598, 37.59189], [-121.93532, 37.59164], [-121.93475, 37.59162], [-121.93417, 37.59175], [-121.9335, 37.59209], [-121.93247, 37.59285], [-121.93129, 37.59484], [-121.92813, 37.5967], [-121.92649, 37.59793], [-121.92556, 37.59832], [-121.92507, 37.59842], [-121.92386, 37.59841], [-121.92295, 37.59823], [-121.92171, 37.59775], [-121.92047, 37.59709], [-121.91785, 37.59507], [-121.91651, 37.59391], [-121.91529, 37.59344], [-121.91377, 37.59308], [-121.9117, 37.593], [-121.91096, 37.59321], [-121.90743, 37.59454], [-121.90541, 37.59502], [-121.9041, 37.59509], [-121.90379, 37.59498], [-121.9025, 37.59479], [-121.90243, 37.5947], [-121.89927, 37.59391], [-121.89615, 37.59332], [-121.89377, 37.59299], [-121.89169, 37.59278], [-121.88985, 37.5927], [-121.88751, 37.59265], [-121.88603, 37.59248], [-121.88454, 37.59259], [-121.88357, 37.5945], [-121.88357, 37.59451], [-121.8838, 37.59455], [-121.88415, 37.59487], [-121.88431, 37.5952], [-121.88422, 37.59584], [-121.8838, 37.59632], [-121.88324, 37.59679], [-121.88106, 37.5982], [-121.87861, 37.5989], [-121.87608, 37.59934], [-121.87581, 37.59943], [-121.87526, 37.59963], [-121.87493, 37.59997], [-121.87465, 37.60046], [-121.87458, 37.60089], [-121.87403, 37.60137], [-121.87424, 37.60596], [-121.87601, 37.60632], [-121.87797, 37.60915], [-121.87819, 37.61072], [-121.87926, 37.61261], [-121.8793, 37.61288], [-121.88058, 37.61696], [-121.88223, 37.62116], [-121.88225, 37.62415], [-121.88319, 37.62619], [-121.88229, 37.62637], [-121.8819, 37.62639], [-121.88065, 37.62668], [-121.87351, 37.60837], [-121.87332, 37.60844], [-121.84693, 37.60243], [-121.84797, 37.60206], [-121.84833, 37.60157], [-121.84883, 37.60066], [-121.84904, 37.60049], [-121.84936, 37.60021], [-121.85073, 37.59936], [-121.8516, 37.5987], [-121.8527, 37.59814], [-121.85374, 37.59783], [-121.85501, 37.59773], [-121.85521, 37.59424], [-121.84563, 37.59215], [-121.84468, 37.58728], [-121.8384, 37.58725], [-121.83811, 37.58273], [-121.83739, 37.58308], [-121.83619, 37.58377], [-121.83348, 37.58497], [-121.82973, 37.58706], [-121.82743, 37.58894], [-121.82469, 37.5913], [-121.82157, 37.59432], [-121.81939, 37.59664], [-121.81939, 37.60076], [-121.80555, 37.60081], [-121.80554, 37.59818], [-121.7862, 37.59816], [-121.78118, 37.60198], [-121.7783, 37.60025], [-121.77841, 37.59127], [-121.77808, 37.59126], [-121.77702, 37.59019], [-121.77666, 37.58996], [-121.76516, 37.59044], [-121.76521, 37.5822], [-121.75297, 37.58206], [-121.75305, 37.57885], [-121.75304, 37.57884], [-121.73468, 37.57873], [-121.72581, 37.5787], [-121.72591, 37.57156], [-121.71649, 37.57154], [-121.71651, 37.5642], [-121.73482, 37.5642], [-121.74385, 37.56409], [-121.75314, 37.56408], [-121.7713, 37.56422], [-121.78771, 37.56431], [-121.78805, 37.55397], [-121.79753, 37.55397], [-121.79756, 37.55702], [-121.80108, 37.55707], [-121.80111, 37.56421], [-121.80659, 37.56424], [-121.83004, 37.5643], [-121.83002, 37.56079], [-121.83412, 37.56075], [-121.83379, 37.54986], [-121.84302, 37.54992], [-121.84321, 37.53688], [-121.84359, 37.53692], [-121.84373, 37.53692], [-121.84384, 37.53694], [-121.84415, 37.53703], [-121.84434, 37.53704], [-121.84444, 37.53701], [-121.84463, 37.53699], [-121.84522, 37.53709], [-121.84552, 37.53705], [-121.84582, 37.53694], [-121.84617, 37.53694], [-121.84646, 37.53688], [-121.84684, 37.53674], [-121.84716, 37.53648], [-121.84735, 37.53629], [-121.84772, 37.53609], [-121.84796, 37.53606], [-121.84833, 37.53615], [-121.84871, 37.53615], [-121.8493, 37.53591], [-121.84978, 37.53595], [-121.85, 37.53589], [-121.85023, 37.5359], [-121.85049, 37.53588], [-121.85089, 37.53583], [-121.85142, 37.53574], [-121.85196, 37.53559], [-121.85226, 37.53555], [-121.85263, 37.53557], [-121.8528, 37.53564], [-121.85303, 37.53568], [-121.85303, 37.53566], [-121.85287, 37.53547], [-121.85267, 37.53514], [-121.85237, 37.5348], [-121.85191, 37.53405], [-121.85171, 37.53351], [-121.85168, 37.5327], [-121.85203, 37.53169], [-121.85209, 37.5316], [-121.85212, 37.53149], [-121.85263, 37.5307], [-121.85277, 37.53054], [-121.85276, 37.53032], [-121.85271, 37.53019], [-121.85304, 37.53025], [-121.85308, 37.53044], [-121.85356, 37.53043], [-121.85474, 37.53091], [-121.85545, 37.53365], [-121.85593, 37.53399], [-121.85602, 37.53431], [-121.85607, 37.53469], [-121.85699, 37.53534], [-121.85796, 37.5364], [-121.85795, 37.53698], [-121.85706, 37.53799], [-121.85711, 37.53827], [-121.85743, 37.53873], [-121.85775, 37.5391], [-121.85784, 37.53962], [-121.85776, 37.53985], [-121.85748, 37.54004], [-121.8583, 37.54118], [-121.86353, 37.54128], [-121.86876, 37.54132], [-121.86872, 37.54202], [-121.86881, 37.54203], [-121.86853, 37.54853], [-121.87777, 37.5487], [-121.87772, 37.55591], [-121.88367, 37.56239], [-121.88792, 37.56245], [-121.88737, 37.5628], [-121.88555, 37.56433], [-121.88473, 37.56514], [-121.88422, 37.56581], [-121.88383, 37.56677], [-121.88363, 37.56767], [-121.88289, 37.56655], [-121.87588, 37.56873], [-121.87359, 37.56389], [-121.87433, 37.56394], [-121.87434, 37.56392], [-121.87182, 37.55949], [-121.87054, 37.55965], [-121.86967, 37.55838], [-121.86646, 37.55893], [-121.86683, 37.55955], [-121.86737, 37.56007], [-121.86796, 37.56061], [-121.86822, 37.56105], [-121.86838, 37.56164], [-121.86852, 37.56205], [-121.86902, 37.56287], [-121.86932, 37.56316], [-121.86983, 37.56407], [-121.86994, 37.56438], [-121.87011, 37.56499], [-121.87052, 37.56575], [-121.87163, 37.56752], [-121.87212, 37.56842], [-121.87268, 37.56936], [-121.87334, 37.57057], [-121.87385, 37.5716], [-121.8742, 37.57256], [-121.87457, 37.57364], [-121.87464, 37.57422], [-121.87466, 37.57468], [-121.87446, 37.57505], [-121.87432, 37.57549], [-121.87432, 37.57589], [-121.87451, 37.57632], [-121.87488, 37.57667], [-121.87523, 37.57686], [-121.87572, 37.57725], [-121.87623, 37.57774], [-121.87727, 37.57843], [-121.87827, 37.57765], [-121.87945, 37.57681], [-121.88062, 37.57626], [-121.88185, 37.57589], [-121.88547, 37.57537], [-121.88675, 37.57441], [-121.88784, 37.57368], [-121.89152, 37.57192], [-121.89421, 37.57061], [-121.89475, 37.57098], [-121.89846, 37.57472], [-121.89959, 37.5745], [-121.90226, 37.58205], [-121.90273, 37.58256], [-121.90382, 37.58353], [-121.90441, 37.58374], [-121.905, 37.5839], [-121.9055, 37.58398], [-121.90573, 37.58405], [-121.90595, 37.58408], [-121.90624, 37.58416], [-121.9064, 37.58417], [-121.90762, 37.58414], [-121.90808, 37.58424], [-121.90897, 37.58425], [-121.90915, 37.58423], [-121.91012, 37.58425], [-121.91119, 37.58414], [-121.9119, 37.58423], [-121.91202, 37.58427], [-121.91219, 37.58429], [-121.91256, 37.5843], [-121.91316, 37.58444], [-121.91329, 37.58454], [-121.91386, 37.58472], [-121.91427, 37.58614], [-121.91474, 37.58654], [-121.9225, 37.59049], [-121.9275, 37.58729], [-121.92784, 37.58575], [-121.92993, 37.58591], [-121.93276, 37.59108], [-121.93278, 37.59108], [-121.93276, 37.59073], [-121.93717, 37.59057], [-121.93766, 37.59076], [-121.93777, 37.59095], [-121.93838, 37.59124], [-121.93886, 37.59122], [-121.93897, 37.59126], [-121.93899, 37.59152], [-121.93939, 37.59171], [-121.93954, 37.5932], [-121.9395, 37.59431], [-121.94454, 37.59589]], [[-121.86961, 37.55723], [-121.86962, 37.55722], [-121.86724, 37.55421], [-121.86443, 37.55485], [-121.86549, 37.55604], [-121.86566, 37.55668], [-121.86615, 37.55767], [-121.86961, 37.55723]]], [[[-121.85097, 37.4845], [-121.85077, 37.48814], [-121.84666, 37.48816], [-121.84646, 37.49134], [-121.84263, 37.49125], [-121.84281, 37.49994], [-121.84289, 37.50646], [-121.83018, 37.50608], [-121.82899, 37.5048], [-121.82867, 37.50442], [-121.82791, 37.50396], [-121.82703, 37.50361], [-121.82642, 37.50342], [-121.82603, 37.50385], [-121.82564, 37.50399], [-121.82543, 37.50361], [-121.82524, 37.50319], [-121.82486, 37.50313], [-121.8222, 37.50333], [-121.82052, 37.5033], [-121.81987, 37.50434], [-121.81957, 37.50444], [-121.81978, 37.50496], [-121.81948, 37.50513], [-121.81907, 37.50437], [-121.81697, 37.5036], [-121.81576, 37.50409], [-121.81492, 37.50464], [-121.81415, 37.5054], [-121.81386, 37.50563], [-121.80686, 37.50544], [-121.79132, 37.50475], [-121.7734, 37.50472], [-121.75468, 37.50453], [-121.75463, 37.49994], [-121.75464, 37.49101], [-121.7732, 37.49074], [-121.77317, 37.48541], [-121.77316, 37.4854], [-121.77318, 37.48406], [-121.79079, 37.48417], [-121.79589, 37.48398], [-121.80073, 37.48399], [-121.82337, 37.48423], [-121.83148, 37.48424], [-121.83287, 37.48434], [-121.84627, 37.48444], [-121.85057, 37.48444], [-121.85097, 37.4845]]], [[[-121.86477, 37.49128], [-121.86466, 37.49523], [-121.8601, 37.49519], [-121.86005, 37.49904], [-121.85565, 37.49892], [-121.85582, 37.49136], [-121.85594, 37.48769], [-121.8603, 37.48777], [-121.86015, 37.49152], [-121.86477, 37.49128]]]]} | Restricted Access 2 | 23002 | San Francisco Watershed Lands | 24889 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | Alameda 17 | 19552.964 | San Francisco Watershed Lands | None 1015 |
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]);