units_with_maps

Table actions

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

4 rows where COUNTY = 54, MNG_AGENCY = 975 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 4 ✖

MNG_AGENCY 1

  • Susanville, City of · 4 ✖

DES_TP 1

ACCESS_TYP 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
12222 12222 12221 {"type": "Polygon", "coordinates": [[[-120.65746, 40.41862], [-120.65737, 40.41884], [-120.65689, 40.41872], [-120.65681, 40.41889], [-120.65676, 40.41889], [-120.65671, 40.41903], [-120.65723, 40.41917], [-120.65707, 40.41957], [-120.65304, 40.41858], [-120.65356, 40.4172], [-120.65359, 40.41718], [-120.65691, 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.65487, 40.41798], [-120.65746, 40.41862]]]} Open Access 1 25416 Memorial Park 22140 1437 Susanville, City of 1013 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 1437 Susanville, City of 975 City 2 City Agency 2   Lassen 54 11.523 Memorial Park 0 Local Park 2 4
12223 12223 12222 {"type": "Polygon", "coordinates": [[[-120.65267, 40.41073], [-120.6516, 40.41196], [-120.65146, 40.4118], [-120.65132, 40.41167], [-120.65058, 40.41121], [-120.65046, 40.41058], [-120.65049, 40.41027], [-120.65078, 40.40988], [-120.65179, 40.41035], [-120.65181, 40.41033], [-120.65267, 40.41073]]]} Open Access 1 25417 Riverside Park 24458 1437 Susanville, City of 1013 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 1437 Susanville, City of 975 City 2 City Agency 2   Lassen 54 5.83 Riverside Park 0 Local Park 2 4
12224 12224 12223 {"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.65461, 40.41429], [-120.65474, 40.41429], [-120.65475, 40.41419], [-120.65542, 40.41425], [-120.65545, 40.41398], [-120.65556, 40.41398], [-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 25418 Susan River Park 26079 1437 Susanville, City of 1013 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 1437 Susanville, City of 975 City 2 City Agency 2   Lassen 54 5.128 Susan River Park 0 Local Park 2 4
13043 13043 13042 {"type": "Polygon", "coordinates": [[[-120.64976, 40.41359], [-120.64933, 40.41358], [-120.64902, 40.41334], [-120.64894, 40.41443], [-120.64785, 40.41413], [-120.64787, 40.41406], [-120.64746, 40.41393], [-120.64746, 40.41391], [-120.64718, 40.41378], [-120.6472, 40.41372], [-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 34885 Little Leage Park 21342 1437 Susanville, City of 1013 City 2 City Agency 2 http://www.cityofsusanville.org/ City 2 1437 Susanville, City of 975 City 2 City Agency 2   Lassen 54 8.66 Little Leage Park 0 Local Park 2 4

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