units_with_maps

Table actions

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

8 rows where LABEL_NAME = "Triangle Park" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 8 ✖

DES_TP 1

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
143 143 142 {"type": "Polygon", "coordinates": [[[-120.7625, 37.64543], [-120.76246, 37.64548], [-120.76191, 37.64548], [-120.76182, 37.6454], [-120.76219, 37.64516], [-120.76229, 37.64518], [-120.7625, 37.64543]]]} Open Access 1 447 Triangle Park 26534 1372 Waterford, City of 57 City 2 City Agency 2 http://www.cityofwaterford.org/departments/parks-and-recreation/ City 2 1372 Waterford, City of 55 City 2 City Agency 2   Stanislaus 2 0.333 Triangle Park 0 Local Park 2 4
4118 4118 4117 {"type": "Polygon", "coordinates": [[[-122.70017, 38.45107], [-122.69985, 38.45112], [-122.69976, 38.45111], [-122.6999, 38.45099], [-122.69998, 38.45089], [-122.70003, 38.45087], [-122.70008, 38.4509], [-122.70012, 38.45099], [-122.70017, 38.45107]]]} Open Access 1 48268 Triangle Park 32821 1324 Santa Rosa, City of 30 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 1324 Santa Rosa, City of 29 City 2 City Agency 2   Sonoma 16 0.122 Triangle Park 0 Local Park 2 4
5133 5133 5132 {"type": "Polygon", "coordinates": [[[-121.45225, 38.61393], [-121.45152, 38.61433], [-121.45093, 38.61471], [-121.45092, 38.61393], [-121.45225, 38.61393]]]} Open Access 1 21098 Triangle Park 26532 1287 Sacramento, City of 541 City 2 City Agency 2 http://portal.cityofsacramento.org/ParksandRec City 2 1287 Sacramento, City of 534 City 2 City Agency 2   Sacramento 41 1.212 Triangle Park 0 Local Park 2 4
5269 5269 5268 {"type": "Polygon", "coordinates": [[[-117.9999, 33.66174], [-117.9991, 33.66252], [-117.99902, 33.66247], [-117.99902, 33.66178], [-117.99905, 33.66172], [-117.99913, 33.66169], [-117.9993, 33.66173], [-117.99953, 33.66176], [-117.99971, 33.66176], [-117.9999, 33.66174]]]} Open Access 1 47379 Triangle Park 31102 1141 Huntington Beach, City of 125 City 2 City Agency 2 http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm City 2 1141 Huntington Beach, City of 122 City 2 City Agency 2 http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/triangle-park.cfm Orange 3 0.929 Triangle Park 0 Local Park 2 4
6075 6075 6074 {"type": "Polygon", "coordinates": [[[-117.17879, 32.69601], [-117.17842, 32.69585], [-117.1786, 32.69554], [-117.17869, 32.69578], [-117.17879, 32.69601]]]} Open Access 1 821 Triangle Park 26530 1069 Coronado, City of 105 City 2 City Agency 2 http://www.coronado.ca.us/category/subcategory-rec.php City 2 1069 Coronado, City of 102 City 2 City Agency 2 http://www.welcometocoronado.com/coronado-living/coronado-parks/ San Diego 4 0.188 Triangle Park 0 Local Park 2 4
7175 7175 7174 {"type": "Polygon", "coordinates": [[[-118.4562, 33.98757], [-118.45619, 33.98741], [-118.45652, 33.98749], [-118.45654, 33.98752], [-118.45652, 33.98755], [-118.4562, 33.98757]]]} Open Access 1 6336 Triangle Park 26531 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2 http://www.laparks.org/dos/parks/facility/trianglePk.htm Los Angeles 6 0.09 Triangle Park 0 Local Park 2 4
10826 10826 10825 {"type": "Polygon", "coordinates": [[[-118.18082, 33.94611], [-118.18022, 33.94603], [-118.18067, 33.94535], [-118.18082, 33.94611], [-118.18082, 33.94611]]]} Open Access 1 20620 Triangle Park 26533 1339 South Gate, City of 657 City 2 City Agency 2 http://www.cityofsouthgate.org/ City 2 1339 South Gate, City of 645 City 2 City Agency 2   Los Angeles 6 0.568 Triangle Park 0 Local Park 2 4
15350 15350 15349 {"type": "Polygon", "coordinates": [[[-118.08176, 34.04087], [-118.08176, 34.04087], [-118.08063, 34.04088], [-118.08071, 34.04082], [-118.08105, 34.04074], [-118.08137, 34.04063], [-118.08146, 34.04063], [-118.08176, 34.04087]]]} Open Access 1 46554 Triangle Park 29849 1284 Rosemead, City of 130 City 2 City Agency 2 http://www.cityofrosemead.org/index.aspx?page=74 City 2 1284 Rosemead, City of 127 City 2 City Agency 2   Los Angeles 6 0.393 Triangle 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]);