units_with_maps

Table actions

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

8 rows where ACCESS_TYP = 1 and AGNCY_WEB = "http://www.cathedralcity.gov/index.aspx?page=490"

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 8 ✖
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
3207 3207 3206 {"type": "Polygon", "coordinates": [[[-116.45782, 33.80354], [-116.45775, 33.80354], [-116.45775, 33.80353], [-116.45733, 33.80318], [-116.45732, 33.80237], [-116.45718, 33.80209], [-116.45693, 33.80178], [-116.45654, 33.80169], [-116.45577, 33.80168], [-116.45534, 33.80181], [-116.45506, 33.80207], [-116.45499, 33.80207], [-116.45498, 33.80158], [-116.45772, 33.80157], [-116.4578, 33.80164], [-116.45782, 33.80354]]]} Open Access 1 28137 Patriot Park 23512 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2   Riverside 10 3.56 Patriot Park 0 Local Park 2 4
5398 5398 5397 {"type": "Polygon", "coordinates": [[[-116.46342, 33.80566], [-116.46342, 33.80671], [-116.46339, 33.80676], [-116.46334, 33.80677], [-116.46152, 33.80678], [-116.46148, 33.80677], [-116.46145, 33.80674], [-116.46142, 33.80596], [-116.46182, 33.80595], [-116.46182, 33.8055], [-116.46243, 33.80549], [-116.46261, 33.8055], [-116.46303, 33.80549], [-116.46303, 33.80567], [-116.46342, 33.80566]]]} Open Access 1 47903 Ocotillo Park 31989 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2 http://www.cathedralcity.gov/Home/Components/FacilityDirectory/FacilityDirectory/12/1768 Riverside 10 5.823 Ocotillo Park 0 Local Park 2 4
10746 10746 10745 {"type": "Polygon", "coordinates": [[[-116.44234, 33.82833], [-116.44229, 33.82838], [-116.44163, 33.82837], [-116.44146, 33.82835], [-116.44132, 33.82838], [-116.44093, 33.82838], [-116.44092, 33.82714], [-116.44101, 33.82706], [-116.44228, 33.82706], [-116.44233, 33.8271], [-116.44234, 33.82833]]]} Open Access 1 19966 Century Park 17078 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2   Riverside 10 4.677 Century Park 0 Local Park 2 4
10747 10747 10746 {"type": "Polygon", "coordinates": [[[-116.46793, 33.83928], [-116.46798, 33.83901], [-116.46797, 33.839], [-116.46765, 33.83896], [-116.4676, 33.83924], [-116.46711, 33.83921], [-116.46705, 33.83919], [-116.467, 33.83915], [-116.46698, 33.83908], [-116.46698, 33.8379], [-116.46701, 33.83783], [-116.46706, 33.83779], [-116.46713, 33.83778], [-116.46909, 33.83777], [-116.46919, 33.83781], [-116.46923, 33.83788], [-116.46923, 33.83807], [-116.4692, 33.83828], [-116.46914, 33.83851], [-116.46874, 33.83939], [-116.46869, 33.83942], [-116.46864, 33.83943], [-116.46839, 33.83937], [-116.46793, 33.83928]]]} Open Access 1 19967 Panorama Park 23391 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2   Riverside 10 7.827 Panorama Park 0 Local Park 2 4
10749 10749 10748 {"type": "Polygon", "coordinates": [[[-116.46453, 33.78095], [-116.4636, 33.78095], [-116.46359, 33.78045], [-116.46447, 33.78045], [-116.46447, 33.78054], [-116.46453, 33.78067], [-116.46453, 33.78095]]]} Open Access 1 19970 Town Square Park 26492 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2   Riverside 10 1.166 Town Square Park 0 Local Park 2 4
11363 11363 11362 {"type": "Polygon", "coordinates": [[[-116.46035, 33.7813], [-116.45927, 33.78098], [-116.45847, 33.78081], [-116.45847, 33.78064], [-116.45818, 33.78064], [-116.45818, 33.78047], [-116.45843, 33.78046], [-116.45844, 33.78044], [-116.46022, 33.78043], [-116.46023, 33.78106], [-116.46035, 33.78107], [-116.46035, 33.7813]]]} Open Access 1 22149 Second Street Park 25279 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2   Riverside 10 2.784 Second Street Park 0 Local Park 2 4
14059 14059 14058 {"type": "Polygon", "coordinates": [[[-116.45144, 33.83402], [-116.44969, 33.83403], [-116.44961, 33.83396], [-116.44961, 33.83067], [-116.44968, 33.83063], [-116.4514, 33.83063], [-116.45144, 33.83402]]]} Open Access 1 39063 Dennis Keat Soccer Park 18090 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2   Riverside 10 15.616 Dennis Keat Soccer Park 0 Local Recreation Area 3 4
14060 14060 14059 {"type": "Polygon", "coordinates": [[[-116.46672, 33.78273], [-116.46671, 33.7829], [-116.46666, 33.78295], [-116.46641, 33.78294], [-116.46641, 33.78273], [-116.46672, 33.78273]]]} Open Access 1 39064 Memorial Park 22122 1049 Cathedral City, City of 595 City 2 City Agency 2 http://www.cathedralcity.gov/index.aspx?page=490 City 2 1049 Cathedral City, City of 585 City 2 City Agency 2   Riverside 10 0.163 Memorial 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]);