units_with_maps

Table actions

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

3 rows where AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 252

This data as json, copyable, CSV (advanced)

ACCESS_TYP 2

MNG_AG_TYP 1

MNG_AGENCY 1

  • Livermore, City of · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖
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
781 781 780 {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} Restricted Access 2 5062 Las Positas Golf Course 33002 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 216.12 Las Positas GC 0 Local Recreation Area 3 4
1561 1561 1560 {"type": "Polygon", "coordinates": [[[-121.76382, 37.67746], [-121.76279, 37.67776], [-121.76246, 37.67699], [-121.76349, 37.67669], [-121.76382, 37.67746]]]} Open Access 1 11728 Bothwell Recreation Center 16293 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 2.176 Bothwell Rec. Ctr. 0 Local Recreation Area 3 4
2497 2497 2496 {"type": "Polygon", "coordinates": [[[-121.78361, 37.67491], [-121.7835, 37.67498], [-121.78311, 37.67502], [-121.78209, 37.67494], [-121.78073, 37.67462], [-121.78006, 37.67423], [-121.77944, 37.67395], [-121.77806, 37.67357], [-121.77751, 37.67545], [-121.77661, 37.67525], [-121.77663, 37.67487], [-121.776, 37.67457], [-121.77489, 37.67428], [-121.77458, 37.67395], [-121.77465, 37.67363], [-121.77378, 37.67351], [-121.77373, 37.67258], [-121.76847, 37.67254], [-121.76781, 37.67242], [-121.76786, 37.67183], [-121.76847, 37.67197], [-121.76995, 37.67158], [-121.77045, 37.67153], [-121.77105, 37.67156], [-121.77122, 37.6718], [-121.77298, 37.67169], [-121.77451, 37.67172], [-121.77516, 37.67167], [-121.77605, 37.67168], [-121.7769, 37.67172], [-121.77753, 37.67182], [-121.77823, 37.67197], [-121.77888, 37.67224], [-121.77907, 37.6725], [-121.77917, 37.67281], [-121.7792, 37.67316], [-121.77983, 37.67342], [-121.78022, 37.67342], [-121.78012, 37.67384], [-121.78189, 37.67423], [-121.78196, 37.67411], [-121.78283, 37.67445], [-121.78361, 37.67491]]]} Open Access 1 17532 Madeiros Parkway 21649 1178 Livermore, City of 256 City 2 City Agency 2 http://www.larpd.org/parks/parks.html City 2 1178 Livermore, City of 252 City 2 City Agency 2   Alameda 17 51.175 Madeiros Parkway 0 Local Recreation Area 3 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]);