units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
663 rows where DES_TP = 14 and MNG_AG_TYP = 2 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 46
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- Watsonville, City of 7
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Salinas, City of 5
- Stockton, City of 5
- San Marcos, City of 4
- Marina, City of 4
- Morgan Hill, City of 4
- Lincoln, City of 4
- …
ACCESS_TYP 4
- Open Access 563
- No Public Access 59
- Unknown Access 16
- Restricted Access 5
MNG_AG_TYP 1
- City Agency · 643 ✖
DES_TP 1
- Local Other or Unknown · 643 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13647 | 13647 | 13646 | {"type": "Polygon", "coordinates": [[[-122.15828, 38.05398], [-122.15776, 38.05473], [-122.1558, 38.05383], [-122.1562, 38.05302], [-122.15828, 38.05398]]]} | Open Access 1 | 36331 | Benicia holding 1 | 16011 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 4.824 | Benicia holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13706 | 13706 | 13705 | {"type": "Polygon", "coordinates": [[[-122.40221, 37.68489], [-122.40183, 37.68563], [-122.40176, 37.68569], [-122.40168, 37.68572], [-122.40158, 37.6857], [-122.4007, 37.68516], [-122.4005, 37.68506], [-122.40004, 37.685], [-122.40002, 37.68486], [-122.40221, 37.68489]]]} | Open Access 1 | 36302 | Brisbane holding 1 | 16400 | 1035 | Brisbane, City of 686 | City 2 | City Agency 2 | http://www.ci.brisbane.ca.us/about-parks-and-recreation | City 2 | 1035 | Brisbane, City of 677 | City 2 | City Agency 2 | San Mateo 15 | 2.326 | Brisbane holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13749 | 13749 | 13748 | {"type": "Polygon", "coordinates": [[[-122.37518, 37.59189], [-122.3749, 37.59222], [-122.3742, 37.59192], [-122.37418, 37.59193], [-122.37406, 37.59188], [-122.37411, 37.59183], [-122.37372, 37.59124], [-122.37402, 37.59096], [-122.3745, 37.59123], [-122.37449, 37.59133], [-122.37451, 37.59142], [-122.37456, 37.59151], [-122.37463, 37.59159], [-122.37518, 37.59189]]]} | Open Access 1 | 36283 | Burlingame holding 1 | 16523 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 1.913 | Burlingame holding 1 | 1940 | 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 | |
3886 | 3886 | 3885 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25106], [-117.82674, 35.25113], [-117.82627, 35.25163], [-117.82615, 35.25189], [-117.8261, 35.25307], [-117.82591, 35.25347], [-117.82372, 35.25348], [-117.82367, 35.25201], [-117.82381, 35.25191], [-117.82507, 35.25133], [-117.82579, 35.25117], [-117.82685, 35.25106]]]} | Open Access 1 | 35754 | California City holding 22 | 16703 | 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.685 | California City holding 22 | 0 | Local Other or Unknown 14 | 4 | |
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 | |
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 | |
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 | |
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 | |
13479 | 13479 | 13478 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25105], [-117.82579, 35.25117], [-117.82507, 35.25133], [-117.82381, 35.25191], [-117.82367, 35.25201], [-117.82363, 35.25017], [-117.82683, 35.25021], [-117.82685, 35.25105]]]} | Open Access 1 | 35759 | California City holding 23 | 16704 | 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 | 9.538 | California City holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13490 | 13490 | 13489 | {"type": "Polygon", "coordinates": [[[-117.82688, 35.25347], [-117.82591, 35.25347], [-117.8261, 35.25307], [-117.82615, 35.25189], [-117.82627, 35.25163], [-117.82674, 35.25113], [-117.82685, 35.25106], [-117.82688, 35.25347]]]} | Open Access 1 | 35777 | California City holding 1 | 16689 | 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 | 3.931 | California City holding 1 | 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 | |
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 | |
13511 | 13511 | 13510 | {"type": "Polygon", "coordinates": [[[-117.82635, 35.20202], [-117.82297, 35.20203], [-117.82299, 35.20178], [-117.82297, 35.19927], [-117.8263, 35.19926], [-117.82635, 35.20202]]]} | Open Access 1 | 35801 | California City holding 17 | 16697 | 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 | 23.044 | California City holding 17 | 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 | |
13534 | 13534 | 13533 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18507], [-117.81584, 35.18562], [-117.81412, 35.18564], [-117.81414, 35.18511], [-117.81584, 35.18507]]]} | Open Access 1 | 35840 | California City holding 6 | 16710 | 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.314 | California City holding 6 | 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 | |
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 | |
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 | |
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 |
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]);