units_with_maps

Table actions

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

7 rows where AGNCY_NAME = 214 and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 7 ✖

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
572 572 571 {"type": "Polygon", "coordinates": [[[-117.04862, 34.87735], [-117.04763, 34.87734], [-117.04762, 34.87653], [-117.04861, 34.87654], [-117.04862, 34.87735]]]} Open Access 1 1897 Barstow Heights Park 15837 1021 Barstow, City of 214 City 2 City Agency 2 http://www.barstowca.org/visitors/parks City 2 1021 Barstow, City of 210 City 2 City Agency 2   San Bernardino 22 2.022 Barstow Heights Park 0 Local Park 2 4
1446 1446 1445 {"type": "Polygon", "coordinates": [[[-117.05516, 34.87007], [-117.05417, 34.87006], [-117.05417, 34.86933], [-117.05516, 34.86935], [-117.05516, 34.87007]]]} Open Access 1 12546 Panamint Park 23386 1021 Barstow, City of 214 City 2 City Agency 2 http://www.barstowca.org/visitors/parks City 2 1021 Barstow, City of 210 City 2 City Agency 2   San Bernardino 22 1.805 Panamint Park 0 Local Park 2 4
6491 6491 6490 {"type": "Polygon", "coordinates": [[[-117.10551, 34.88149], [-117.10465, 34.88176], [-117.10406, 34.88048], [-117.10492, 34.88021], [-117.10551, 34.88149]]]} Open Access 1 2408 Jasper Park 20368 1021 Barstow, City of 214 City 2 City Agency 2 http://www.barstowca.org/visitors/parks City 2 1021 Barstow, City of 210 City 2 City Agency 2   San Bernardino 22 3.17 Jasper Park 0 Local Park 2 4
6603 6603 6602 {"type": "Polygon", "coordinates": [[[-117.01468, 34.89471], [-117.01472, 34.89472], [-117.01473, 34.89475], [-117.01474, 34.8965], [-117.01472, 34.89653], [-117.01469, 34.89654], [-117.01452, 34.8965], [-117.01439, 34.8964], [-117.01339, 34.89515], [-117.01341, 34.89511], [-117.01356, 34.89503], [-117.0138, 34.89493], [-117.01448, 34.89474], [-117.01468, 34.89471]]]} Open Access 1 4142 Lillian Park 21236 1021 Barstow, City of 214 City 2 City Agency 2 http://www.barstowca.org/visitors/parks City 2 1021 Barstow, City of 210 City 2 City Agency 2   San Bernardino 22 3.665 Lillian Park 0 Local Park 2 4
6622 6622 6621 {"type": "Polygon", "coordinates": [[[-117.00204, 34.87659], [-117.002, 34.8781], [-117.00178, 34.8781], [-117.00177, 34.87846], [-117.0008, 34.87847], [-117.00088, 34.87656], [-117.00204, 34.87659]]]} Open Access 1 4309 Donald A. Stringham Park 18210 1021 Barstow, City of 214 City 2 City Agency 2 http://www.barstowca.org/visitors/parks City 2 1021 Barstow, City of 210 City 2 City Agency 2   San Bernardino 22 5.378 Donald A. Stringham Park 0 Local Park 2 4
8889 8889 8888 {"type": "Polygon", "coordinates": [[[-117.00039, 34.89899], [-116.99965, 34.89924], [-116.99954, 34.89924], [-116.99949, 34.89926], [-116.99946, 34.8993], [-116.99897, 34.89947], [-116.99893, 34.89906], [-116.99887, 34.8987], [-116.99877, 34.89835], [-116.99865, 34.898], [-116.99845, 34.89757], [-116.99821, 34.89716], [-116.99793, 34.89677], [-116.99757, 34.89637], [-116.99757, 34.89607], [-116.99925, 34.8955], [-117.00009, 34.89717], [-116.99957, 34.89736], [-117.0001, 34.8984], [-117.00008, 34.89849], [-117.00009, 34.89854], [-117.00012, 34.89858], [-117.00021, 34.89863], [-117.00039, 34.89899]]]} Open Access 1 14535 Sturnacle Park 25939 1021 Barstow, City of 214 City 2 City Agency 2 http://www.barstowca.org/visitors/parks City 2 1021 Barstow, City of 210 City 2 City Agency 2   San Bernardino 22 13.792 Sturnacle Park 0 Local Park 2 4
9150 9150 9149 {"type": "Polygon", "coordinates": [[[-117.02434, 34.90186], [-117.02434, 34.90224], [-117.0241, 34.90224], [-117.02368, 34.90208], [-117.02368, 34.90186], [-117.02434, 34.90186]]]} Open Access 1 15196 Waterman Park 27304 1021 Barstow, City of 214 City 2 City Agency 2 http://www.barstowca.org/visitors/parks City 2 1021 Barstow, City of 210 City 2 City Agency 2   San Bernardino 22 0.557 Waterman 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]);