Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
OmniSci.jl Geo query
julia> geodf = sql_execute(conn, "select * from omnisci_states")
52×4 DataFrame. Omitted printing of 1 columns
│ Row │ id │ abbr │ name │
│ │ String⍰ │ String⍰ │ String⍰ │
├─────┼─────────┼─────────┼──────────────────────┤
101 │ AL │ Alabama │
202 │ AK │ Alaska │
304 │ AZ │ Arizona │
405 │ AR │ Arkansas │
511 │ DC │ District of Columbia │
612 │ FL │ Florida │
713 │ GA │ Georgia │
815 │ HI │ Hawaii │
4472 │ PR │ Puerto Rico │
4540 │ OK │ Oklahoma │
4641 │ OR │ Oregon │
4742 │ PA │ Pennsylvania │
4844 │ RI │ Rhode Island │
4949 │ UT │ Utah │
5050 │ VT │ Vermont │
5151 │ VA │ Virginia │
5253 │ WA │ Washington │
julia> eltypes(geodf)
4-element Array{Union,1}:
Union{Missing, String}
Union{Missing, String}
Union{Missing, String}
Union{Missing, MultiPolygon}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.