units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where COUNTY = 26 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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2551 | 2551 | 2550 | {"type": "Polygon", "coordinates": [[[-122.19184, 38.13515], [-122.19158, 38.13526], [-122.19131, 38.13478], [-122.19123, 38.13468], [-122.19099, 38.1342], [-122.19079, 38.13407], [-122.19041, 38.13416], [-122.1903, 38.13436], [-122.18981, 38.13471], [-122.18936, 38.13477], [-122.18846, 38.13375], [-122.18772, 38.13324], [-122.18704, 38.13336], [-122.18679, 38.13315], [-122.18649, 38.13293], [-122.18554, 38.13206], [-122.1861, 38.13174], [-122.18524, 38.13097], [-122.18589, 38.13091], [-122.18631, 38.13097], [-122.18726, 38.13107], [-122.18796, 38.13157], [-122.18847, 38.13188], [-122.18936, 38.13246], [-122.19034, 38.13316], [-122.19067, 38.13331], [-122.1909, 38.13352], [-122.19133, 38.13422], [-122.19156, 38.13457], [-122.19184, 38.13515]]]} | Restricted Access 2 | 17806 | McIntyre Ranch | 22040 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 23.753 | McIntyre Ranch | 0 | Local Other or Unknown 14 | 4 | |
| 3942 | 3942 | 3941 | {"type": "Polygon", "coordinates": [[[-121.96018, 38.34251], [-121.95925, 38.34317], [-121.95888, 38.3435], [-121.95879, 38.34331], [-121.95865, 38.34325], [-121.95856, 38.34319], [-121.95843, 38.34306], [-121.95841, 38.3429], [-121.95844, 38.34278], [-121.95839, 38.34272], [-121.95832, 38.34273], [-121.95806, 38.34289], [-121.95744, 38.34313], [-121.95728, 38.34315], [-121.95708, 38.34314], [-121.95687, 38.3431], [-121.95677, 38.34313], [-121.95666, 38.3432], [-121.95654, 38.34332], [-121.95649, 38.34339], [-121.95645, 38.3435], [-121.95622, 38.34364], [-121.95602, 38.3438], [-121.95594, 38.34394], [-121.95593, 38.3442], [-121.9559, 38.34432], [-121.95572, 38.34448], [-121.95548, 38.34459], [-121.95519, 38.34469], [-121.95466, 38.34491], [-121.9543, 38.34514], [-121.95404, 38.34527], [-121.95334, 38.3455], [-121.95335, 38.34531], [-121.95334, 38.34466], [-121.95369, 38.34465], [-121.95405, 38.34447], [-121.9543, 38.34445], [-121.9545, 38.34439], [-121.95493, 38.34439], [-121.95497, 38.34427], [-121.95506, 38.34424], [-121.95534, 38.34422], [-121.95571, 38.34376], [-121.95574, 38.34359], [-121.95582, 38.34356], [-121.95586, 38.3435], [-121.9559, 38.34349], [-121.95614, 38.34326], [-121.95648, 38.34299], [-121.95649, 38.34293], [-121.95655, 38.34289], [-121.95662, 38.3429], [-121.9568, 38.34276], [-121.95782, 38.34275], [-121.95823, 38.34253], [-121.95852, 38.34243], [-121.95867, 38.34241], [-121.96018, 38.34251]]]} | Open Access 1 | 36342 | Vacaville holding 1 | 26753 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 8.609 | Vacaville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
| 13013 | 13013 | 13012 | {"type": "MultiPolygon", "coordinates": [[[[-121.91526, 38.26143], [-121.91525, 38.26144], [-121.91516, 38.26502], [-121.90682, 38.27189], [-121.89801, 38.2782], [-121.89805, 38.27195], [-121.89805, 38.26472], [-121.87929, 38.26469], [-121.87927, 38.27171], [-121.87387, 38.27167], [-121.87397, 38.27128], [-121.87929, 38.26469], [-121.89614, 38.24998], [-121.89617, 38.24991], [-121.89819, 38.24991], [-121.89826, 38.24289], [-121.91522, 38.24301], [-121.91521, 38.25733], [-121.91525, 38.26116], [-121.91523, 38.26117], [-121.91526, 38.26143]]], [[[-121.91491, 38.27353], [-121.91447, 38.28644], [-121.90677, 38.28644], [-121.89698, 38.28637], [-121.90575, 38.28009], [-121.90633, 38.27971], [-121.91491, 38.27353]]]]} | No Public Access 3 | 31205 | Wilcox Ranch | 27494 | 344 | Solano, County of 1037 | County 3 | County Agency 3 | http://www.co.solano.ca.us/depts/rm/countypark/homepage.asp | County 3 | 344 | Solano, County of 999 | County 3 | County Agency 3 | Solano 26 | 1870.595 | Wilcox Ranch | 0 | Local Other or Unknown 14 | 4 | |
| 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 | |
| 13793 | 13793 | 13792 | {"type": "Polygon", "coordinates": [[[-122.27659, 38.12585], [-122.27653, 38.12614], [-122.27436, 38.12596], [-122.27377, 38.12604], [-122.2735, 38.12621], [-122.27296, 38.12726], [-122.27264, 38.127], [-122.27238, 38.12688], [-122.27137, 38.1267], [-122.27073, 38.1267], [-122.26972, 38.12673], [-122.26882, 38.12673], [-122.2686, 38.12664], [-122.26957, 38.12564], [-122.27074, 38.12565], [-122.27154, 38.12519], [-122.27256, 38.12469], [-122.27347, 38.12403], [-122.27385, 38.12357], [-122.27422, 38.12319], [-122.27481, 38.12286], [-122.27546, 38.12227], [-122.27609, 38.12257], [-122.2763, 38.12316], [-122.27645, 38.12379], [-122.27639, 38.12421], [-122.27607, 38.12463], [-122.27575, 38.12484], [-122.27511, 38.12496], [-122.2741, 38.125], [-122.27379, 38.12521], [-122.2742, 38.12542], [-122.27516, 38.12546], [-122.27622, 38.12572], [-122.27659, 38.12585]]]} | Open Access 1 | 36360 | Vallejo holding 1 | 26778 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 35.154 | Vallejo holding 1 | 0 | Local Other or Unknown 14 | 4 | |
| 13807 | 13807 | 13806 | {"type": "Polygon", "coordinates": [[[-122.01497, 38.28933], [-122.01455, 38.28938], [-122.01421, 38.28953], [-122.01412, 38.28954], [-122.01398, 38.2895], [-122.01352, 38.28967], [-122.01353, 38.28977], [-122.0136, 38.28997], [-122.01351, 38.29013], [-122.01313, 38.28976], [-122.01302, 38.28933], [-122.01314, 38.2891], [-122.01337, 38.28884], [-122.01336, 38.28882], [-122.0137, 38.28834], [-122.01375, 38.28784], [-122.01373, 38.28782], [-122.01375, 38.28782], [-122.01406, 38.28783], [-122.01457, 38.28804], [-122.01493, 38.28826], [-122.01503, 38.28868], [-122.01495, 38.28906], [-122.01497, 38.28933]]]} | Open Access 1 | 36384 | Fairfield holding 1 | 18795 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 6.146 | Fairfield holding 1 | 0 | Local Other or Unknown 14 | 4 | |
| 13982 | 13982 | 13981 | {"type": "Polygon", "coordinates": [[[-121.82236, 38.44685], [-121.82236, 38.44746], [-121.82165, 38.44744], [-121.82164, 38.44684], [-121.82236, 38.44685]]]} | Open Access 1 | 36652 | Dixon holding 1 | 18172 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 1.036 | Dixon holding 1 | 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]);