units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, MNG_AGENCY = 87 and UNIT_NAME = "Quarry Lakes Regional Recreation Area"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • East Bay Regional Park District · 3 ✖

ACCESS_TYP 1

  • Open 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
218 218 217 {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} Open Access 1 586 Quarry Lakes Regional Recreation Area 30594 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   Alameda 17 254.616 Quarry Lakes Reg. Rec. Area 2001 Local Recreation Area 3 4
11508 11508 11507 {"type": "Polygon", "coordinates": [[[-122.00857, 37.57719], [-122.00838, 37.57734], [-122.00814, 37.57765], [-122.00798, 37.57795], [-122.00791, 37.57818], [-122.00786, 37.57854], [-122.00788, 37.57885], [-122.00793, 37.5791], [-122.0079, 37.57918], [-122.00795, 37.57921], [-122.00802, 37.57938], [-122.00812, 37.57947], [-122.00685, 37.57917], [-122.00706, 37.57859], [-122.00718, 37.57861], [-122.00735, 37.57827], [-122.0076, 37.57793], [-122.00781, 37.57772], [-122.008, 37.57756], [-122.00857, 37.57719]]]} Open Access 1 29555 Quarry Lakes Regional Recreation Area 30594 1113 Fremont, City of 381 City 2 City Agency 2 http://www.fremont.gov/316/Parks City 2 2032 East Bay Regional Park District 87 Special District 4 Recreation/Parks District 4   Alameda 17 2.872 Quarry Lakes Reg. Rec. Area 2001 Local Recreation Area 3 4
16858 16858 16857 {"type": "MultiPolygon", "coordinates": [[[[-121.98493, 37.5708], [-121.98481, 37.57087], [-121.98262, 37.57146], [-121.98203, 37.57131], [-121.98023, 37.57119], [-121.97789, 37.57078], [-121.9779, 37.5707], [-121.97775, 37.57068], [-121.97773, 37.57078], [-121.977, 37.57083], [-121.97696, 37.57073], [-121.98405, 37.56827], [-121.98493, 37.5708]]], [[[-121.99743, 37.56696], [-121.99723, 37.57285], [-121.99477, 37.57234], [-121.99378, 37.57157], [-121.99365, 37.57126], [-121.99304, 37.57095], [-121.99247, 37.57058], [-121.99015, 37.56877], [-121.99037, 37.56856], [-121.99004, 37.56832], [-121.99026, 37.56812], [-121.99056, 37.56788], [-121.99081, 37.56771], [-121.99114, 37.56752], [-121.9911, 37.56747], [-121.99154, 37.56722], [-121.99207, 37.56699], [-121.99205, 37.56693], [-121.99208, 37.56692], [-121.99227, 37.56709], [-121.99486, 37.56652], [-121.99505, 37.56755], [-121.99743, 37.56696]]], [[[-121.99115, 37.57124], [-121.991, 37.57166], [-121.99084, 37.57163], [-121.99073, 37.57183], [-121.99048, 37.5721], [-121.99009, 37.57282], [-121.98985, 37.57304], [-121.98934, 37.57292], [-121.98923, 37.57292], [-121.98838, 37.57274], [-121.98724, 37.5731], [-121.98639, 37.57303], [-121.98538, 37.57299], [-121.9853, 37.57301], [-121.98483, 37.5721], [-121.98514, 37.57196], [-121.98552, 37.57177], [-121.98587, 37.57157], [-121.98621, 37.57134], [-121.98653, 37.5711], [-121.98856, 37.56942], [-121.99115, 37.57124]]], [[[-122.01114, 37.57138], [-122.00593, 37.5763], [-122.00588, 37.57674], [-122.00424, 37.57807], [-122.003, 37.57733], [-122.00399, 37.57753], [-122.00402, 37.57742], [-122.00241, 37.57709], [-122.00243, 37.57698], [-122.00088, 37.57663], [-122.00167, 37.57417], [-122.00486, 37.57485], [-122.00562, 37.57243], [-122.00581, 37.57271], [-122.00605, 37.57247], [-122.00876, 37.57006], [-122.01114, 37.57138]]]]} Open Access 1 46968 Quarry Lakes Regional Recreation Area 30594 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 204.467 Quarry Lakes Reg. Rec. Area 2001 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]);