units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2, COUNTY = 12 and DES_TP = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID

DES_TP 1

  • Local Conservation Area · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
7784 7784 7783 {"type": "Polygon", "coordinates": [[[-122.09793, 38.0339], [-122.09769, 38.03914], [-122.09158, 38.04066], [-122.09096, 38.03986], [-122.08905, 38.03774], [-122.08812, 38.03657], [-122.08732, 38.03561], [-122.08642, 38.03459], [-122.08564, 38.03378], [-122.08448, 38.0328], [-122.08348, 38.03204], [-122.08255, 38.03143], [-122.09011, 38.02928], [-122.09118, 38.03176], [-122.09429, 38.0309], [-122.09428, 38.03188], [-122.09338, 38.03401], [-122.09417, 38.03471], [-122.09447, 38.03495], [-122.09577, 38.03467], [-122.09706, 38.03377], [-122.09793, 38.0339]]]} Restricted Access 2 8772 Point Edith Wetlands 23847 300 Contra Costa County Public Works Dept., County of 429 County 3 County Agency - Other 9 http://www.co.contra-costa.ca.us/227/Public-Works County 3 300 Contra Costa County Public Works Dept., County of 423 County 3 County Agency - Other 8   Contra Costa 12 211.368 Point Edith Wetlands 2001 Local Conservation Area 4 2
16275 16275 16274 {"type": "Polygon", "coordinates": [[[-121.70305, 37.80995], [-121.70228, 37.80996], [-121.70228, 37.8138], [-121.70217, 37.81544], [-121.69737, 37.81188], [-121.69619, 37.81188], [-121.69618, 37.80997], [-121.69597, 37.80998], [-121.69595, 37.81134], [-121.69246, 37.81133], [-121.69231, 37.81105], [-121.69219, 37.81049], [-121.69215, 37.8104], [-121.69205, 37.81029], [-121.69172, 37.81009], [-121.69158, 37.80993], [-121.69153, 37.80989], [-121.69077, 37.80964], [-121.69067, 37.80963], [-121.69038, 37.80966], [-121.69025, 37.80969], [-121.69012, 37.80976], [-121.68984, 37.81006], [-121.68859, 37.80936], [-121.68849, 37.80894], [-121.68823, 37.80872], [-121.6869, 37.80815], [-121.68663, 37.80811], [-121.68639, 37.8082], [-121.68613, 37.80842], [-121.68569, 37.80872], [-121.68496, 37.80892], [-121.6842, 37.80889], [-121.68397, 37.80881], [-121.68178, 37.80814], [-121.6813, 37.80808], [-121.68029, 37.80828], [-121.67977, 37.80807], [-121.67968, 37.80764], [-121.68001, 37.80704], [-121.67996, 37.80685], [-121.67925, 37.80627], [-121.67892, 37.80629], [-121.678, 37.80698], [-121.67785, 37.80755], [-121.67689, 37.80772], [-121.67609, 37.8078], [-121.67572, 37.80766], [-121.67541, 37.80729], [-121.6751, 37.80698], [-121.67445, 37.80668], [-121.67429, 37.8064], [-121.67422, 37.80609], [-121.67438, 37.80564], [-121.67497, 37.80511], [-121.67539, 37.80335], [-121.67556, 37.80299], [-121.6757, 37.80256], [-121.67577, 37.80226], [-121.67581, 37.80197], [-121.67583, 37.8007], [-121.67592, 37.80004], [-121.67621, 37.79988], [-121.6761, 37.79964], [-121.67632, 37.79925], [-121.67685, 37.79862], [-121.67709, 37.79847], [-121.67819, 37.79809], [-121.68181, 37.79776], [-121.68233, 37.79749], [-121.68253, 37.79729], [-121.68296, 37.79701], [-121.68353, 37.79696], [-121.68502, 37.7972], [-121.6863, 37.7961], [-121.68737, 37.79489], [-121.68959, 37.79371], [-121.68963, 37.79366], [-121.69001, 37.79362], [-121.69006, 37.79365], [-121.69094, 37.7936], [-121.69142, 37.7931], [-121.69228, 37.79309], [-121.69245, 37.79302], [-121.69248, 37.79734], [-121.69593, 37.79734], [-121.69595, 37.80358], [-121.70305, 37.80995]]]} Restricted Access 2 47727 Vasco Caves Regional Preserve 31516 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Contra Costa 12 718.817 Vasco Caves RPr 1997 Local Conservation Area 4 2
16288 16288 16287 {"type": "Polygon", "coordinates": [[[-122.35803, 37.90099], [-122.35788, 37.9011], [-122.35775, 37.90094], [-122.35773, 37.90094], [-122.35775, 37.90181], [-122.35294, 37.90189], [-122.35282, 37.89694], [-122.35278, 37.8969], [-122.35261, 37.89649], [-122.35227, 37.89631], [-122.352, 37.89603], [-122.35174, 37.89554], [-122.35149, 37.89464], [-122.35146, 37.89464], [-122.35081, 37.89382], [-122.35107, 37.89355], [-122.35136, 37.8937], [-122.35141, 37.89407], [-122.35191, 37.89435], [-122.35246, 37.8945], [-122.35306, 37.89475], [-122.35457, 37.89471], [-122.35471, 37.89435], [-122.3563, 37.89461], [-122.35659, 37.89494], [-122.35687, 37.8949], [-122.35717, 37.89509], [-122.35742, 37.89558], [-122.3575, 37.89591], [-122.35721, 37.89654], [-122.35737, 37.89693], [-122.35716, 37.89727], [-122.35749, 37.89766], [-122.35772, 37.89812], [-122.35737, 37.89887], [-122.3572, 37.89912], [-122.3574, 37.8997], [-122.3576, 37.90062], [-122.35781, 37.9007], [-122.35803, 37.90099]]]} Restricted Access 2 25299 Brooks Island Regional Preserve 31525 2032 East Bay Regional Park District 89 Special District 4 Recreation/Parks District 4 http://www.ebparks.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Contra Costa 12 85.832 Brooks Island RPr 0 Local Conservation Area 4 2

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