units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 474
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2109 | 2109 | 2108 | {"type": "Polygon", "coordinates": [[[-117.70274, 35.27024], [-117.69774, 35.27032], [-117.69769, 35.26783], [-117.70266, 35.26773], [-117.70274, 35.27024]]]} | Open Access 1 | 15893 | E Park | 18331 | 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 | 31.117 | E Park | 0 | Local Park 2 | 4 | |
2111 | 2111 | 2110 | {"type": "Polygon", "coordinates": [[[-117.75932, 35.21794], [-117.75625, 35.21792], [-117.75623, 35.21688], [-117.75652, 35.21682], [-117.75643, 35.21662], [-117.75622, 35.21657], [-117.7562, 35.21523], [-117.75746, 35.21522], [-117.75749, 35.2144], [-117.7592, 35.21439], [-117.75928, 35.21695], [-117.75923, 35.21699], [-117.75928, 35.21713], [-117.75932, 35.21794]]]} | Open Access 1 | 15898 | Galileo Hill Park | 19174 | 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 | 24.025 | Galileo Hill Park | 0 | Local Park 2 | 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 | |
8658 | 8658 | 8657 | {"type": "Polygon", "coordinates": [[[-117.92768, 35.13802], [-117.92733, 35.1383], [-117.92725, 35.13823], [-117.92712, 35.13817], [-117.92695, 35.13813], [-117.92678, 35.13814], [-117.92677, 35.13795], [-117.92672, 35.13781], [-117.92654, 35.13763], [-117.92649, 35.1376], [-117.92638, 35.13756], [-117.92629, 35.13755], [-117.92619, 35.13756], [-117.92606, 35.13764], [-117.92596, 35.13774], [-117.92596, 35.1378], [-117.92602, 35.13782], [-117.92609, 35.13779], [-117.92611, 35.13772], [-117.92625, 35.13764], [-117.92636, 35.13764], [-117.92645, 35.13768], [-117.9266, 35.13781], [-117.92668, 35.13796], [-117.92668, 35.13803], [-117.92664, 35.13816], [-117.92652, 35.13828], [-117.92658, 35.13834], [-117.92669, 35.13826], [-117.92681, 35.13822], [-117.92694, 35.13822], [-117.92702, 35.13822], [-117.92711, 35.13826], [-117.92719, 35.1383], [-117.92725, 35.13837], [-117.92592, 35.13947], [-117.92459, 35.13832], [-117.92635, 35.13688], [-117.92768, 35.13802]]]} | Open Access 1 | 13893 | California City Memorial Park | 16714 | 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.379 | California City Memorial Park | 0 | Local Park 2 | 4 | |
9468 | 9468 | 9467 | {"type": "Polygon", "coordinates": [[[-117.78613, 35.15297], [-117.78142, 35.15322], [-117.78147, 35.15123], [-117.7846, 35.1512], [-117.78608, 35.15118], [-117.78613, 35.15297]]]} | Open Access 1 | 15916 | I Park | 20168 | 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 | 21.994 | I Park | 0 | Local Park 2 | 4 | |
9481 | 9481 | 9480 | {"type": "Polygon", "coordinates": [[[-118.00113, 35.13116], [-118.00109, 35.13151], [-118.00065, 35.13151], [-118.00029, 35.13147], [-117.99982, 35.13137], [-117.99964, 35.13132], [-117.9993, 35.13118], [-117.99892, 35.13098], [-117.9979, 35.1303], [-117.9976, 35.13013], [-117.9972, 35.12997], [-117.99715, 35.12993], [-117.99671, 35.12983], [-117.99674, 35.1294], [-117.99688, 35.12935], [-117.99695, 35.12927], [-117.997, 35.12919], [-117.99699, 35.12904], [-117.9971, 35.12863], [-117.99725, 35.12864], [-117.99772, 35.12875], [-117.99799, 35.12884], [-117.9985, 35.12905], [-117.99884, 35.12924], [-118.00029, 35.13017], [-118.00048, 35.13025], [-118.00093, 35.13035], [-118.00096, 35.13085], [-118.00094, 35.13094], [-118.00095, 35.13102], [-118.00106, 35.13113], [-118.00113, 35.13116]]]} | Open Access 1 | 15880 | Balsitis Park | 15791 | 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.001 | Balsitis Park | 0 | Local Park 2 | 4 | |
9489 | 9489 | 9488 | {"type": "Polygon", "coordinates": [[[-117.83929, 35.17301], [-117.83602, 35.1731], [-117.83577, 35.17263], [-117.8351, 35.17127], [-117.83534, 35.1712], [-117.83775, 35.17071], [-117.83802, 35.17037], [-117.83852, 35.17], [-117.83925, 35.16999], [-117.83929, 35.17301]]]} | Open Access 1 | 15885 | Borax Bill Park | 16276 | 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 | 22.749 | Borax Bill Park | 0 | Local Park 2 | 4 | |
9495 | 9495 | 9494 | {"type": "Polygon", "coordinates": [[[-117.71537, 35.19254], [-117.71535, 35.19456], [-117.71106, 35.19462], [-117.71102, 35.19263], [-117.71537, 35.19254]]]} | Open Access 1 | 15904 | H Park | 19580 | 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 | 21.645 | H Park | 0 | Local Park 2 | 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 |
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]);