units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

8 rows where ACCESS_TYP = 3, GAP_STS = 4 and MNG_AGENCY = 17

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of General Services · 8 ✖

ACCESS_TYP 1

  • No Public Access · 8 ✖
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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);