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 = "38.798" and MNG_AGENCY = 534

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Sacramento, 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
4392 4392 4391 {"type": "MultiPolygon", "coordinates": [[[[-121.51588, 38.56695], [-121.51435, 38.56594], [-121.51455, 38.5658], [-121.51503, 38.56533], [-121.51537, 38.56503], [-121.51582, 38.56503], [-121.51583, 38.5662], [-121.51588, 38.56695]]], [[[-121.51794, 38.56829], [-121.51699, 38.56765], [-121.51651, 38.5675], [-121.51619, 38.56742], [-121.51621, 38.56716], [-121.51618, 38.56511], [-121.51592, 38.56277], [-121.51554, 38.5607], [-121.51522, 38.55979], [-121.51491, 38.55912], [-121.51467, 38.55864], [-121.51519, 38.55875], [-121.51546, 38.55916], [-121.51619, 38.56], [-121.51629, 38.55994], [-121.51647, 38.56013], [-121.51638, 38.5602], [-121.51643, 38.56027], [-121.5162, 38.56042], [-121.51609, 38.56054], [-121.51603, 38.5607], [-121.51603, 38.56081], [-121.51621, 38.56234], [-121.51645, 38.56393], [-121.5165, 38.56397], [-121.51663, 38.56399], [-121.51791, 38.56394], [-121.51828, 38.56446], [-121.5183, 38.56454], [-121.51831, 38.56461], [-121.51828, 38.56467], [-121.51824, 38.56472], [-121.51817, 38.56476], [-121.51808, 38.56479], [-121.51685, 38.56488], [-121.5168, 38.5649], [-121.51674, 38.56496], [-121.51672, 38.56504], [-121.51674, 38.56679], [-121.51675, 38.56695], [-121.51677, 38.56699], [-121.51686, 38.56705], [-121.51693, 38.56706], [-121.51763, 38.56706], [-121.51771, 38.56706], [-121.51778, 38.56703], [-121.5179, 38.56693], [-121.51818, 38.56667], [-121.51867, 38.56613], [-121.51888, 38.56584], [-121.51902, 38.56554], [-121.51912, 38.56524], [-121.51913, 38.56493], [-121.51901, 38.5647], [-121.51807, 38.56339], [-121.51725, 38.56252], [-121.51711, 38.56231], [-121.51693, 38.56209], [-121.5169, 38.56184], [-121.51683, 38.5616], [-121.51663, 38.56107], [-121.51663, 38.56099], [-121.51668, 38.56093], [-121.51675, 38.56089], [-121.51687, 38.56086], [-121.51699, 38.56087], [-121.51949, 38.56358], [-121.51994, 38.5645], [-121.51993, 38.56539], [-121.51961, 38.56621], [-121.51895, 38.56737], [-121.51794, 38.56829]]], [[[-121.51582, 38.56364], [-121.51581, 38.56475], [-121.51529, 38.5648], [-121.51511, 38.56439], [-121.51532, 38.56424], [-121.51546, 38.56409], [-121.51557, 38.56392], [-121.51566, 38.56365], [-121.51582, 38.56364]]]]} Open Access 1 Fredrick Miller Park   19081 1287 Sacramento, City of 534 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 38.798 Fredrick Miller Park  

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