units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 104 and SUID_NMA = 30558
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4772 | 4772 | 4771 | {"type": "MultiPolygon", "coordinates": [[[[-123.78953, 40.0753], [-123.7895, 40.07556], [-123.78937, 40.07563], [-123.78923, 40.07562], [-123.78895, 40.07539], [-123.78896, 40.07522], [-123.78889, 40.07509], [-123.78898, 40.0749], [-123.78947, 40.07503], [-123.78953, 40.0753]]], [[[-123.80311, 40.92168], [-123.80295, 40.92183], [-123.80259, 40.92175], [-123.80217, 40.92158], [-123.80189, 40.92163], [-123.80154, 40.92173], [-123.80135, 40.92181], [-123.80095, 40.92202], [-123.80048, 40.92219], [-123.79993, 40.92252], [-123.79977, 40.92257], [-123.79706, 40.92221], [-123.79506, 40.92144], [-123.79484, 40.91961], [-123.79532, 40.91907], [-123.79581, 40.91872], [-123.7969, 40.9187], [-123.7967, 40.91955], [-123.79647, 40.91965], [-123.7963, 40.91983], [-123.79616, 40.92023], [-123.79619, 40.92066], [-123.79623, 40.92097], [-123.79652, 40.92115], [-123.79731, 40.92106], [-123.79784, 40.92114], [-123.79858, 40.92122], [-123.80017, 40.92128], [-123.80216, 40.92123], [-123.80242, 40.92129], [-123.80298, 40.92146], [-123.80311, 40.92168]]], [[[-124.15195, 40.80245], [-124.15185, 40.80277], [-124.15156, 40.80277], [-124.15145, 40.80283], [-124.15145, 40.80296], [-124.15115, 40.80296], [-124.15115, 40.80236], [-124.15119, 40.80236], [-124.15157, 40.80212], [-124.15195, 40.80245]]], [[[-124.15907, 40.55577], [-124.15904, 40.5631], [-124.15159, 40.56302], [-124.15233, 40.56174], [-124.15358, 40.55931], [-124.15391, 40.55636], [-124.15462, 40.55636], [-124.15467, 40.55574], [-124.15907, 40.55577]], [[-124.15418, 40.562], [-124.15424, 40.56175], [-124.1541, 40.56175], [-124.15409, 40.56199], [-124.15418, 40.562]]]]} | Open Access 1 | 46933 | Unnamed site - California Department of Transportation | 30558 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | Humboldt 45 | 124.116 | 0 | State Other or Unknown 104 | 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]);