superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, ACRES = "24.724" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 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
5434 5434 5433 {"type": "Polygon", "coordinates": [[[-121.42447, 38.441], [-121.42427, 38.44108], [-121.4241, 38.44111], [-121.42304, 38.44103], [-121.42281, 38.44122], [-121.4226, 38.44135], [-121.42233, 38.44147], [-121.4221, 38.44152], [-121.42195, 38.44149], [-121.42175, 38.44139], [-121.42124, 38.44106], [-121.42109, 38.44103], [-121.42096, 38.44104], [-121.42084, 38.44107], [-121.42063, 38.44118], [-121.4202, 38.44142], [-121.41979, 38.44174], [-121.41976, 38.44175], [-121.41971, 38.44174], [-121.41912, 38.44137], [-121.41894, 38.44131], [-121.41871, 38.44158], [-121.41854, 38.44171], [-121.41828, 38.44184], [-121.418, 38.44191], [-121.41759, 38.44266], [-121.41759, 38.4429], [-121.41749, 38.4429], [-121.41748, 38.44285], [-121.41745, 38.44282], [-121.41736, 38.44279], [-121.41729, 38.4428], [-121.4172, 38.44286], [-121.41714, 38.44288], [-121.4153, 38.44286], [-121.41524, 38.44283], [-121.41522, 38.44275], [-121.41508, 38.44292], [-121.41501, 38.44293], [-121.41501, 38.44335], [-121.41399, 38.44336], [-121.41327, 38.44342], [-121.41121, 38.44344], [-121.41093, 38.44348], [-121.40932, 38.44348], [-121.40906, 38.44363], [-121.40901, 38.44362], [-121.40897, 38.44363], [-121.40879, 38.44356], [-121.40872, 38.44357], [-121.40872, 38.44297], [-121.40873, 38.44301], [-121.40877, 38.44305], [-121.40886, 38.44307], [-121.40893, 38.44306], [-121.40897, 38.44303], [-121.40935, 38.44293], [-121.40975, 38.4429], [-121.40985, 38.44293], [-121.40999, 38.44289], [-121.41014, 38.44289], [-121.41037, 38.44292], [-121.41066, 38.44301], [-121.41094, 38.44307], [-121.41115, 38.44307], [-121.4112, 38.44306], [-121.41215, 38.44305], [-121.41245, 38.44302], [-121.41295, 38.44286], [-121.41322, 38.44281], [-121.41411, 38.4428], [-121.41423, 38.44282], [-121.41431, 38.44281], [-121.4144, 38.44276], [-121.41442, 38.44269], [-121.4146, 38.44268], [-121.41475, 38.44257], [-121.41509, 38.44241], [-121.4153, 38.44244], [-121.41585, 38.44235], [-121.41592, 38.44219], [-121.41597, 38.44212], [-121.41604, 38.44207], [-121.41615, 38.44203], [-121.41615, 38.44165], [-121.41758, 38.44164], [-121.418, 38.44119], [-121.41806, 38.44117], [-121.41811, 38.44113], [-121.4182, 38.44078], [-121.41824, 38.44073], [-121.4183, 38.44071], [-121.41856, 38.4407], [-121.41878, 38.44086], [-121.41922, 38.44072], [-121.41963, 38.44066], [-121.41979, 38.4404], [-121.41997, 38.44031], [-121.42003, 38.44031], [-121.42009, 38.44033], [-121.42035, 38.44052], [-121.42045, 38.44065], [-121.42109, 38.44061], [-121.42135, 38.44062], [-121.42256, 38.44068], [-121.42405, 38.4408], [-121.42411, 38.44079], [-121.42427, 38.44072], [-121.42447, 38.441]]]} Open Access 1 Jacinto Creek Parkway   20299 1287 Sacramento, City of 534 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 24.724 Jacinto Creek Parkway  

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