Skip to content

Instantly share code, notes, and snippets.

@randyzwitch
Created July 26, 2019 19:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save randyzwitch/4e10de3ab30ae5b1ecf1a9ccfed6820c to your computer and use it in GitHub Desktop.
Save randyzwitch/4e10de3ab30ae5b1ecf1a9ccfed6820c to your computer and use it in GitHub Desktop.
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⍰ │
├─────┼─────────┼─────────┼──────────────────────┤
│ 1 │ 01 │ AL │ Alabama │
│ 2 │ 02 │ AK │ Alaska │
│ 3 │ 04 │ AZ │ Arizona │
│ 4 │ 05 │ AR │ Arkansas │
│ 5 │ 11 │ DC │ District of Columbia │
│ 6 │ 12 │ FL │ Florida │
│ 7 │ 13 │ GA │ Georgia │
│ 8 │ 15 │ HI │ Hawaii │
│ 44 │ 72 │ PR │ Puerto Rico │
│ 45 │ 40 │ OK │ Oklahoma │
│ 46 │ 41 │ OR │ Oregon │
│ 47 │ 42 │ PA │ Pennsylvania │
│ 48 │ 44 │ RI │ Rhode Island │
│ 49 │ 49 │ UT │ Utah │
│ 50 │ 50 │ VT │ Vermont │
│ 51 │ 51 │ VA │ Virginia │
│ 52 │ 53 │ 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