units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 583 and DES_TP = 14
This data as json, copyable, CSV (advanced)
| 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
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]);