units_with_maps

Table actions

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

1 row where AGNCY_TYP = 3, DES_TP = 2, LABEL_NAME = "Henningsen Lotus Park" and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Park · 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
10930 10930 10929 {"type": "Polygon", "coordinates": [[[-120.91121, 38.80136], [-120.91028, 38.8028], [-120.91016, 38.80327], [-120.91004, 38.8035], [-120.9097, 38.80378], [-120.90941, 38.80387], [-120.90941, 38.80409], [-120.90835, 38.8041], [-120.90657, 38.80434], [-120.90645, 38.80435], [-120.90543, 38.8045], [-120.90504, 38.80472], [-120.90409, 38.80498], [-120.90321, 38.80497], [-120.90243, 38.8056], [-120.90242, 38.80568], [-120.90217, 38.80582], [-120.90133, 38.8066], [-120.90101, 38.80719], [-120.90106, 38.8074], [-120.90104, 38.80778], [-120.90059, 38.80847], [-120.90017, 38.80857], [-120.90017, 38.8085], [-120.90008, 38.80835], [-120.90008, 38.80822], [-120.90013, 38.80769], [-120.90017, 38.80739], [-120.89996, 38.80736], [-120.90003, 38.80711], [-120.90012, 38.8069], [-120.90012, 38.80679], [-120.90037, 38.80639], [-120.90047, 38.80642], [-120.90082, 38.806], [-120.9008, 38.80597], [-120.90119, 38.80559], [-120.90117, 38.80555], [-120.90142, 38.80532], [-120.90185, 38.80501], [-120.90241, 38.80503], [-120.90262, 38.80481], [-120.90334, 38.80446], [-120.90367, 38.80416], [-120.90387, 38.80373], [-120.90416, 38.80324], [-120.90364, 38.80302], [-120.90546, 38.80173], [-120.90683, 38.80131], [-120.9076, 38.80179], [-120.90709, 38.80188], [-120.90699, 38.80194], [-120.907, 38.80196], [-120.90927, 38.80203], [-120.90948, 38.80139], [-120.91121, 38.80136]]]} Open Access 1 20945 Henningsen Lotus Park 19821 351 El Dorado, County of 414 County 3 County Agency 3 http://www.edcgov.us/Parks/ County 3 351 El Dorado, County of 408 County 3 County Agency 3   El Dorado 34 49.243 Henningsen Lotus 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]);