superunits_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1, MNG_AGENCY = 975 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

  • City Agency · 4 ✖

ACCESS_TYP 1

  • Open Access · 4 ✖
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
6271 6271 6270 {"type": "Polygon", "coordinates": [[[-120.64976, 40.41359], [-120.64933, 40.41358], [-120.64903, 40.41335], [-120.64894, 40.41443], [-120.64785, 40.41413], [-120.64787, 40.41406], [-120.64746, 40.41393], [-120.64745, 40.41391], [-120.64718, 40.41378], [-120.64719, 40.41371], [-120.64686, 40.41359], [-120.64682, 40.41365], [-120.64671, 40.41361], [-120.64675, 40.41353], [-120.64674, 40.4135], [-120.6464, 40.41308], [-120.64605, 40.41271], [-120.64614, 40.41239], [-120.64652, 40.41262], [-120.64737, 40.41246], [-120.64744, 40.41243], [-120.64902, 40.41302], [-120.64976, 40.41356], [-120.64976, 40.41359]]]} Open Access 1 Little Leage Park   21342 1437 Susanville, City of 975 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 8.67 Little Leage Park  
6929 6929 6928 {"type": "Polygon", "coordinates": [[[-120.65746, 40.41862], [-120.65737, 40.41884], [-120.65689, 40.41872], [-120.65681, 40.41889], [-120.65676, 40.41889], [-120.65672, 40.41904], [-120.65723, 40.41917], [-120.65707, 40.41957], [-120.65304, 40.41858], [-120.65356, 40.4172], [-120.65359, 40.41718], [-120.6569, 40.41799], [-120.65709, 40.41757], [-120.65715, 40.41759], [-120.65699, 40.418], [-120.65714, 40.41805], [-120.65712, 40.41811], [-120.65504, 40.41759], [-120.65488, 40.41797], [-120.65746, 40.41862]]]} Open Access 1 Memorial Park   22140 1437 Susanville, City of 975 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 11.554 Memorial Park  
8791 8791 8790 {"type": "Polygon", "coordinates": [[[-120.65267, 40.41073], [-120.6516, 40.41196], [-120.65147, 40.4118], [-120.65132, 40.41167], [-120.65058, 40.41121], [-120.65046, 40.41058], [-120.65049, 40.41027], [-120.65078, 40.40988], [-120.65178, 40.41035], [-120.65181, 40.41033], [-120.65267, 40.41073]]]} Open Access 1 Riverside Park   24458 1437 Susanville, City of 975 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 5.83 Riverside Park  
10145 10145 10144 {"type": "Polygon", "coordinates": [[[-120.65866, 40.41492], [-120.65846, 40.41525], [-120.65785, 40.41487], [-120.65713, 40.4142], [-120.65694, 40.41415], [-120.65669, 40.41415], [-120.65642, 40.41419], [-120.65538, 40.41461], [-120.65454, 40.41459], [-120.65442, 40.4145], [-120.65445, 40.41416], [-120.6546, 40.41418], [-120.65462, 40.41429], [-120.65474, 40.41428], [-120.65475, 40.41419], [-120.65541, 40.41425], [-120.65545, 40.41398], [-120.65556, 40.41397], [-120.65559, 40.41368], [-120.65758, 40.41388], [-120.65784, 40.41394], [-120.65802, 40.41405], [-120.65815, 40.41423], [-120.6582, 40.41433], [-120.65828, 40.41468], [-120.65831, 40.41475], [-120.65839, 40.4148], [-120.65866, 40.41492]]]} Open Access 1 Susan River Park   26079 1437 Susanville, City of 975 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 5.133 Susan River 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]);