units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where GAP_STS = 4, MNG_AGENCY = 17 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency · 11 ✖
MNG_AGENCY 1
- California Department of General Services · 11 ✖
DES_TP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4590 | 4590 | 4589 | {"type": "Polygon", "coordinates": [[[-122.53085, 38.65457], [-122.52623, 38.65454], [-122.52626, 38.66281], [-122.52163, 38.66281], [-122.52162, 38.65813], [-122.52159, 38.65443], [-122.5216, 38.65086], [-122.52621, 38.65092], [-122.53085, 38.65095], [-122.53085, 38.65457]]]} | Open Access 1 | 35477 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 171.758 | 0 | State Other or Unknown 104 | 4 | ||
4604 | 4604 | 4603 | {"type": "Polygon", "coordinates": [[[-122.52162, 38.65813], [-122.51683, 38.65816], [-122.51708, 38.65772], [-122.517, 38.65768], [-122.51701, 38.65454], [-122.51243, 38.65456], [-122.51247, 38.65095], [-122.5216, 38.65086], [-122.52159, 38.65443], [-122.52162, 38.65813]]]} | Open Access 1 | 35702 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 119.087 | 0 | State Other or Unknown 104 | 4 | ||
4605 | 4605 | 4604 | {"type": "Polygon", "coordinates": [[[-122.122, 38.33618], [-122.12148, 38.33658], [-122.12116, 38.33673], [-122.12083, 38.33684], [-122.12005, 38.33619], [-122.1206, 38.33583], [-122.12117, 38.33549], [-122.122, 38.33618]]]} | No Public Access 3 | 35709 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 3.337 | 0 | State Other or Unknown 104 | 4 | ||
4622 | 4622 | 4621 | {"type": "Polygon", "coordinates": [[[-122.57831, 38.57459], [-122.57825, 38.5747], [-122.57785, 38.57457], [-122.57792, 38.57445], [-122.57831, 38.57459]]]} | No Public Access 3 | 36169 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.134 | 0 | State Other or Unknown 104 | 4 | ||
4625 | 4625 | 4624 | {"type": "Polygon", "coordinates": [[[-122.30619, 38.31262], [-122.30611, 38.31263], [-122.30598, 38.31222], [-122.30605, 38.3122], [-122.30619, 38.31262]]]} | No Public Access 3 | 36253 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.081 | 0 | State Other or Unknown 104 | 4 | ||
4626 | 4626 | 4625 | {"type": "Polygon", "coordinates": [[[-122.57086, 38.57153], [-122.57059, 38.57199], [-122.57035, 38.57175], [-122.57018, 38.5716], [-122.56976, 38.57131], [-122.56945, 38.57115], [-122.56889, 38.57091], [-122.56913, 38.57052], [-122.56989, 38.5711], [-122.57086, 38.57153]]]} | No Public Access 3 | 36255 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 1.713 | 0 | State Other or Unknown 104 | 4 | ||
4627 | 4627 | 4626 | {"type": "Polygon", "coordinates": [[[-122.12934, 38.45011], [-122.1247, 38.44986], [-122.1229, 38.44968], [-122.12294, 38.44961], [-122.12321, 38.44927], [-122.12353, 38.44842], [-122.12377, 38.44773], [-122.12385, 38.44729], [-122.12381, 38.44696], [-122.12383, 38.44653], [-122.12379, 38.44617], [-122.12468, 38.44627], [-122.12921, 38.44654], [-122.12934, 38.45011]]]} | No Public Access 3 | 36256 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 48.839 | 0 | State Other or Unknown 104 | 4 | ||
4678 | 4678 | 4677 | {"type": "Polygon", "coordinates": [[[-122.60006, 38.59944], [-122.59941, 38.60053], [-122.59885, 38.60029], [-122.5995, 38.59921], [-122.60006, 38.59944]]]} | No Public Access 3 | 36663 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 1.831 | 0 | State Other or Unknown 104 | 4 | ||
4680 | 4680 | 4679 | {"type": "Polygon", "coordinates": [[[-122.57285, 38.57309], [-122.57104, 38.57221], [-122.57064, 38.57205], [-122.57059, 38.57199], [-122.57086, 38.57153], [-122.57176, 38.57199], [-122.57199, 38.57244], [-122.57265, 38.57291], [-122.57285, 38.57309]]]} | No Public Access 3 | 43017 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 1.952 | 0 | State Other or Unknown 104 | 4 | ||
5656 | 5656 | 5655 | {"type": "Polygon", "coordinates": [[[-122.27035, 38.24032], [-122.27033, 38.24039], [-122.27027, 38.24044], [-122.26924, 38.24035], [-122.2691, 38.24036], [-122.26909, 38.24025], [-122.27035, 38.24032]]]} | No Public Access 3 | 43095 | Unnamed site - California Department of General Services | 28625 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.336 | 0 | State Other or Unknown 104 | 4 | ||
5657 | 5657 | 5656 | {"type": "Polygon", "coordinates": [[[-122.55331, 38.60735], [-122.54863, 38.60741], [-122.54854, 38.60384], [-122.55324, 38.60379], [-122.55331, 38.60735]]]} | Open Access 1 | 43096 | Unnamed site - California Department of General Services | 28627 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 40.016 | 0 | State Other or Unknown 104 | 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]);