ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Load the SQLite ST_Geometry library

Before executing SQL commands that contain ST_Geometry functions against an SQLite database, do the following:

  • Install an SQL editor (such as SQLite3.exe) on the same machine where you have an ArcGIS client installed.
  • On the same machine, set the PATH (Windows) or LIBPATH (Linux) system environment variable to the ArcGIS client bin directory.
  • Load the ST_Geometry library so the SQL editor can access the ST_Geometry functions.

  1. Log in to a machine where an ArcGIS client, such as ArcGIS Desktop or ArcGIS Server is installed.
  2. Add the path to the bin directory of your ArcGIS client to the machine's PATH (Windows) or LIBPATH (Linux) variable.

    For example, if you installed ArcGIS Desktop in the default location, set the PATH variable to C:\Program Files (x86)\ArcGIS\Desktop<release number>\bin.

  3. Open the SQL editor and connect to your SQLite database.
  4. Load the ST_Geometry library.

    These examples load the ST_Geometry library. The first one loads it on a Windows machine where ArcGIS Desktop is installed. The second loads the library on a Linux machine where ArcGIS Server is installed.

    --Load the ST_Geometry library on Windows.
    SELECT load_extension(
     'c:\Program Files (x86)\ArcGIS\Desktop10.3\DatabaseSupport\SQLite\Windows32\stgeometry_sqlite.dll',
     'SDE_SQL_funcs_init'
    );
    
    --Load the ST_Geometry library on Linux.
    SELECT load_extension(
     '/arcgis/server/usr/DatabaseSupport/SQLite/Linux64/libstgeometry_sqlite.so',
     'SDE_SQL_funcs_init'
    );
    

You can now execute SQL commands that contain ST_Geometry functions.

Related topics

  • Spatially enable an SQLite database

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2020 Esri. | Privacy | Legal