Skip to content

Instantly share code, notes, and snippets.

@jumpinjackie

jumpinjackie/fixsqlite

Created June 18, 2015 11:20
Show Gist options
  • Save jumpinjackie/29365600dba02cd502c0 to your computer and use it in GitHub Desktop.
Save jumpinjackie/29365600dba02cd502c0 to your computer and use it in GitHub Desktop.
Download ZIP
Fix SQLite data stores with no FDO spatial context
Raw
fixsqlite
-- Put in a default spatial context entry
insert into spatial_ref_sys(srid, sr_name)
values (1, 'Default')
-- Make all geometry columns point to it
update geometry_columns
set srid = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment