units_with_maps

Table actions

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

4 rows where AGNCY_WEB = "http://www.ci.piedmont.ca.us/" and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 1

  • Local Park · 4 ✖

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
3669 3669 3668 {"type": "Polygon", "coordinates": [[[-122.24716, 37.82328], [-122.24694, 37.82343], [-122.24704, 37.82379], [-122.24697, 37.82383], [-122.24686, 37.8237], [-122.24665, 37.82319], [-122.24594, 37.82256], [-122.24562, 37.82222], [-122.24612, 37.82207], [-122.24623, 37.82214], [-122.24621, 37.82224], [-122.24623, 37.82235], [-122.24647, 37.82266], [-122.24693, 37.82302], [-122.24716, 37.82328]]]} Open Access 1 44215 Linda Park 21281 1251 Piedmont, City of 562 City 2 City Agency 2 http://www.ci.piedmont.ca.us/ City 2 1251 Piedmont, City of 554 City 2 City Agency 2   Alameda 17 1.594 Linda Park 0 Local Park 2 4
8932 8932 8931 {"type": "Polygon", "coordinates": [[[-122.22511, 37.81892], [-122.2251, 37.81909], [-122.22408, 37.8191], [-122.22407, 37.81894], [-122.22407, 37.8183], [-122.22511, 37.81892]]]} Open Access 1 14678 Crocker Park 17824 1251 Piedmont, City of 562 City 2 City Agency 2 http://www.ci.piedmont.ca.us/ City 2 1251 Piedmont, City of 554 City 2 City Agency 2   Alameda 17 1.22 Crocker Park 0 Local Park 2 4
9440 9440 9439 {"type": "Polygon", "coordinates": [[[-122.2404, 37.82629], [-122.23916, 37.82686], [-122.23908, 37.82686], [-122.23903, 37.82689], [-122.239, 37.82693], [-122.23901, 37.82698], [-122.23907, 37.82702], [-122.23913, 37.82715], [-122.23891, 37.82753], [-122.23909, 37.82763], [-122.23823, 37.8287], [-122.23807, 37.82879], [-122.23796, 37.82881], [-122.23785, 37.82881], [-122.23807, 37.82812], [-122.23819, 37.82792], [-122.23822, 37.82784], [-122.23823, 37.82777], [-122.23817, 37.82726], [-122.23813, 37.82714], [-122.23804, 37.82701], [-122.23785, 37.82685], [-122.23772, 37.82679], [-122.23718, 37.82659], [-122.23764, 37.82626], [-122.23824, 37.826], [-122.23899, 37.82636], [-122.24033, 37.82617], [-122.2404, 37.82629]]]} Open Access 1 15785 Dracena Park 18270 1251 Piedmont, City of 562 City 2 City Agency 2 http://www.ci.piedmont.ca.us/ City 2 1251 Piedmont, City of 554 City 2 City Agency 2   Alameda 17 7.02 Dracena Park 0 Local Park 2 4
10519 10519 10518 {"type": "Polygon", "coordinates": [[[-122.23713, 37.82125], [-122.23436, 37.82229], [-122.23394, 37.82288], [-122.23379, 37.82294], [-122.23363, 37.82305], [-122.23259, 37.82386], [-122.23241, 37.82397], [-122.23223, 37.82404], [-122.23134, 37.82427], [-122.23067, 37.8245], [-122.23055, 37.8245], [-122.23045, 37.82445], [-122.23, 37.82388], [-122.22989, 37.82379], [-122.22966, 37.82368], [-122.2296, 37.8236], [-122.2296, 37.82324], [-122.23029, 37.82319], [-122.23039, 37.82314], [-122.23043, 37.82305], [-122.23104, 37.82306], [-122.23121, 37.82322], [-122.2318, 37.82274], [-122.23186, 37.82274], [-122.23195, 37.82266], [-122.23217, 37.82237], [-122.23237, 37.82205], [-122.23251, 37.82171], [-122.23241, 37.82158], [-122.23257, 37.82143], [-122.23372, 37.82004], [-122.23387, 37.82012], [-122.23401, 37.82016], [-122.23424, 37.82017], [-122.23444, 37.82013], [-122.23463, 37.82003], [-122.23512, 37.81959], [-122.23527, 37.81951], [-122.23529, 37.8195], [-122.23713, 37.82125]]]} Open Access 1 18690 Piedmont Park 23659 1251 Piedmont, City of 562 City 2 City Agency 2 http://www.ci.piedmont.ca.us/ City 2 1251 Piedmont, City of 554 City 2 City Agency 2   Alameda 17 31.129 Piedmont 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]);