units_with_maps

Table actions

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

2 rows where AGNCY_NAME = 169, DES_TP = 19 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 2 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Historic or Cultural Area · 2 ✖

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
6507 6507 6506 {"type": "Polygon", "coordinates": [[[-117.42105, 33.99374], [-117.42104, 33.99393], [-117.42094, 33.99387], [-117.42032, 33.99432], [-117.41971, 33.9945], [-117.41891, 33.99527], [-117.41837, 33.99521], [-117.41467, 33.99321], [-117.41633, 33.99213], [-117.4184, 33.99191], [-117.42105, 33.99374]]]} Open Access 1 2430 Jensen-Alvarado Ranch Historical Park 20393 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 30.063 Jensen-Alvarado Ranch Historical Park 0 Local Historic or Cultural Area 19 4
11352 11352 11351 {"type": "Polygon", "coordinates": [[[-116.90313, 33.94334], [-116.89857, 33.94333], [-116.89827, 33.94266], [-116.89791, 33.94223], [-116.89766, 33.9413], [-116.89702, 33.9398], [-116.89651, 33.93845], [-116.8965, 33.93756], [-116.8943, 33.93447], [-116.8943, 33.93254], [-116.89922, 33.93253], [-116.89923, 33.93542], [-116.89855, 33.93543], [-116.89855, 33.93599], [-116.89923, 33.936], [-116.89923, 33.9367], [-116.90309, 33.93967], [-116.90313, 33.94334]]]} Open Access 1 22147 Gilman Historic Ranch Park 19295 315 Riverside, County of 169 County 3 County Agency 3 http://www.rivcoparks.org/ County 3 315 Riverside, County of 165 County 3 County Agency 3   Riverside 10 131.555 Gilman Historic Ranch Park 0 Local Historic or Cultural Area 19 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]);