superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 376 and YR_EST = 1960

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Fremont, City of · 1 ✖

ACCESS_TYP 1

  • Open Access · 1 ✖
Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
552 552 551 {"type": "Polygon", "coordinates": [[[-121.972, 37.54942], [-121.97136, 37.54931], [-121.97107, 37.54946], [-121.971, 37.54955], [-121.97097, 37.54961], [-121.97093, 37.54977], [-121.97094, 37.54984], [-121.97093, 37.5499], [-121.97077, 37.55006], [-121.97076, 37.55014], [-121.97083, 37.55028], [-121.97082, 37.55037], [-121.97077, 37.5504], [-121.97068, 37.55044], [-121.97046, 37.55049], [-121.9703, 37.55049], [-121.97024, 37.55042], [-121.97009, 37.55037], [-121.96983, 37.55023], [-121.96929, 37.54991], [-121.96868, 37.55068], [-121.96839, 37.55056], [-121.96807, 37.55094], [-121.96809, 37.55099], [-121.96832, 37.55113], [-121.96849, 37.55131], [-121.9683, 37.55133], [-121.96813, 37.5514], [-121.96804, 37.55148], [-121.96782, 37.5517], [-121.96766, 37.55183], [-121.96768, 37.55131], [-121.96766, 37.55126], [-121.9675, 37.55123], [-121.9666, 37.55125], [-121.96657, 37.55185], [-121.96719, 37.55215], [-121.96743, 37.55221], [-121.96833, 37.55299], [-121.96844, 37.55312], [-121.96875, 37.55359], [-121.96409, 37.55553], [-121.96375, 37.5557], [-121.96344, 37.55591], [-121.9589, 37.5593], [-121.95693, 37.54698], [-121.95619, 37.54193], [-121.9561, 37.54143], [-121.95718, 37.54123], [-121.95785, 37.54113], [-121.95832, 37.54112], [-121.9586, 37.54114], [-121.95943, 37.54126], [-121.95985, 37.54138], [-121.96025, 37.54155], [-121.9605, 37.54169], [-121.96079, 37.54191], [-121.96263, 37.54352], [-121.9631, 37.54383], [-121.96535, 37.54521], [-121.96653, 37.54597], [-121.96692, 37.54625], [-121.96715, 37.54644], [-121.96795, 37.54695], [-121.96898, 37.54754], [-121.96899, 37.54758], [-121.97169, 37.54896], [-121.9718, 37.54905], [-121.9719, 37.54917], [-121.97196, 37.54927], [-121.972, 37.54942]]]} Open Access 1 Fremont Central Park https://www.fremont.gov/317/Central-Park 3837 1113 Fremont, City of 376 City 2 City Agency 2 http://www.fremont.gov/316/Parks City 2 352.06 Fremont Central Park 1960

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);