units_with_maps

Table actions

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

1 row where COUNTY = 41, DES_TP = 985 and MNG_AG_TYP = 4

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Recreation/Parks District · 1 ✖

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
11270 11270 11269 {"type": "MultiPolygon", "coordinates": [[[[-121.30369, 38.49136], [-121.29786, 38.49132], [-121.29784, 38.4889], [-121.30251, 38.48891], [-121.30252, 38.48894], [-121.30366, 38.48894], [-121.30369, 38.49136]]], [[[-121.31605, 38.46467], [-121.31569, 38.46467], [-121.31545, 38.46469], [-121.3152, 38.46475], [-121.31494, 38.46485], [-121.31489, 38.46486], [-121.31484, 38.46483], [-121.31425, 38.46426], [-121.31403, 38.46409], [-121.31363, 38.46387], [-121.31323, 38.46373], [-121.31249, 38.46355], [-121.31219, 38.4635], [-121.31084, 38.46343], [-121.31049, 38.46339], [-121.31015, 38.46331], [-121.30949, 38.46309], [-121.30919, 38.46302], [-121.3088, 38.463], [-121.30845, 38.46303], [-121.30718, 38.46329], [-121.30693, 38.46336], [-121.30664, 38.46347], [-121.30619, 38.46369], [-121.30545, 38.46417], [-121.30525, 38.46431], [-121.30504, 38.46452], [-121.30483, 38.46481], [-121.3041, 38.4663], [-121.30334, 38.4671], [-121.30043, 38.4671], [-121.30069, 38.4669], [-121.30202, 38.46628], [-121.30248, 38.466], [-121.30291, 38.46547], [-121.30293, 38.46503], [-121.30287, 38.4641], [-121.30299, 38.46363], [-121.30301, 38.46338], [-121.30352, 38.46257], [-121.30434, 38.46231], [-121.30737, 38.46216], [-121.30796, 38.46155], [-121.30874, 38.46128], [-121.30949, 38.46142], [-121.3106, 38.46198], [-121.31097, 38.46201], [-121.31413, 38.46142], [-121.31529, 38.46197], [-121.31604, 38.46216], [-121.31605, 38.46467]]]]} Open Access 1 21745 SOUTHGATE RECREATION/PARK DISTRICT 25690 2160 Southgate Recreation and Park District 502 Special District 4 Recreation/Parks District 4 http://www.southgaterecandpark.net/ Special District 4 2160 Southgate Recreation and Park District 494 Special District 4 Recreation/Parks District 4   Sacramento 41 105.753 SOUTHGATE RECREATION/PARK DISTRICT   None 985  

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]);