units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, AGNCY_LEV = 2 and MNG_AGENCY = 376

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Fremont, City of · 1 ✖

DES_TP 1

ACCESS_TYP 1

  • No Public Access · 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
16235 16235 16234 {"type": "Polygon", "coordinates": [[[-121.90527, 37.49358], [-121.9052, 37.49364], [-121.90471, 37.49366], [-121.90456, 37.49364], [-121.90442, 37.49372], [-121.90408, 37.49378], [-121.90368, 37.49411], [-121.90363, 37.49437], [-121.90355, 37.49439], [-121.90348, 37.49455], [-121.90325, 37.49465], [-121.90315, 37.49491], [-121.90248, 37.49516], [-121.9024, 37.49534], [-121.90229, 37.49542], [-121.90177, 37.49562], [-121.90156, 37.49585], [-121.90097, 37.49594], [-121.90084, 37.49614], [-121.90056, 37.49617], [-121.89998, 37.49613], [-121.8998, 37.49602], [-121.89974, 37.49574], [-121.89986, 37.4957], [-121.89973, 37.49537], [-121.89955, 37.49532], [-121.89943, 37.49536], [-121.89882, 37.49529], [-121.89845, 37.49496], [-121.89838, 37.49473], [-121.89801, 37.49457], [-121.89793, 37.49432], [-121.8977, 37.49424], [-121.89727, 37.49438], [-121.89699, 37.49434], [-121.89673, 37.49487], [-121.89596, 37.49633], [-121.89529, 37.49776], [-121.89423, 37.49959], [-121.87661, 37.50034], [-121.87655, 37.50024], [-121.87577, 37.49798], [-121.87328, 37.49109], [-121.8745, 37.48905], [-121.87416, 37.48824], [-121.88426, 37.48716], [-121.88426, 37.48713], [-121.88511, 37.48551], [-121.88591, 37.48351], [-121.88572, 37.48314], [-121.88587, 37.48215], [-121.88616, 37.48178], [-121.88617, 37.48153], [-121.88602, 37.48132], [-121.88578, 37.48131], [-121.88506, 37.48093], [-121.88517, 37.48071], [-121.88332, 37.47962], [-121.88417, 37.47872], [-121.88427, 37.47857], [-121.88435, 37.4784], [-121.88432, 37.4782], [-121.89052, 37.47614], [-121.89123, 37.47752], [-121.88921, 37.47817], [-121.88976, 37.47925], [-121.89093, 37.47887], [-121.89129, 37.4789], [-121.8913, 37.48002], [-121.89194, 37.47978], [-121.89223, 37.47964], [-121.89264, 37.47948], [-121.89322, 37.47935], [-121.89409, 37.4794], [-121.89446, 37.47931], [-121.89499, 37.47944], [-121.89526, 37.47959], [-121.89528, 37.48093], [-121.89506, 37.48116], [-121.89528, 37.48185], [-121.89638, 37.48301], [-121.89647, 37.48309], [-121.89662, 37.48318], [-121.89683, 37.48327], [-121.89701, 37.48331], [-121.89717, 37.48333], [-121.89718, 37.48355], [-121.89721, 37.48373], [-121.89729, 37.48393], [-121.89741, 37.48415], [-121.89758, 37.48434], [-121.89775, 37.48449], [-121.89793, 37.48461], [-121.89818, 37.48474], [-121.89803, 37.4849], [-121.89793, 37.48504], [-121.89786, 37.48522], [-121.89782, 37.4854], [-121.89782, 37.48558], [-121.89785, 37.48576], [-121.89791, 37.48594], [-121.898, 37.48609], [-121.89811, 37.48622], [-121.89824, 37.48633], [-121.89841, 37.48643], [-121.89859, 37.48651], [-121.8988, 37.48657], [-121.899, 37.48661], [-121.89922, 37.48663], [-121.89944, 37.48662], [-121.89949, 37.48682], [-121.8996, 37.48709], [-121.89974, 37.48732], [-121.89991, 37.48754], [-121.90012, 37.48773], [-121.90031, 37.48789], [-121.90053, 37.48802], [-121.9008, 37.48815], [-121.90118, 37.48828], [-121.90167, 37.48838], [-121.90203, 37.4884], [-121.90318, 37.48839], [-121.90331, 37.48903], [-121.90383, 37.4901], [-121.90369, 37.49084], [-121.90527, 37.49358]]]} No Public Access 3 45940 Hill Face Open Space City of Fremont 29020 1113 Fremont, City of 381 City 2 City Agency 2 http://www.fremont.gov/316/Parks City 2 1113 Fremont, City of 376 City 2 City Agency 2   Alameda 17 1038.333 Hill Face OS City of Fremont 1976 None 1395  

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