units_with_maps

Table actions

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

1 row where AGNCY_WEB = "http://www.sanramon.ca.gov/engr/ghad.html", MNG_AGENCY = 68 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • San Ramon, City of · 1 ✖

ACCESS_TYP 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
7251 7251 7250 {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} Open Access 1 48920 Dougherty Valley Ridge Trail 33643 2300 Geologic Hazard Abatement District (San Ramon) 853 Special District 4 Special District - Other 26 http://www.sanramon.ca.gov/engr/ghad.html Special District 4 1313 San Ramon, City of 68 City 2 City Agency 2 http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail Contra Costa 12 89.586 Dougherty Valley Ridge Trail 0 Local Recreation Area 3 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]);