units_with_maps

Table actions

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

6 rows where ACCESS_TYP = 3, COUNTY = 35 and DES_TP = 14

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Other or Unknown · 6 ✖

ACCESS_TYP 1

  • No Public Access · 6 ✖
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
13854 13854 13853 {"type": "Polygon", "coordinates": [[[-121.26424, 38.82108], [-121.26403, 38.82133], [-121.26303, 38.82156], [-121.26234, 38.82151], [-121.26169, 38.82177], [-121.26083, 38.82268], [-121.26025, 38.82268], [-121.25958, 38.8232], [-121.25959, 38.82321], [-121.26023, 38.82329], [-121.26016, 38.8237], [-121.25865, 38.82437], [-121.25774, 38.82444], [-121.25753, 38.82471], [-121.25701, 38.82425], [-121.25747, 38.82401], [-121.25869, 38.82323], [-121.26023, 38.82202], [-121.26138, 38.82135], [-121.26194, 38.82112], [-121.26234, 38.82107], [-121.26424, 38.82108]]]} No Public Access 3 36443 Rocklin holding 3 24526 1280 Rocklin, City of 577 City 2 City Agency 2 http://www.rocklin.ca.us/depts/parksnrec/default.asp City 2 1280 Rocklin, City of 569 City 2 City Agency 2   Placer 35 12.656 Rocklin holding 3 0 Local Other or Unknown 14 4
13877 13877 13876 {"type": "Polygon", "coordinates": [[[-121.26559, 38.82111], [-121.26234, 38.82106], [-121.26396, 38.81851], [-121.26338, 38.81563], [-121.26341, 38.81439], [-121.26407, 38.81448], [-121.26519, 38.8147], [-121.26558, 38.81763], [-121.26582, 38.81916], [-121.26559, 38.82111]]]} No Public Access 3 36468 Rocklin holding 17 24524 1280 Rocklin, City of 577 City 2 City Agency 2 http://www.rocklin.ca.us/depts/parksnrec/default.asp City 2 1280 Rocklin, City of 569 City 2 City Agency 2   Placer 35 33.242 Rocklin holding 17 0 Local Other or Unknown 14 4
13880 13880 13879 {"type": "Polygon", "coordinates": [[[-121.25747, 38.82554], [-121.25724, 38.82581], [-121.25685, 38.82593], [-121.25694, 38.82622], [-121.25666, 38.82626], [-121.25656, 38.82592], [-121.25645, 38.82581], [-121.25608, 38.82602], [-121.25539, 38.82611], [-121.25449, 38.82674], [-121.25371, 38.82681], [-121.25267, 38.82716], [-121.25254, 38.82656], [-121.25284, 38.82645], [-121.25367, 38.82638], [-121.25449, 38.82624], [-121.25513, 38.82583], [-121.25571, 38.82557], [-121.25628, 38.82504], [-121.25671, 38.82444], [-121.25736, 38.82486], [-121.25717, 38.82502], [-121.25743, 38.82524], [-121.25747, 38.82554]]]} No Public Access 3 36470 Rocklin holding 7 24530 1280 Rocklin, City of 577 City 2 City Agency 2 http://www.rocklin.ca.us/depts/parksnrec/default.asp City 2 1280 Rocklin, City of 569 City 2 City Agency 2   Placer 35 7.963 Rocklin holding 7 0 Local Other or Unknown 14 4
13881 13881 13880 {"type": "Polygon", "coordinates": [[[-121.25251, 38.82722], [-121.25091, 38.82731], [-121.25113, 38.82719], [-121.25077, 38.82655], [-121.25226, 38.82667], [-121.25237, 38.82663], [-121.25251, 38.82722]]]} No Public Access 3 36471 Rocklin holding 6 24529 1280 Rocklin, City of 577 City 2 City Agency 2 http://www.rocklin.ca.us/depts/parksnrec/default.asp City 2 1280 Rocklin, City of 569 City 2 City Agency 2   Placer 35 2.285 Rocklin holding 6 0 Local Other or Unknown 14 4
13882 13882 13881 {"type": "Polygon", "coordinates": [[[-121.25806, 38.82755], [-121.25787, 38.82775], [-121.25752, 38.82708], [-121.25728, 38.82686], [-121.25697, 38.82662], [-121.25692, 38.82637], [-121.25716, 38.82632], [-121.25735, 38.82645], [-121.25806, 38.82755]]]} No Public Access 3 36472 Rocklin holding 8 24531 1280 Rocklin, City of 577 City 2 City Agency 2 http://www.rocklin.ca.us/depts/parksnrec/default.asp City 2 1280 Rocklin, City of 569 City 2 City Agency 2   Placer 35 1.03 Rocklin holding 8 0 Local Other or Unknown 14 4
13883 13883 13882 {"type": "Polygon", "coordinates": [[[-121.25613, 38.82953], [-121.25455, 38.83106], [-121.25434, 38.83148], [-121.25459, 38.83065], [-121.25495, 38.83003], [-121.25525, 38.82964], [-121.25526, 38.82948], [-121.25506, 38.82931], [-121.25526, 38.82919], [-121.25549, 38.82909], [-121.25567, 38.82935], [-121.25594, 38.82924], [-121.25613, 38.82953]]]} No Public Access 3 36473 Rocklin holding 9 24532 1280 Rocklin, City of 577 City 2 City Agency 2 http://www.rocklin.ca.us/depts/parksnrec/default.asp City 2 1280 Rocklin, City of 569 City 2 City Agency 2   Placer 35 2.565 Rocklin holding 9 0 Local Other or Unknown 14 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]);