units_with_maps

Table actions

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

1 row where ACCESS_TYP = 4, LABEL_NAME = "San Jose Creek OS" and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • County Agency · 1 ✖

MNG_AGENCY 1

ACCESS_TYP 1

  • Unknown Access · 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
15974 15974 15973 {"type": "MultiPolygon", "coordinates": [[[[-119.81332, 34.45598], [-119.81288, 34.45617], [-119.81225, 34.45579], [-119.81214, 34.45568], [-119.81209, 34.45571], [-119.81199, 34.45548], [-119.81194, 34.45517], [-119.81158, 34.45496], [-119.81142, 34.45533], [-119.81138, 34.45536], [-119.81135, 34.45542], [-119.81137, 34.4555], [-119.81145, 34.45559], [-119.8115, 34.45578], [-119.81148, 34.45592], [-119.8114, 34.45609], [-119.81136, 34.45621], [-119.81136, 34.45643], [-119.81134, 34.45646], [-119.81119, 34.45654], [-119.81111, 34.45662], [-119.81093, 34.45692], [-119.81062, 34.45753], [-119.8103, 34.45739], [-119.81042, 34.4569], [-119.80997, 34.45714], [-119.80956, 34.45682], [-119.80933, 34.45651], [-119.80908, 34.4565], [-119.80894, 34.45612], [-119.80929, 34.45603], [-119.80957, 34.45575], [-119.80968, 34.4558], [-119.80969, 34.4561], [-119.81035, 34.4561], [-119.81047, 34.45579], [-119.81042, 34.45575], [-119.81048, 34.45568], [-119.8105, 34.45559], [-119.8105, 34.45431], [-119.81053, 34.45429], [-119.81115, 34.45429], [-119.81129, 34.45426], [-119.81139, 34.45421], [-119.81146, 34.45416], [-119.81153, 34.45407], [-119.81158, 34.45396], [-119.81159, 34.45408], [-119.81196, 34.45403], [-119.81204, 34.45397], [-119.81207, 34.45383], [-119.81229, 34.45385], [-119.81229, 34.45306], [-119.81384, 34.45306], [-119.81408, 34.45307], [-119.81411, 34.4531], [-119.81412, 34.45313], [-119.81401, 34.45326], [-119.81387, 34.45335], [-119.81367, 34.45343], [-119.81356, 34.45348], [-119.81346, 34.45357], [-119.81339, 34.45366], [-119.81331, 34.45385], [-119.81322, 34.45435], [-119.81289, 34.45432], [-119.81286, 34.45461], [-119.81251, 34.45474], [-119.81236, 34.45497], [-119.81251, 34.45525], [-119.81269, 34.45538], [-119.81294, 34.45543], [-119.81309, 34.45578], [-119.81332, 34.45598]]], [[[-119.81048, 34.45784], [-119.81042, 34.45797], [-119.81006, 34.45793], [-119.80996, 34.45812], [-119.80972, 34.45833], [-119.80961, 34.45878], [-119.80941, 34.45916], [-119.80963, 34.45934], [-119.80984, 34.45945], [-119.81, 34.4595], [-119.80999, 34.45955], [-119.80985, 34.45956], [-119.8098, 34.4595], [-119.80931, 34.45923], [-119.80912, 34.45888], [-119.80925, 34.4583], [-119.80955, 34.45781], [-119.81004, 34.45766], [-119.81042, 34.45785], [-119.81048, 34.45784]]], [[[-119.81501, 34.458], [-119.815, 34.45855], [-119.81493, 34.45851], [-119.81494, 34.45848], [-119.81485, 34.45842], [-119.81481, 34.45845], [-119.81458, 34.45833], [-119.81417, 34.45818], [-119.81412, 34.45791], [-119.81387, 34.45777], [-119.81367, 34.45716], [-119.81363, 34.45682], [-119.81339, 34.45641], [-119.8131, 34.45626], [-119.81363, 34.45603], [-119.81367, 34.45604], [-119.81376, 34.4562], [-119.81383, 34.45639], [-119.81407, 34.45734], [-119.81419, 34.45756], [-119.81434, 34.45772], [-119.81452, 34.45785], [-119.81478, 34.45796], [-119.81501, 34.458]]], [[[-119.8154, 34.45898], [-119.81531, 34.45912], [-119.81528, 34.45914], [-119.81495, 34.45882], [-119.81494, 34.45878], [-119.81462, 34.45852], [-119.8154, 34.45898]]]]} Unknown Access 4 339 San Jose Creek Open Space 24915 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 23.422 San Jose Creek OS 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]);