units_with_maps

Table actions

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

1 row where AGNCY_WEB = "http://cosb.countyofsb.org/parks/", DES_TP = 480 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

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
5981 5981 5980 {"type": "MultiPolygon", "coordinates": [[[[-120.57149, 34.97539], [-120.57144, 34.97556], [-120.57136, 34.97569], [-120.57125, 34.97578], [-120.57111, 34.97585], [-120.57117, 34.97538], [-120.57149, 34.97539]]], [[[-120.57027, 34.97531], [-120.57026, 34.97583], [-120.56846, 34.97601], [-120.56811, 34.97606], [-120.56776, 34.97608], [-120.56742, 34.97607], [-120.56707, 34.97602], [-120.56673, 34.97595], [-120.56573, 34.97567], [-120.5635, 34.97513], [-120.56095, 34.97464], [-120.55788, 34.97431], [-120.55621, 34.97422], [-120.55444, 34.97367], [-120.55789, 34.97375], [-120.5579, 34.97386], [-120.56036, 34.9741], [-120.56361, 34.97468], [-120.56368, 34.97454], [-120.56401, 34.97461], [-120.56396, 34.97476], [-120.56397, 34.97477], [-120.56707, 34.97552], [-120.56736, 34.97556], [-120.56766, 34.97558], [-120.56797, 34.97557], [-120.57027, 34.97531]]], [[[-120.55274, 34.97282], [-120.55227, 34.97363], [-120.54431, 34.97442], [-120.54358, 34.97544], [-120.54006, 34.97599], [-120.51284, 34.98081], [-120.51265, 34.97972], [-120.51277, 34.97971], [-120.51284, 34.98009], [-120.513, 34.98022], [-120.53916, 34.97546], [-120.53998, 34.97431], [-120.54702, 34.97309], [-120.55274, 34.97282]]], [[[-120.53866, 34.98161], [-120.53788, 34.98229], [-120.51433, 34.98672], [-120.51413, 34.98716], [-120.51421, 34.98764], [-120.51408, 34.98765], [-120.51384, 34.9863], [-120.53866, 34.98161]]], [[[-120.47587, 34.98734], [-120.47586, 34.98785], [-120.4659, 34.98969], [-120.46394, 34.98997], [-120.46217, 34.99011], [-120.45826, 34.98975], [-120.45272, 34.98952], [-120.45272, 34.98923], [-120.453, 34.98925], [-120.45301, 34.98943], [-120.45678, 34.98961], [-120.45761, 34.98969], [-120.45762, 34.98963], [-120.45999, 34.98971], [-120.46285, 34.98957], [-120.46286, 34.98949], [-120.46302, 34.98948], [-120.46302, 34.98954], [-120.46364, 34.98949], [-120.46588, 34.98917], [-120.47587, 34.98734]]], [[[-120.47967, 34.98664], [-120.47965, 34.99181], [-120.47784, 34.99165], [-120.47789, 34.98694], [-120.47967, 34.98664]]], [[[-120.51386, 34.98767], [-120.51376, 34.98768], [-120.51368, 34.98716], [-120.51331, 34.98688], [-120.51188, 34.98728], [-120.50779, 34.9882], [-120.50391, 34.98892], [-120.4877, 34.99201], [-120.48536, 34.99237], [-120.48337, 34.99218], [-120.48345, 34.98595], [-120.4854, 34.98558], [-120.48776, 34.98517], [-120.48777, 34.98558], [-120.4877, 34.99145], [-120.48771, 34.99146], [-120.51138, 34.98689], [-120.51362, 34.98635], [-120.51386, 34.98767]]]]} Open Access 1 574 Santa Maria River 11840 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 285.306 Santa Maria River 0 None 480  

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