units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where COUNTY = 42 and DES_TP = 14
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV
MNG_AGENCY 3
MNG_AG_TYP 2
- County Agency 52
- City Agency 15
DES_TP 1
- Local Other or Unknown · 67 ✖
ACCESS_TYP 1
- Open Access 67
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3937 | 3937 | 3936 | {"type": "Polygon", "coordinates": [[[-121.54941, 39.51629], [-121.54933, 39.51642], [-121.54896, 39.51663], [-121.5493, 39.51711], [-121.54902, 39.51728], [-121.54868, 39.51754], [-121.54854, 39.51757], [-121.54836, 39.5177], [-121.5483, 39.5178], [-121.54817, 39.51791], [-121.54785, 39.51803], [-121.54782, 39.51812], [-121.54772, 39.5182], [-121.54767, 39.51838], [-121.54759, 39.51845], [-121.54743, 39.51858], [-121.54739, 39.51863], [-121.54739, 39.51869], [-121.54719, 39.51869], [-121.5476, 39.51762], [-121.54795, 39.51685], [-121.54912, 39.5164], [-121.54871, 39.51678], [-121.54874, 39.51683], [-121.54926, 39.51634], [-121.54941, 39.51629]]]} | Open Access 1 | 36306 | Oroville holding 1 | 23210 | 1236 | Oroville, City of 503 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | Butte 42 | 3.965 | Oroville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
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 | |
3959 | 3959 | 3958 | {"type": "Polygon", "coordinates": [[[-121.52553, 39.49686], [-121.52517, 39.49686], [-121.52516, 39.49683], [-121.52512, 39.49638], [-121.52533, 39.49635], [-121.52535, 39.49633], [-121.5255, 39.49633], [-121.52553, 39.49686]]]} | Open Access 1 | 36531 | Oroville holding 4 | 23216 | 1236 | Oroville, City of 503 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | Butte 42 | 0.453 | Oroville holding 4 | 0 | Local Other or Unknown 14 | 4 | |
3960 | 3960 | 3959 | {"type": "Polygon", "coordinates": [[[-121.5518, 39.51089], [-121.55165, 39.51093], [-121.55154, 39.51092], [-121.55145, 39.51088], [-121.55137, 39.51082], [-121.55163, 39.51069], [-121.5518, 39.51089]]]} | Open Access 1 | 36532 | Oroville holding 6 | 23218 | 1236 | Oroville, City of 503 | City 2 | City Agency 2 | http://www.cityoforoville.org/index.aspx?page=112 | City 2 | 1236 | Oroville, City of 495 | City 2 | City Agency 2 | Butte 42 | 0.134 | Oroville holding 6 | 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 |
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]);