units_with_maps

Table actions

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

3 rows where COUNTY = 10, DES_TP = 3 and MNG_AGENCY = 356

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Temecula, City of · 3 ✖

DES_TP 1

  • Local Recreation Area · 3 ✖

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
12005 12005 12004 {"type": "Polygon", "coordinates": [[[-117.09832, 33.45288], [-117.09729, 33.45379], [-117.09709, 33.45401], [-117.09692, 33.45424], [-117.09675, 33.45454], [-117.09662, 33.45489], [-117.09655, 33.45521], [-117.09653, 33.45553], [-117.09333, 33.45554], [-117.09182, 33.4544], [-117.09582, 33.45067], [-117.09649, 33.45127], [-117.09803, 33.4527], [-117.09814, 33.45279], [-117.09832, 33.45288]]]} Open Access 1 24674 Patricia H. Birdsall Sports Park 23508 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 44.044 Patricia H. Birdsall Sports Park 0 Local Recreation Area 3 4
12007 12007 12006 {"type": "Polygon", "coordinates": [[[-117.12532, 33.49784], [-117.1252, 33.49987], [-117.1246, 33.49986], [-117.12394, 33.49991], [-117.12358, 33.49997], [-117.12323, 33.50005], [-117.12271, 33.50021], [-117.12219, 33.50042], [-117.12175, 33.50065], [-117.12135, 33.5009], [-117.12068, 33.50139], [-117.1206, 33.50131], [-117.12044, 33.50134], [-117.12044, 33.5014], [-117.12054, 33.50149], [-117.12035, 33.50163], [-117.11966, 33.50101], [-117.11988, 33.50085], [-117.11987, 33.50076], [-117.11974, 33.50063], [-117.11947, 33.50083], [-117.11675, 33.49838], [-117.11641, 33.49809], [-117.1162, 33.49795], [-117.11677, 33.49763], [-117.11708, 33.4975], [-117.1174, 33.49739], [-117.11773, 33.4973], [-117.11807, 33.49724], [-117.11841, 33.49721], [-117.12046, 33.4971], [-117.12032, 33.49805], [-117.12014, 33.49817], [-117.12002, 33.4985], [-117.11986, 33.49908], [-117.12005, 33.4992], [-117.12075, 33.49932], [-117.12135, 33.49929], [-117.12141, 33.4986], [-117.12104, 33.49844], [-117.12172, 33.49814], [-117.1221, 33.49799], [-117.12241, 33.4979], [-117.12281, 33.49781], [-117.12314, 33.49776], [-117.12364, 33.49772], [-117.12426, 33.49773], [-117.12532, 33.49784]]]} Open Access 1 24676 Ronald Reagan Sports Park 24591 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2   Riverside 10 52.442 Ronald Reagan Sports Park 0 Local Recreation Area 3 4
14445 14445 14444 {"type": "Polygon", "coordinates": [[[-117.12141, 33.49859], [-117.12135, 33.49929], [-117.12075, 33.49932], [-117.12005, 33.4992], [-117.11986, 33.49909], [-117.12002, 33.4985], [-117.12015, 33.49817], [-117.12032, 33.49805], [-117.12098, 33.49847], [-117.12104, 33.49844], [-117.12141, 33.49859]]]} Open Access 1 47173 Temecula Skate Park 30864 1392 Temecula, City of 359 City 2 City Agency 2 http://www.cityoftemecula.org/ City 2 1392 Temecula, City of 356 City 2 City Agency 2 http://www.cityoftemecula.org/Temecula/Residents/ParksFacilities/SkatePark.htm Riverside 10 3.466 Temecula Skate Park 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]);