units_with_maps

Table actions

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

1 row where AGNCY_LEV = 2 and DES_TP = 475

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 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
5945 5945 5944 {"type": "Polygon", "coordinates": [[[-119.69499, 34.40303], [-119.69487, 34.40308], [-119.69454, 34.40328], [-119.69431, 34.40361], [-119.69416, 34.40436], [-119.69411, 34.4044], [-119.6942, 34.40471], [-119.69451, 34.40523], [-119.69453, 34.40539], [-119.69436, 34.40701], [-119.69433, 34.40713], [-119.69425, 34.40736], [-119.69413, 34.40758], [-119.69397, 34.40777], [-119.69385, 34.40789], [-119.69365, 34.40807], [-119.6936, 34.40805], [-119.69183, 34.40968], [-119.68981, 34.41138], [-119.68908, 34.41202], [-119.68861, 34.41172], [-119.68875, 34.41149], [-119.68913, 34.41125], [-119.68933, 34.41106], [-119.6896, 34.41072], [-119.68985, 34.41045], [-119.69007, 34.41014], [-119.69037, 34.4098], [-119.69048, 34.40968], [-119.69095, 34.4093], [-119.69144, 34.40892], [-119.69169, 34.4087], [-119.6919, 34.4084], [-119.69229, 34.40799], [-119.69239, 34.40782], [-119.69244, 34.40763], [-119.69251, 34.40751], [-119.6926, 34.40739], [-119.69279, 34.40689], [-119.69284, 34.40662], [-119.69291, 34.40651], [-119.69301, 34.40641], [-119.69335, 34.40585], [-119.69366, 34.40559], [-119.69379, 34.40541], [-119.69394, 34.40523], [-119.69401, 34.40511], [-119.69406, 34.40497], [-119.69408, 34.40477], [-119.69188, 34.40313], [-119.69141, 34.40331], [-119.69132, 34.40338], [-119.69111, 34.40346], [-119.69068, 34.40369], [-119.6902, 34.40385], [-119.68996, 34.40398], [-119.68969, 34.40409], [-119.68948, 34.40415], [-119.68917, 34.40431], [-119.68905, 34.40444], [-119.68887, 34.40475], [-119.68867, 34.40495], [-119.68857, 34.40546], [-119.68865, 34.40575], [-119.68871, 34.40584], [-119.68872, 34.40608], [-119.68928, 34.40696], [-119.68924, 34.40705], [-119.68901, 34.40719], [-119.68896, 34.4075], [-119.68881, 34.40757], [-119.68835, 34.40763], [-119.68816, 34.40759], [-119.68786, 34.40746], [-119.68763, 34.40728], [-119.68753, 34.407], [-119.68765, 34.40652], [-119.68781, 34.40621], [-119.6879, 34.40539], [-119.68785, 34.40501], [-119.68756, 34.40499], [-119.68714, 34.40514], [-119.68705, 34.40509], [-119.68704, 34.40502], [-119.68707, 34.40497], [-119.68786, 34.4046], [-119.68859, 34.40433], [-119.689, 34.40415], [-119.68941, 34.40399], [-119.68973, 34.40384], [-119.69088, 34.40338], [-119.69117, 34.40322], [-119.69131, 34.40318], [-119.69192, 34.40295], [-119.69204, 34.40296], [-119.69233, 34.40306], [-119.69314, 34.40285], [-119.69444, 34.40258], [-119.69499, 34.40303]]]} Open Access 1 507 Santa Barbara Maitime Museum 25052 1317 Santa Barbara, City of 26 City 2 City Agency 2 http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp City 2 1317 Santa Barbara, City of 26 City 2 City Agency 2   Santa Barbara 7 39.477 Santa Barbara Maitime Museum   None 475  

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