units_with_maps

Table actions

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

1 row where AGNCY_WEB = "http://www.srcsd.com/", DES_TP = 14 and MNG_AGENCY = 575

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Sacramento Regional County Sanitation District · 1 ✖

DES_TP 1

  • Local Other or Unknown · 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
16844 16844 16843 {"type": "MultiPolygon", "coordinates": [[[[-121.49294, 38.45629], [-121.49213, 38.45647], [-121.49218, 38.45685], [-121.48371, 38.45792], [-121.48343, 38.458], [-121.48326, 38.45807], [-121.48306, 38.45818], [-121.4818, 38.45908], [-121.48117, 38.4597], [-121.48029, 38.46047], [-121.47972, 38.46077], [-121.47927, 38.461], [-121.47857, 38.46131], [-121.47809, 38.4615], [-121.4773, 38.46178], [-121.47655, 38.46201], [-121.47578, 38.46221], [-121.47474, 38.46243], [-121.47395, 38.46255], [-121.47315, 38.46264], [-121.47235, 38.4627], [-121.47143, 38.46274], [-121.47143, 38.46429], [-121.4643, 38.46431], [-121.46151, 38.46356], [-121.46101, 38.46008], [-121.46083, 38.46009], [-121.46067, 38.45882], [-121.46014, 38.45435], [-121.46031, 38.45435], [-121.46032, 38.45434], [-121.46011, 38.45253], [-121.46413, 38.45261], [-121.4641, 38.45613], [-121.46411, 38.45633], [-121.46845, 38.45635], [-121.46919, 38.45272], [-121.48258, 38.4528], [-121.48262, 38.4513], [-121.48259, 38.44598], [-121.48252, 38.44596], [-121.48224, 38.44051], [-121.48216, 38.4305], [-121.48752, 38.43049], [-121.48757, 38.43081], [-121.48791, 38.43225], [-121.48817, 38.43318], [-121.48917, 38.4378], [-121.48926, 38.43825], [-121.48937, 38.43912], [-121.48969, 38.43942], [-121.48989, 38.44033], [-121.48966, 38.44049], [-121.49012, 38.44225], [-121.49034, 38.44324], [-121.49017, 38.44322], [-121.49016, 38.44323], [-121.49158, 38.44986], [-121.49215, 38.45374], [-121.49229, 38.4543], [-121.49294, 38.45629]], [[-121.47786, 38.45972], [-121.47805, 38.45971], [-121.47776, 38.45842], [-121.47715, 38.45873], [-121.47632, 38.45909], [-121.47548, 38.45943], [-121.47461, 38.45973], [-121.46443, 38.45973], [-121.46441, 38.46016], [-121.46442, 38.46017], [-121.47461, 38.46018], [-121.47488, 38.46014], [-121.47516, 38.46007], [-121.47552, 38.45992], [-121.47596, 38.45972], [-121.47786, 38.45972]], [[-121.48047, 38.45628], [-121.48046, 38.45626], [-121.47733, 38.45634], [-121.47776, 38.45836], [-121.4782, 38.45812], [-121.4792, 38.45741], [-121.48047, 38.45628]]], [[[-121.46051, 38.46182], [-121.46014, 38.46182], [-121.45754, 38.46232], [-121.451, 38.46543], [-121.44687, 38.46343], [-121.44679, 38.46343], [-121.44671, 38.46232], [-121.44678, 38.46228], [-121.44675, 38.46187], [-121.44667, 38.46183], [-121.44656, 38.46034], [-121.44647, 38.45963], [-121.44654, 38.45958], [-121.44634, 38.4585], [-121.44731, 38.45854], [-121.44732, 38.45853], [-121.44716, 38.45731], [-121.44712, 38.45725], [-121.44609, 38.45726], [-121.44533, 38.45341], [-121.44515, 38.45268], [-121.44508, 38.45233], [-121.44497, 38.45132], [-121.44491, 38.45055], [-121.44486, 38.44945], [-121.44483, 38.44862], [-121.44483, 38.44779], [-121.44485, 38.44644], [-121.44484, 38.44534], [-121.44485, 38.44461], [-121.44489, 38.44394], [-121.44501, 38.44291], [-121.44499, 38.4429], [-121.44517, 38.44141], [-121.44555, 38.43957], [-121.44572, 38.43865], [-121.44619, 38.43587], [-121.44688, 38.43587], [-121.44693, 38.43561], [-121.44692, 38.4356], [-121.44624, 38.4356], [-121.44644, 38.43438], [-121.44647, 38.43433], [-121.44652, 38.43432], [-121.44714, 38.43432], [-121.45009, 38.43424], [-121.45691, 38.43426], [-121.45731, 38.43768], [-121.45766, 38.43769], [-121.45852, 38.44496], [-121.4587, 38.44501], [-121.46046, 38.46011], [-121.46029, 38.46013], [-121.46051, 38.46182]]]]} Restricted Access 2 21778 Sacramento Regional County Sanitation District 24767 2130 Sacramento Regional County Sanitation District 583 Special District 4 Sanitation District 18 http://www.srcsd.com/ Special District 4 2130 Sacramento Regional County Sanitation District 575 Special District 4 Sanitation District 19   Sacramento 41 1914.582 Sacramento Reg. County Sanitation District 0 Local Other or Unknown 14 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]);