units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 3, DES_TP = 3 and MNG_AGENCY = 87

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_TYP, AGNCY_WEB, YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • East Bay Regional Park District · 4 ✖

DES_TP 1

  • Local Recreation Area · 4 ✖

ACCESS_TYP 1

  • No Public Access · 4 ✖
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
12726 12726 12725 {"type": "MultiPolygon", "coordinates": [[[[-121.93312, 37.96917], [-121.93309, 37.9762], [-121.92397, 37.97636], [-121.92389, 37.98339], [-121.91481, 37.9835], [-121.91485, 37.97467], [-121.91541, 37.97455], [-121.91619, 37.97432], [-121.91638, 37.97432], [-121.91684, 37.97403], [-121.917, 37.97372], [-121.91739, 37.97344], [-121.91795, 37.97331], [-121.91823, 37.97315], [-121.91876, 37.97249], [-121.91908, 37.97226], [-121.91945, 37.97219], [-121.91991, 37.97201], [-121.92004, 37.97193], [-121.92076, 37.97121], [-121.92124, 37.97103], [-121.92209, 37.97065], [-121.92264, 37.97037], [-121.92271, 37.9702], [-121.9229, 37.97006], [-121.92356, 37.96996], [-121.92384, 37.9698], [-121.9245, 37.96925], [-121.93312, 37.96917]]], [[[-121.92264, 37.96928], [-121.922, 37.96996], [-121.92175, 37.97005], [-121.92152, 37.97027], [-121.92122, 37.97042], [-121.9205, 37.9709], [-121.91988, 37.97127], [-121.91761, 37.97247], [-121.91709, 37.97284], [-121.91631, 37.97367], [-121.91588, 37.97391], [-121.91493, 37.9742], [-121.91489, 37.96938], [-121.92264, 37.96928]]]]} No Public Access 3 29753 CNWS to Black Diamond 17451 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 449.119 CNWS to Black Diamond 0 Local Recreation Area 3 4
13126 13126 13125 {"type": "Polygon", "coordinates": [[[-121.97561, 37.57073], [-121.97355, 37.57142], [-121.97349, 37.57127], [-121.97245, 37.57159], [-121.97094, 37.57232], [-121.97064, 37.57203], [-121.97072, 37.57045], [-121.97094, 37.5703], [-121.97132, 37.57017], [-121.97167, 37.57028], [-121.97219, 37.57057], [-121.97251, 37.57061], [-121.97248, 37.57023], [-121.97265, 37.56971], [-121.97407, 37.56935], [-121.97486, 37.57004], [-121.97518, 37.57025], [-121.97535, 37.57038], [-121.97561, 37.57073]]]} No Public Access 3 46965 Quarry Lakes Regional Recreation Area 30596 2000 Alameda County Flood Control and Water Conservation District 771 Special District 4 Flood District 8 http://acfloodcontrol.org/ Special District 4 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Alameda 17 17.733 Quarry Lakes Reg. Rec. Area 2001 Local Recreation Area 3 4
16665 16665 16664 {"type": "Polygon", "coordinates": [[[-122.0161, 37.83947], [-122.01592, 37.83969], [-122.01594, 37.83971], [-122.01576, 37.83994], [-122.01475, 37.84015], [-122.01362, 37.84097], [-122.01307, 37.84201], [-122.01332, 37.84594], [-122.01281, 37.84602], [-122.01282, 37.84625], [-122.01252, 37.84626], [-122.01243, 37.84633], [-122.01035, 37.84636], [-122.01015, 37.84633], [-122.01004, 37.84636], [-122.00938, 37.84638], [-122.00738, 37.8457], [-122.00703, 37.84551], [-122.00622, 37.84524], [-122.00475, 37.84479], [-122.00478, 37.84468], [-122.00627, 37.84515], [-122.00735, 37.84552], [-122.00735, 37.84562], [-122.00938, 37.8463], [-122.01245, 37.84625], [-122.0128, 37.84594], [-122.0125, 37.84132], [-122.01337, 37.83979], [-122.01386, 37.83993], [-122.01417, 37.83899], [-122.0151, 37.83896], [-122.01558, 37.83916], [-122.0161, 37.83947]]]} No Public Access 3 15340 Las Trampas/Diablo Regional Trail 21068 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 16.575 Las Trampas/Diablo Reg. Trail 0 Local Recreation Area 3 4
16860 16860 16859 {"type": "MultiPolygon", "coordinates": [[[[-121.60916, 37.93276], [-121.60904, 37.93276], [-121.60902, 37.93271], [-121.6081, 37.93272], [-121.60864, 37.93598], [-121.60795, 37.93658], [-121.60834, 37.93867], [-121.60825, 37.93905], [-121.59819, 37.93913], [-121.5981, 37.93466], [-121.59229, 37.93078], [-121.59228, 37.92974], [-121.60063, 37.92967], [-121.60064, 37.92938], [-121.60198, 37.92936], [-121.60206, 37.92927], [-121.60211, 37.91785], [-121.60386, 37.91775], [-121.60391, 37.91959], [-121.6042, 37.92372], [-121.60742, 37.92337], [-121.6077, 37.92498], [-121.60431, 37.92535], [-121.60458, 37.92936], [-121.60442, 37.92964], [-121.60866, 37.92961], [-121.60872, 37.92983], [-121.60916, 37.93276]]], [[[-121.6409, 37.95462], [-121.64089, 37.96179], [-121.63483, 37.96181], [-121.63484, 37.9688], [-121.63566, 37.96881], [-121.6353, 37.96884], [-121.62825, 37.96876], [-121.62721, 37.96876], [-121.62716, 37.9654], [-121.62013, 37.96544], [-121.61998, 37.95458], [-121.62267, 37.95456], [-121.64086, 37.95454], [-121.64086, 37.95461], [-121.6409, 37.95462]]], [[[-121.63638, 37.96886], [-121.63635, 37.97242], [-121.62718, 37.97244], [-121.62709, 37.96887], [-121.62825, 37.96887], [-121.6353, 37.96895], [-121.63638, 37.96886]]]]} No Public Access 3 46995 Delta Access Regional Recreation Area 30632 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 986.689 Delta Access Reg. Rec. Area 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]);