units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_ID = 107 and AGNCY_TYP = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5852 | 5852 | 5851 | {"type": "Polygon", "coordinates": [[[-121.90637, 36.35669], [-121.90633, 36.35676], [-121.90633, 36.35686], [-121.90629, 36.35697], [-121.90629, 36.35703], [-121.90621, 36.35721], [-121.90613, 36.35728], [-121.90605, 36.35742], [-121.90597, 36.35746], [-121.90593, 36.35753], [-121.90584, 36.3576], [-121.9058, 36.35767], [-121.90564, 36.35774], [-121.90559, 36.35781], [-121.90551, 36.35785], [-121.90547, 36.35792], [-121.90535, 36.35803], [-121.90526, 36.35817], [-121.90518, 36.35824], [-121.90514, 36.35831], [-121.90498, 36.35845], [-121.90481, 36.35845], [-121.90468, 36.35849], [-121.9045, 36.3585], [-121.90434, 36.35864], [-121.9043, 36.35871], [-121.90422, 36.35875], [-121.90418, 36.35882], [-121.90409, 36.35885], [-121.90397, 36.35896], [-121.90389, 36.35907], [-121.90368, 36.35921], [-121.90351, 36.35935], [-121.90343, 36.35939], [-121.90339, 36.35946], [-121.90322, 36.3596], [-121.90318, 36.35967], [-121.9032, 36.36026], [-121.90325, 36.36033], [-121.90325, 36.3604], [-121.90339, 36.3606], [-121.90361, 36.36087], [-121.90361, 36.36094], [-121.9037, 36.36094], [-121.90409, 36.36107], [-121.90418, 36.36114], [-121.90444, 36.36127], [-121.9047, 36.36147], [-121.90475, 36.36157], [-121.90476, 36.36188], [-121.9046, 36.36202], [-121.90426, 36.36217], [-121.90405, 36.36218], [-121.90388, 36.36225], [-121.90379, 36.36225], [-121.90375, 36.36232], [-121.9035, 36.36247], [-121.90342, 36.36254], [-121.90333, 36.36258], [-121.90325, 36.36271], [-121.90317, 36.36279], [-121.90301, 36.363], [-121.90297, 36.3631], [-121.90284, 36.36324], [-121.90276, 36.36338], [-121.9026, 36.36356], [-121.90235, 36.36391], [-121.90223, 36.36412], [-121.9022, 36.36423], [-121.90221, 36.36478], [-121.90226, 36.36488], [-121.90227, 36.36502], [-121.90245, 36.36529], [-121.90258, 36.36546], [-121.90259, 36.36553], [-121.90268, 36.3657], [-121.9027, 36.36626], [-121.90266, 36.36633], [-121.90266, 36.3664], [-121.90258, 36.36657], [-121.90258, 36.36664], [-121.9025, 36.36678], [-121.90242, 36.36685], [-121.90234, 36.36699], [-121.90236, 36.36741], [-121.9024, 36.36748], [-121.9024, 36.36754], [-121.90245, 36.36761], [-121.90245, 36.36768], [-121.9025, 36.36775], [-121.9025, 36.36782], [-121.90255, 36.36789], [-121.90263, 36.36795], [-121.90272, 36.36809], [-121.90282, 36.36815], [-121.90284, 36.36822], [-121.9031, 36.36862], [-121.90316, 36.36876], [-121.90317, 36.36906], [-121.90316, 36.36923], [-121.9031, 36.36949], [-121.90306, 36.36957], [-121.90304, 36.36975], [-121.903, 36.36982], [-121.90298, 36.3701], [-121.90297, 36.37017], [-121.90299, 36.3704], [-121.90304, 36.37048], [-121.90307, 36.3706], [-121.8997, 36.37056], [-121.89579, 36.3698], [-121.89585, 36.36624], [-121.88699, 36.36665], [-121.88768, 36.35894], [-121.87939, 36.35881], [-121.87942, 36.35196], [-121.87442, 36.352], [-121.87452, 36.34856], [-121.87239, 36.34857], [-121.86962, 36.34855], [-121.86981, 36.34513], [-121.87945, 36.3451], [-121.89703, 36.34523], [-121.8972, 36.34544], [-121.89653, 36.35301], [-121.90369, 36.35314], [-121.90372, 36.35323], [-121.90364, 36.35334], [-121.90343, 36.35336], [-121.90334, 36.35342], [-121.90324, 36.35358], [-121.90323, 36.35373], [-121.90334, 36.35398], [-121.90343, 36.35415], [-121.90343, 36.35423], [-121.90358, 36.35463], [-121.90358, 36.35472], [-121.90371, 36.35495], [-121.90374, 36.35521], [-121.90383, 36.35537], [-121.90416, 36.35584], [-121.90419, 36.35592], [-121.9042, 36.35608], [-121.90424, 36.35616], [-121.9044, 36.35634], [-121.90462, 36.3565], [-121.90471, 36.35652], [-121.90505, 36.3565], [-121.90534, 36.35639], [-121.90546, 36.35637], [-121.90588, 36.3564], [-121.9061, 36.35646], [-121.90634, 36.35656], [-121.90637, 36.35669]]]} | Restricted Access 2 | 186 | Brazil Ranch | 16339 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Monterey 14 | 1184.534 | Brazil Ranch | 0 | Recreation Management Area 49 | 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]);