units_with_maps

Table actions

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

5 rows where COUNTY = 30, DES_TP = 2 and MNG_AGENCY = 712

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Grass Valley, City of · 5 ✖

DES_TP 1

  • Local Park · 5 ✖

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
13089 13089 13088 {"type": "Polygon", "coordinates": [[[-121.05633, 39.21384], [-121.05624, 39.2148], [-121.05553, 39.21478], [-121.05558, 39.21505], [-121.05434, 39.21508], [-121.05425, 39.21443], [-121.0543, 39.21412], [-121.05428, 39.21375], [-121.05416, 39.21327], [-121.05422, 39.21324], [-121.05475, 39.21318], [-121.055, 39.21318], [-121.05574, 39.21354], [-121.05609, 39.21357], [-121.05608, 39.21382], [-121.05633, 39.21384]]]} Open Access 1 35006 Memorial Park 22141 1673 Grass Valley, City of 1042 City 2 City Agency 2 http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks City 2 1673 Grass Valley, City of 712 City 2 City Agency 2   Nevada 30 7.576 Memorial Park 0 Local Park 2 4
13107 13107 13106 {"type": "Polygon", "coordinates": [[[-121.08051, 39.21484], [-121.07948, 39.21911], [-121.079, 39.21958], [-121.07426, 39.21962], [-121.07422, 39.21856], [-121.07364, 39.2184], [-121.07337, 39.21828], [-121.07315, 39.21815], [-121.07263, 39.21792], [-121.07203, 39.21758], [-121.07158, 39.21846], [-121.07066, 39.21733], [-121.07041, 39.2173], [-121.0703, 39.21726], [-121.06975, 39.21716], [-121.06983, 39.21701], [-121.06969, 39.21698], [-121.06975, 39.21679], [-121.06907, 39.21666], [-121.06909, 39.21661], [-121.06981, 39.21672], [-121.06983, 39.21661], [-121.06921, 39.2165], [-121.06922, 39.2164], [-121.06988, 39.2165], [-121.06998, 39.21629], [-121.07018, 39.21633], [-121.07029, 39.21636], [-121.07032, 39.21621], [-121.07108, 39.2163], [-121.07093, 39.21613], [-121.07093, 39.21604], [-121.07087, 39.21589], [-121.07093, 39.21578], [-121.07093, 39.21568], [-121.07101, 39.21568], [-121.07102, 39.21567], [-121.07055, 39.21477], [-121.07074, 39.21497], [-121.07089, 39.21518], [-121.07154, 39.21486], [-121.07188, 39.21488], [-121.07218, 39.21487], [-121.07218, 39.21524], [-121.07229, 39.21523], [-121.07263, 39.21526], [-121.07305, 39.21534], [-121.073, 39.21539], [-121.07301, 39.21541], [-121.074, 39.21536], [-121.07443, 39.21526], [-121.07459, 39.21506], [-121.07525, 39.215], [-121.07581, 39.21497], [-121.07609, 39.21494], [-121.07654, 39.21495], [-121.0766, 39.21591], [-121.07869, 39.21589], [-121.07868, 39.21527], [-121.07931, 39.2153], [-121.0792, 39.21489], [-121.08051, 39.21484]]]} Open Access 1 35025 Condon Park 17580 1673 Grass Valley, City of 1042 City 2 City Agency 2 http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks City 2 1673 Grass Valley, City of 712 City 2 City Agency 2   Nevada 30 83.068 Condon Park 0 Local Park 2 4
13108 13108 13107 {"type": "Polygon", "coordinates": [[[-121.07218, 39.21473], [-121.07194, 39.21477], [-121.07179, 39.21476], [-121.07153, 39.2147], [-121.07127, 39.21456], [-121.07117, 39.21456], [-121.07145, 39.21433], [-121.07113, 39.21408], [-121.07115, 39.21401], [-121.07109, 39.21397], [-121.07094, 39.21396], [-121.07073, 39.21399], [-121.07056, 39.21411], [-121.07051, 39.21404], [-121.07053, 39.21399], [-121.07098, 39.21389], [-121.07206, 39.21396], [-121.07218, 39.21473]]]} Open Access 1 35026 Minnie Park 22268 1673 Grass Valley, City of 1042 City 2 City Agency 2 http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks City 2 1673 Grass Valley, City of 712 City 2 City Agency 2   Nevada 30 1.677 Minnie Park 0 Local Park 2 4
14281 14281 14280 {"type": "Polygon", "coordinates": [[[-121.07036, 39.22802], [-121.06963, 39.22835], [-121.07019, 39.22913], [-121.06979, 39.22933], [-121.07021, 39.22992], [-121.07021, 39.22996], [-121.0703, 39.22994], [-121.0702, 39.23017], [-121.07018, 39.23007], [-121.07008, 39.22999], [-121.06941, 39.23031], [-121.06873, 39.2306], [-121.06891, 39.23093], [-121.0685, 39.23105], [-121.06789, 39.23117], [-121.06728, 39.23008], [-121.0669, 39.22946], [-121.0669, 39.22935], [-121.0671, 39.22932], [-121.06727, 39.22922], [-121.06745, 39.22784], [-121.06751, 39.22721], [-121.06752, 39.22688], [-121.06839, 39.22691], [-121.0684, 39.22791], [-121.06981, 39.22726], [-121.07036, 39.22802]]]} Open Access 1 44208 DeVere Mautino Park 18126 1673 Grass Valley, City of 1042 City 2 City Agency 2 http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks City 2 1673 Grass Valley, City of 712 City 2 City Agency 2   Nevada 30 21.376 DeVere Mautino Park 0 Local Park 2 4
14854 14854 14853 {"type": "Polygon", "coordinates": [[[-121.05875, 39.21793], [-121.0585, 39.21826], [-121.05842, 39.21828], [-121.05813, 39.21785], [-121.0587, 39.21786], [-121.05875, 39.21793]]]} Open Access 1 45357 Dow Alexander Park 18253 1673 Grass Valley, City of 1042 City 2 City Agency 2 http://www.cityofgrassvalley.com/departments/parks-and-rec/city-parks City 2 1673 Grass Valley, City of 712 City 2 City Agency 2   Nevada 30 0.356 Dow Alexander 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]);