units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
53 rows where AGNCY_TYP = 3, MNG_AGENCY = 692 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
DES_TP 2
MNG_AG_TYP 1
- County Agency · 53 ✖
MNG_AGENCY 1
- Butte, County of · 53 ✖
ACCESS_TYP 1
- Open Access 53
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3939 | 3939 | 3938 | {"type": "Polygon", "coordinates": [[[-121.62744, 39.74865], [-121.62744, 39.74881], [-121.62673, 39.74875], [-121.62673, 39.74859], [-121.62744, 39.74865]]]} | Open Access 1 | 36311 | Butte holding 14 | 16557 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.271 | Butte holding 14 | 0 | Local Other or Unknown 14 | 4 | |
3999 | 3999 | 3998 | {"type": "Polygon", "coordinates": [[[-121.80809, 39.64191], [-121.80809, 39.64239], [-121.80736, 39.6424], [-121.80735, 39.64235], [-121.80731, 39.6423], [-121.80725, 39.64227], [-121.80719, 39.64226], [-121.80719, 39.64192], [-121.80809, 39.64191]]]} | Open Access 1 | 43009 | Butte holding 28 | 16572 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.985 | Butte holding 28 | 0 | Local Other or Unknown 14 | 4 | |
4000 | 4000 | 3999 | {"type": "Polygon", "coordinates": [[[-121.7975, 39.63935], [-121.79716, 39.63942], [-121.797, 39.63897], [-121.79721, 39.63893], [-121.79729, 39.63902], [-121.7975, 39.63935]]]} | Open Access 1 | 43010 | Butte holding 29 | 16573 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.324 | Butte holding 29 | 0 | Local Other or Unknown 14 | 4 | |
4001 | 4001 | 4000 | {"type": "Polygon", "coordinates": [[[-121.50716, 39.77435], [-121.50641, 39.77428], [-121.50606, 39.77367], [-121.50686, 39.77374], [-121.50716, 39.77435]]]} | Open Access 1 | 43011 | Butte holding 24 | 16568 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.051 | Butte holding 24 | 0 | Local Other or Unknown 14 | 4 | |
4002 | 4002 | 4001 | {"type": "Polygon", "coordinates": [[[-121.27835, 39.52723], [-121.27753, 39.52727], [-121.27742, 39.52663], [-121.27778, 39.52662], [-121.27814, 39.52652], [-121.27835, 39.52723]]]} | Open Access 1 | 43012 | Butte holding 25 | 16569 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.222 | Butte holding 25 | 0 | Local Other or Unknown 14 | 4 | |
4003 | 4003 | 4002 | {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} | Open Access 1 | 43013 | Butte holding 23 | 16567 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.385 | Butte holding 23 | 0 | Local Other or Unknown 14 | 4 | |
5122 | 5122 | 5121 | {"type": "Polygon", "coordinates": [[[-121.80588, 39.70418], [-121.80579, 39.70421], [-121.80148, 39.69811], [-121.80159, 39.69805], [-121.80588, 39.70418]]]} | Open Access 1 | 35946 | Butte holding 48 | 16592 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.819 | Butte holding 48 | 0 | Local Other or Unknown 14 | 4 | |
5123 | 5123 | 5122 | {"type": "Polygon", "coordinates": [[[-121.1614, 39.53296], [-121.16104, 39.53302], [-121.16102, 39.53249], [-121.16138, 39.53242], [-121.1614, 39.53296]]]} | Open Access 1 | 35947 | Butte holding 53 | 16598 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.464 | Butte holding 53 | 0 | Local Other or Unknown 14 | 4 | |
12435 | 12435 | 12434 | {"type": "Polygon", "coordinates": [[[-121.86522, 39.77272], [-121.86522, 39.77272], [-121.86339, 39.77381], [-121.86334, 39.77367], [-121.86511, 39.77261], [-121.86522, 39.77272]]]} | Open Access 1 | 36273 | Butte holding 3 | 16574 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.736 | Butte holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13198 | 13198 | 13197 | {"type": "Polygon", "coordinates": [[[-121.48678, 39.51389], [-121.48532, 39.5139], [-121.48532, 39.51387], [-121.48603, 39.51387], [-121.48603, 39.51308], [-121.48676, 39.51308], [-121.48678, 39.51389]]]} | Open Access 1 | 36274 | Butte holding 1 | 16552 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.474 | Butte holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13388 | 13388 | 13387 | {"type": "Polygon", "coordinates": [[[-121.53269, 39.46596], [-121.53184, 39.46602], [-121.5318, 39.46567], [-121.53264, 39.4656], [-121.53269, 39.46596]]]} | Open Access 1 | 36275 | Butte holding 2 | 16563 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.717 | Butte holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13578 | 13578 | 13577 | {"type": "Polygon", "coordinates": [[[-121.16103, 39.53302], [-121.16075, 39.53306], [-121.16074, 39.53253], [-121.16102, 39.53249], [-121.16103, 39.53302]]]} | Open Access 1 | 35944 | Butte holding 46 | 16590 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.356 | Butte holding 46 | 0 | Local Other or Unknown 14 | 4 | |
13584 | 13584 | 13583 | {"type": "Polygon", "coordinates": [[[-121.57928, 39.81699], [-121.57902, 39.81678], [-121.57879, 39.8165], [-121.5787, 39.81607], [-121.57872, 39.81466], [-121.57854, 39.81417], [-121.57834, 39.81346], [-121.57847, 39.81298], [-121.5786, 39.81301], [-121.57885, 39.81322], [-121.57904, 39.81347], [-121.57916, 39.81374], [-121.57928, 39.81699]]]} | Open Access 1 | 35934 | Butte holding 20 | 16564 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 4.825 | Butte holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13586 | 13586 | 13585 | {"type": "Polygon", "coordinates": [[[-121.57946, 39.50391], [-121.57904, 39.50395], [-121.57906, 39.50363], [-121.57941, 39.5036], [-121.57946, 39.50391]]]} | Open Access 1 | 35945 | Butte holding 51 | 16596 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.284 | Butte holding 51 | 0 | Local Other or Unknown 14 | 4 | |
13593 | 13593 | 13592 | {"type": "Polygon", "coordinates": [[[-121.81614, 39.72758], [-121.81561, 39.72764], [-121.8156, 39.7274], [-121.81609, 39.72734], [-121.81614, 39.72758]]]} | Open Access 1 | 35929 | Butte holding 9 | 16603 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.296 | Butte holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13594 | 13594 | 13593 | {"type": "Polygon", "coordinates": [[[-121.53726, 39.64644], [-121.53646, 39.64655], [-121.53638, 39.64653], [-121.53648, 39.6463], [-121.53726, 39.64644]]]} | Open Access 1 | 35930 | Butte holding 10 | 16553 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.247 | Butte holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13595 | 13595 | 13594 | {"type": "Polygon", "coordinates": [[[-121.61208, 39.72671], [-121.60777, 39.72668], [-121.60772, 39.7261], [-121.60769, 39.72288], [-121.60304, 39.7229], [-121.60303, 39.71914], [-121.60293, 39.71547], [-121.61115, 39.71532], [-121.61116, 39.71564], [-121.61134, 39.71647], [-121.61138, 39.71681], [-121.61138, 39.71717], [-121.61134, 39.71753], [-121.61115, 39.71824], [-121.61107, 39.71861], [-121.61105, 39.71879], [-121.61106, 39.71929], [-121.61111, 39.71986], [-121.61116, 39.72021], [-121.61121, 39.72038], [-121.61133, 39.72069], [-121.61186, 39.72153], [-121.61198, 39.72181], [-121.61206, 39.7221], [-121.61208, 39.72238], [-121.61207, 39.72253], [-121.61177, 39.72497], [-121.61175, 39.72529], [-121.61177, 39.72559], [-121.61184, 39.72605], [-121.61198, 39.72649], [-121.61208, 39.72671]]]} | Open Access 1 | 35931 | Butte holding 5 | 16594 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 185.288 | Butte holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13596 | 13596 | 13595 | {"type": "Polygon", "coordinates": [[[-121.80054, 39.64365], [-121.8001, 39.64376], [-121.80003, 39.64358], [-121.80048, 39.64347], [-121.80054, 39.64365]]]} | Open Access 1 | 35932 | Butte holding 11 | 16554 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.215 | Butte holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13597 | 13597 | 13596 | {"type": "Polygon", "coordinates": [[[-121.58711, 39.81342], [-121.58621, 39.81385], [-121.58619, 39.81385], [-121.58633, 39.81373], [-121.58677, 39.81349], [-121.58711, 39.81342]]]} | Open Access 1 | 35933 | Butte holding 21 | 16565 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.131 | Butte holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13603 | 13603 | 13602 | {"type": "Polygon", "coordinates": [[[-121.79912, 39.69447], [-121.79903, 39.69458], [-121.7988, 39.69425], [-121.79726, 39.68583], [-121.79742, 39.68583], [-121.79873, 39.69292], [-121.79901, 39.69432], [-121.79912, 39.69447]]]} | Open Access 1 | 35948 | Butte holding 47 | 16591 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 3.509 | Butte holding 47 | 0 | Local Other or Unknown 14 | 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]);