units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where DES_TP = 14 and MNG_AGENCY = 474 sorted by map
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 25
MNG_AGENCY 1
- California City, City of · 25 ✖
DES_TP 1
- Local Other or Unknown · 25 ✖
ACCESS_TYP 1
- Open Access 25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13397 | 13397 | 13396 | {"type": "Polygon", "coordinates": [[[-117.65941, 35.24431], [-117.65836, 35.24432], [-117.65836, 35.24364], [-117.65828, 35.24315], [-117.65816, 35.24293], [-117.65919, 35.24387], [-117.65941, 35.24431]]]} | Open Access 1 | 35523 | California City holding 5 | 16709 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 1.923 | California City holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13493 | 13493 | 13492 | {"type": "Polygon", "coordinates": [[[-117.66203, 35.241], [-117.66202, 35.24427], [-117.65941, 35.24431], [-117.65919, 35.24387], [-117.65816, 35.24293], [-117.65836, 35.24106], [-117.66203, 35.241]]]} | Open Access 1 | 35798 | California City holding 15 | 16695 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 28.556 | California City holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13564 | 13564 | 13563 | {"type": "Polygon", "coordinates": [[[-117.66562, 35.18641], [-117.66149, 35.18644], [-117.65978, 35.18627], [-117.65981, 35.18583], [-117.66561, 35.18594], [-117.66562, 35.18641]]]} | Open Access 1 | 35919 | California City holding 19 | 16699 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 7.56 | California City holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13510 | 13510 | 13509 | {"type": "Polygon", "coordinates": [[[-117.66564, 35.18745], [-117.66446, 35.18721], [-117.66334, 35.1867], [-117.66264, 35.18668], [-117.66149, 35.18644], [-117.66562, 35.18641], [-117.66564, 35.18745]]]} | Open Access 1 | 35800 | California City holding 12 | 16692 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 4.987 | California City holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13587 | 13587 | 13586 | {"type": "Polygon", "coordinates": [[[-117.66566, 35.18855], [-117.65975, 35.1885], [-117.65978, 35.18627], [-117.66149, 35.18644], [-117.66264, 35.18668], [-117.66334, 35.1867], [-117.66446, 35.18721], [-117.66564, 35.18745], [-117.66566, 35.18855]]]} | Open Access 1 | 35920 | California City holding 20 | 16701 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 26.192 | California City holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13987 | 13987 | 13986 | {"type": "Polygon", "coordinates": [[[-117.77229, 35.1638], [-117.77201, 35.16434], [-117.77031, 35.16558], [-117.76994, 35.16597], [-117.76939, 35.167], [-117.76933, 35.16753], [-117.76956, 35.16838], [-117.76975, 35.16886], [-117.76969, 35.16945], [-117.76955, 35.16976], [-117.76951, 35.16914], [-117.76942, 35.16875], [-117.76841, 35.16875], [-117.7684, 35.16826], [-117.76877, 35.1674], [-117.76886, 35.16681], [-117.76891, 35.16627], [-117.76909, 35.16595], [-117.76953, 35.1653], [-117.76956, 35.16465], [-117.76953, 35.16448], [-117.77127, 35.16445], [-117.77162, 35.1644], [-117.77164, 35.16403], [-117.77151, 35.1636], [-117.76951, 35.16363], [-117.76956, 35.16306], [-117.77214, 35.16304], [-117.77216, 35.16319], [-117.77225, 35.16349], [-117.77229, 35.1638]]]} | Open Access 1 | 36670 | California City holding 10 | 16690 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 16.43 | California City holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13437 | 13437 | 13436 | {"type": "Polygon", "coordinates": [[[-117.77282, 35.16525], [-117.77268, 35.16555], [-117.77152, 35.16563], [-117.77156, 35.17038], [-117.77014, 35.17041], [-117.76958, 35.17041], [-117.76955, 35.16976], [-117.76969, 35.16945], [-117.76975, 35.16886], [-117.76956, 35.16838], [-117.76933, 35.16752], [-117.76939, 35.167], [-117.76994, 35.16597], [-117.77031, 35.16558], [-117.77201, 35.16434], [-117.77229, 35.1638], [-117.77241, 35.16416], [-117.77269, 35.16479], [-117.77282, 35.16525]]]} | Open Access 1 | 35570 | California City holding 11 | 16691 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 28.215 | California City holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13566 | 13566 | 13565 | {"type": "Polygon", "coordinates": [[[-117.78011, 35.24315], [-117.7801, 35.24321], [-117.77715, 35.24484], [-117.77692, 35.24464], [-117.77674, 35.24445], [-117.77615, 35.2439], [-117.77531, 35.2432], [-117.77457, 35.24263], [-117.77554, 35.24168], [-117.77567, 35.24157], [-117.77596, 35.24141], [-117.77707, 35.24104], [-117.77785, 35.24206], [-117.77797, 35.24217], [-117.77812, 35.24229], [-117.77848, 35.24246], [-117.77941, 35.24264], [-117.7796, 35.2427], [-117.7798, 35.24282], [-117.78011, 35.24315]]]} | Open Access 1 | 35881 | California City holding 7 | 16711 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 25.731 | California City holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13556 | 13556 | 13555 | {"type": "Polygon", "coordinates": [[[-117.78144, 35.18139], [-117.78133, 35.18224], [-117.78107, 35.18291], [-117.78066, 35.18339], [-117.77995, 35.18383], [-117.77895, 35.18418], [-117.77676, 35.18527], [-117.77541, 35.18598], [-117.77414, 35.18683], [-117.77367, 35.1864], [-117.77319, 35.18585], [-117.77433, 35.18523], [-117.77557, 35.18426], [-117.77642, 35.18382], [-117.77685, 35.18375], [-117.7777, 35.18383], [-117.77809, 35.1837], [-117.77848, 35.18343], [-117.77881, 35.18305], [-117.77918, 35.1825], [-117.7797, 35.18139], [-117.78144, 35.18139]]]} | Open Access 1 | 35871 | California City holding 13 | 16693 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 29.954 | California City holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13554 | 13554 | 13553 | {"type": "Polygon", "coordinates": [[[-117.80335, 35.17567], [-117.80287, 35.17721], [-117.80288, 35.17729], [-117.80267, 35.17732], [-117.80235, 35.17739], [-117.79993, 35.17807], [-117.79977, 35.17641], [-117.79942, 35.17626], [-117.79986, 35.1756], [-117.80077, 35.176], [-117.80113, 35.17576], [-117.80117, 35.17569], [-117.80335, 35.17567]]]} | Open Access 1 | 35870 | California City holding 14 | 16694 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 15.956 | California City holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13537 | 13537 | 13536 | {"type": "Polygon", "coordinates": [[[-117.81267, 35.18624], [-117.81266, 35.18731], [-117.81188, 35.18733], [-117.81167, 35.1873], [-117.8115, 35.18723], [-117.81141, 35.18718], [-117.81134, 35.1871], [-117.81197, 35.18652], [-117.8121, 35.1864], [-117.81221, 35.18625], [-117.81267, 35.18624]]]} | Open Access 1 | 35843 | California City holding 2 | 16700 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 2.492 | California City holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13589 | 13589 | 13588 | {"type": "Polygon", "coordinates": [[[-117.81361, 35.18622], [-117.81361, 35.18722], [-117.81319, 35.1873], [-117.81266, 35.18731], [-117.81267, 35.18624], [-117.81361, 35.18622]]]} | Open Access 1 | 35923 | California City holding 18 | 16698 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 2.51 | California City holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13535 | 13535 | 13534 | {"type": "Polygon", "coordinates": [[[-117.81407, 35.17705], [-117.81403, 35.17719], [-117.81401, 35.17749], [-117.8139, 35.17769], [-117.81378, 35.1778], [-117.81366, 35.17787], [-117.81152, 35.17873], [-117.81123, 35.17822], [-117.81103, 35.17804], [-117.81085, 35.17757], [-117.81119, 35.17745], [-117.81157, 35.17728], [-117.81204, 35.17699], [-117.81239, 35.17673], [-117.8128, 35.1763], [-117.81407, 35.17705]]]} | Open Access 1 | 35841 | California City holding 3 | 16707 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 10.295 | California City holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13513 | 13513 | 13512 | {"type": "Polygon", "coordinates": [[[-117.81411, 35.18564], [-117.8141, 35.18621], [-117.81221, 35.18625], [-117.8123, 35.18612], [-117.81239, 35.18589], [-117.81244, 35.18568], [-117.81411, 35.18564]]]} | Open Access 1 | 35804 | California City holding 21 | 16702 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 2.485 | California City holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13418 | 13418 | 13417 | {"type": "Polygon", "coordinates": [[[-117.81414, 35.18511], [-117.81411, 35.18564], [-117.81244, 35.18568], [-117.81245, 35.18517], [-117.81414, 35.18511]]]} | Open Access 1 | 35530 | California City holding 24 | 16705 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 2.2 | California City holding 24 | 0 | Local Other or Unknown 14 | 4 | |
13561 | 13561 | 13560 | {"type": "Polygon", "coordinates": [[[-117.81414, 35.18511], [-117.8133, 35.18513], [-117.81245, 35.18517], [-117.81249, 35.18479], [-117.8133, 35.18474], [-117.81414, 35.18472], [-117.81414, 35.18511]]]} | Open Access 1 | 35876 | California City holding 9 | 16713 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 1.632 | California City holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13413 | 13413 | 13412 | {"type": "Polygon", "coordinates": [[[-117.81556, 35.1739], [-117.81451, 35.17651], [-117.81437, 35.17662], [-117.81426, 35.17673], [-117.81409, 35.17698], [-117.81407, 35.17705], [-117.8128, 35.1763], [-117.81303, 35.176], [-117.81314, 35.17583], [-117.81333, 35.17545], [-117.81389, 35.17413], [-117.8141, 35.17383], [-117.81423, 35.17373], [-117.81444, 35.1736], [-117.81469, 35.17352], [-117.81494, 35.17348], [-117.81529, 35.17347], [-117.8153, 35.1739], [-117.81556, 35.1739]]]} | Open Access 1 | 35524 | California City holding 25 | 16706 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 12.327 | California City holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13560 | 13560 | 13559 | {"type": "Polygon", "coordinates": [[[-117.81583, 35.18705], [-117.81579, 35.18708], [-117.8141, 35.18711], [-117.81361, 35.18722], [-117.81362, 35.18622], [-117.81582, 35.18618], [-117.81583, 35.18705]]]} | Open Access 1 | 35875 | California City holding 8 | 16712 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 5.054 | California City holding 8 | 0 | Local Other or Unknown 14 | 4 | |
3475 | 3475 | 3474 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18562], [-117.81582, 35.18618], [-117.8141, 35.18621], [-117.81412, 35.18564], [-117.81584, 35.18562]]]} | Open Access 1 | 35797 | California City holding 16 | 16696 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 2.424 | California City holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13536 | 13536 | 13535 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18507], [-117.81414, 35.18511], [-117.81414, 35.18472], [-117.81583, 35.18469], [-117.81584, 35.18507]]]} | Open Access 1 | 35842 | California City holding 4 | 16708 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 1.642 | California City holding 4 | 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]);