units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and UNIT_NAME = "Silver Lake"
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3020 | 3020 | 3019 | {"type": "Polygon", "coordinates": [[[-119.12918, 37.77888], [-119.12889, 37.77916], [-119.12872, 37.77944], [-119.12851, 37.77957], [-119.1283, 37.77961], [-119.12814, 37.77968], [-119.12769, 37.77969], [-119.12762, 37.77965], [-119.12752, 37.77968], [-119.1274, 37.7798], [-119.12735, 37.77996], [-119.12705, 37.78023], [-119.12692, 37.7803], [-119.12673, 37.78035], [-119.12679, 37.78041], [-119.12681, 37.7805], [-119.1267, 37.78064], [-119.12645, 37.78113], [-119.12613, 37.78152], [-119.12571, 37.78189], [-119.12554, 37.78217], [-119.12545, 37.78224], [-119.12537, 37.78227], [-119.12504, 37.78268], [-119.12481, 37.78285], [-119.12472, 37.7829], [-119.12465, 37.7829], [-119.12458, 37.78289], [-119.12452, 37.78284], [-119.12449, 37.78254], [-119.12444, 37.78241], [-119.12441, 37.78191], [-119.12437, 37.78163], [-119.12431, 37.78144], [-119.12427, 37.78109], [-119.12421, 37.78094], [-119.12417, 37.78078], [-119.12401, 37.78038], [-119.12394, 37.78026], [-119.12365, 37.77943], [-119.12343, 37.77889], [-119.12333, 37.77872], [-119.12321, 37.77845], [-119.12301, 37.77811], [-119.12283, 37.77778], [-119.12266, 37.77755], [-119.1226, 37.77741], [-119.12247, 37.77687], [-119.12238, 37.7767], [-119.12227, 37.77657], [-119.12215, 37.77635], [-119.12211, 37.77625], [-119.12211, 37.77612], [-119.12207, 37.77598], [-119.12195, 37.77583], [-119.12186, 37.77567], [-119.12174, 37.77551], [-119.12165, 37.77542], [-119.12163, 37.7753], [-119.12159, 37.77519], [-119.12158, 37.77504], [-119.1216, 37.775], [-119.12165, 37.77498], [-119.12178, 37.77503], [-119.12181, 37.77495], [-119.12183, 37.7748], [-119.12188, 37.77475], [-119.12194, 37.77462], [-119.12184, 37.77454], [-119.1218, 37.77447], [-119.12183, 37.77443], [-119.12189, 37.77441], [-119.12186, 37.77427], [-119.12178, 37.77419], [-119.1218, 37.77411], [-119.12184, 37.77405], [-119.12185, 37.77396], [-119.12183, 37.77384], [-119.12181, 37.77379], [-119.12184, 37.77374], [-119.12205, 37.77369], [-119.12217, 37.77363], [-119.12222, 37.77348], [-119.12225, 37.77344], [-119.12227, 37.77327], [-119.12233, 37.77324], [-119.12257, 37.77322], [-119.12275, 37.77302], [-119.12277, 37.7729], [-119.12275, 37.77282], [-119.12279, 37.77273], [-119.12286, 37.77264], [-119.12298, 37.77255], [-119.12318, 37.77251], [-119.12338, 37.7725], [-119.12368, 37.77252], [-119.12377, 37.77255], [-119.12391, 37.77265], [-119.12402, 37.77284], [-119.12402, 37.77294], [-119.12408, 37.77329], [-119.12412, 37.77336], [-119.12417, 37.77337], [-119.12431, 37.77334], [-119.12443, 37.77319], [-119.12449, 37.77316], [-119.12456, 37.77315], [-119.12465, 37.77318], [-119.12483, 37.7732], [-119.12495, 37.77314], [-119.12496, 37.77302], [-119.12493, 37.7729], [-119.12484, 37.77265], [-119.12486, 37.77244], [-119.12491, 37.77227], [-119.12501, 37.7721], [-119.12502, 37.77202], [-119.12499, 37.77164], [-119.12503, 37.77161], [-119.12512, 37.77171], [-119.12513, 37.77196], [-119.12515, 37.77204], [-119.1252, 37.77211], [-119.12531, 37.77218], [-119.12544, 37.77221], [-119.12546, 37.7722], [-119.12537, 37.77061], [-119.12555, 37.77102], [-119.12569, 37.7714], [-119.1258, 37.77175], [-119.12595, 37.77227], [-119.12604, 37.77252], [-119.12605, 37.77261], [-119.12603, 37.77286], [-119.12611, 37.77312], [-119.12623, 37.77337], [-119.12641, 37.7736], [-119.12662, 37.77382], [-119.12698, 37.77435], [-119.12664, 37.77446], [-119.12663, 37.77448], [-119.12676, 37.77471], [-119.12696, 37.77489], [-119.12726, 37.77511], [-119.12752, 37.77555], [-119.12784, 37.77583], [-119.12805, 37.77614], [-119.12843, 37.77657], [-119.12914, 37.77845], [-119.12918, 37.77888]]]} | Open Access 1 | 20776 | Silver Lake | 25487 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Mono 32 | 107.687 | Silver Lake | 0 | None 247 | ||
11894 | 11894 | 11893 | {"type": "Polygon", "coordinates": [[[-120.12824, 38.64367], [-120.12745, 38.64502], [-120.12745, 38.64534], [-120.12754, 38.64544], [-120.12754, 38.64592], [-120.12698, 38.64679], [-120.12687, 38.64752], [-120.12602, 38.64905], [-120.12536, 38.64986], [-120.12533, 38.65022], [-120.12477, 38.65066], [-120.12428, 38.65143], [-120.12428, 38.65184], [-120.1244, 38.652], [-120.12469, 38.65274], [-120.12469, 38.65299], [-120.12431, 38.65329], [-120.12408, 38.65434], [-120.12408, 38.65528], [-120.12378, 38.65628], [-120.12355, 38.6566], [-120.12346, 38.65717], [-120.1232, 38.658], [-120.12283, 38.65868], [-120.12326, 38.65908], [-120.1232, 38.65942], [-120.12256, 38.65988], [-120.12233, 38.66033], [-120.12224, 38.66088], [-120.1223, 38.66154], [-120.12277, 38.662], [-120.12312, 38.66212], [-120.12376, 38.6622], [-120.12411, 38.66248], [-120.12513, 38.66278], [-120.12522, 38.66294], [-120.12467, 38.66328], [-120.12353, 38.66442], [-120.12347, 38.66461], [-120.12268, 38.66502], [-120.12184, 38.66626], [-120.12134, 38.66635], [-120.12123, 38.66683], [-120.12169, 38.6671], [-120.12166, 38.66751], [-120.12152, 38.66815], [-120.12073, 38.66866], [-120.11986, 38.6688], [-120.11983, 38.66866], [-120.12044, 38.66824], [-120.12046, 38.66806], [-120.12006, 38.668], [-120.11901, 38.66841], [-120.11857, 38.66877], [-120.11816, 38.66898], [-120.1179, 38.66898], [-120.11746, 38.66875], [-120.11685, 38.66854], [-120.11636, 38.66854], [-120.11617, 38.66864], [-120.11608, 38.66863], [-120.11572, 38.66887], [-120.11496, 38.66925], [-120.11473, 38.66954], [-120.11466, 38.66958], [-120.11437, 38.66997], [-120.11388, 38.67037], [-120.11329, 38.67047], [-120.11325, 38.67044], [-120.1131, 38.66996], [-120.11305, 38.66991], [-120.11335, 38.66935], [-120.11335, 38.66914], [-120.11262, 38.66884], [-120.11213, 38.66853], [-120.11183, 38.668], [-120.11168, 38.66783], [-120.1116, 38.66732], [-120.11127, 38.66715], [-120.11122, 38.66699], [-120.11045, 38.66634], [-120.11029, 38.66607], [-120.11018, 38.66606], [-120.11008, 38.66589], [-120.10967, 38.66576], [-120.10938, 38.66546], [-120.10909, 38.66489], [-120.10908, 38.66444], [-120.10921, 38.6641], [-120.11021, 38.66299], [-120.11085, 38.66285], [-120.11112, 38.66235], [-120.1115, 38.66192], [-120.11177, 38.66178], [-120.11174, 38.66147], [-120.11229, 38.66129], [-120.11209, 38.66013], [-120.11165, 38.65937], [-120.11162, 38.65915], [-120.11186, 38.6589], [-120.112, 38.65775], [-120.11226, 38.65736], [-120.11334, 38.65725], [-120.11372, 38.65745], [-120.11425, 38.65711], [-120.11471, 38.65697], [-120.11541, 38.65702], [-120.11591, 38.65674], [-120.11617, 38.6564], [-120.11635, 38.65462], [-120.11675, 38.65326], [-120.11678, 38.65221], [-120.11766, 38.65082], [-120.11824, 38.65036], [-120.11876, 38.64968], [-120.11961, 38.64919], [-120.12005, 38.64878], [-120.12034, 38.64833], [-120.12127, 38.64762], [-120.12171, 38.64679], [-120.12255, 38.64601], [-120.12319, 38.64583], [-120.1234, 38.64512], [-120.12366, 38.64473], [-120.12378, 38.64416], [-120.12372, 38.64251], [-120.12404, 38.64203], [-120.12433, 38.64205], [-120.12497, 38.64185], [-120.1257, 38.6418], [-120.12603, 38.64187], [-120.12716, 38.64223], [-120.12763, 38.64262], [-120.12809, 38.64322], [-120.12824, 38.64367]], [[-120.12168, 38.64997], [-120.12142, 38.6499], [-120.12023, 38.64997], [-120.11996, 38.6502], [-120.11958, 38.65141], [-120.11947, 38.65212], [-120.11944, 38.65342], [-120.11958, 38.65409], [-120.12005, 38.65514], [-120.12069, 38.6556], [-120.12104, 38.65569], [-120.12148, 38.6556], [-120.12189, 38.6551], [-120.12203, 38.65475], [-120.1223, 38.65436], [-120.1225, 38.65292], [-120.12291, 38.65148], [-120.1227, 38.65077], [-120.12215, 38.65022], [-120.12168, 38.64997]]]} | Open Access 1 | 24343 | Silver Lake | 3403 | 2220 | El Dorado Irrigation District 890 | Special District 4 | Irrigation District 17 | http://www.eid.org/ | Special District 4 | 2220 | El Dorado Irrigation District 965 | Special District 4 | Irrigation District 16 | Amador 52 | 514.385 | Silver Lake | None 1047 |
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]);