It is similar to\u00a0<\/span>PostGIS<\/a>,\u00a0<\/span>Oracle Spatial<\/a>, and Microsoft\u00a0<\/span>SQL Server<\/a>\u00a0with spatial extensions, although\u00a0<\/span>SQLite<\/a>\/SpatiaLite aren’t based on client-server architecture: they adopt a simpler personal architecture. i.e. the whole SQL engine is directly embedded within the application itself: a complete database simply is an ordinary file which can be freely copied (or even deleted) and transferred from one computer\/OS to a different one without any special precaution.<\/span><\/p>\n [\/et_pb_text][et_pb_slider admin_label=”Slider” show_arrows=”on” show_pagination=”on” auto=”on” parallax=”off” auto_speed=”4000″][et_pb_slide heading=”SpatiaLite Walkthrough” button_text=”Video 1″ button_link=”https:\/\/www.youtube.com\/user\/TheDmarkell” background_color=”#ffffff” alignment=”center” video_url=”https:\/\/www.youtube.com\/watch?v=hXp1aMLDlAM” background_layout=”light”]<\/p>\n Walkthrough review of the SpatiaLite and QGis applications following Lee Hachadoorian’s presentation to NYC Open Data Meetup group.<\/p>\n [\/et_pb_slide][et_pb_slide heading=”SpatiaLite Walkthrough 2″ button_text=”Video 2″ button_link=”https:\/\/www.youtube.com\/user\/TheDmarkell” background_color=”#ffffff” alignment=”center” video_url=”https:\/\/www.youtube.com\/watch?v=_q30PFyeC_s” background_layout=”light”]<\/p>\n shows some analysis and visualization.<\/p>\n [\/et_pb_slide][et_pb_slide heading=”Read and write a SpatiaLite database” button_text=”Video” button_link=”http:\/\/www.youtube.com\/watch?v=WF6JvU0077k” background_color=”#ffffff” alignment=”center” video_url=”http:\/\/www.youtube.com\/watch?v=WF6JvU0077k” background_layout=”light”]<\/p>\n Read and write spatial data to a SQLite database using FME’s SpatiaLite Reader \/ Writer. Achieve support for spatial features and multiple coordinate systems inside a small, local relational database engine.<\/p>\n Dataset obtained from City of Vancouver –http:\/\/data.vancouver.ca\/datacatalogu…<\/a><\/p>\n [\/et_pb_slide][\/et_pb_slider][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”1_2″][et_pb_blurb admin_label=”spatialite-gui” title=”spatialite-gui” url=”https:\/\/www.gaia-gis.it\/fossil\/spatialite_gui\/index” url_new_window=”on” image=”http:\/\/www.gaia-gis.it\/gaia-sins\/fossil-gui-sample.png” animation=”top” background_layout=”light” text_orientation=”left”]<\/p>\n spatialite-gui is an\u00a0<\/span>open source<\/i><\/i><\/b>\u00a0<\/span>G<\/b><\/span>raphical\u00a0<\/span>U<\/b><\/span>ser\u00a0<\/span>I<\/b><\/span>nterface (<\/span>GUI<\/b>) tool supporting SpatiaLite<\/span><\/p>\n It’s a tool to build a database, create tables, convert Shapefiles and other data into SpatiaLite Tables<\/p>\n Please check website for latest version and other information<\/p>\n Sources<\/b>: current version is\u00a0<\/span>1.7.1<\/b>\u00a0(<\/span>released on 2013-06-29)<\/i><\/p>\n [\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_2″][et_pb_text admin_label=”Learn More and Strenghts” background_layout=”light” text_orientation=”left”]<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Manual” title=”SpatiaLite Manual” url=”http:\/\/www.gaia-gis.it\/gaia-sins\/spatialite-manual-2.3.1.html” url_new_window=”on” image=”http:\/\/www.gaia-gis.it\/gaia-sins\/spatialite-logo.png” animation=”top” background_layout=”light” text_orientation=”left”]<\/p>\n http:\/\/www.gaia-gis.it\/gaia-sins\/spatialite-manual-2.3.1.html<\/a><\/p>\n 1. An introduction to SpatiaLite <\/a><\/p>\n 2. The OpenGIS geometry model<\/a><\/p>\n 3. Supported spatial data formats <\/a><\/p>\n 4. Coordinate Reference Systems; the EPSG dataset<\/a><\/p>\n 5. Spatial Metadata support <\/a><\/p>\n 6. The VirtualShape module <\/a><\/p>\n 7. The VirtualText module <\/a><\/p>\n 8. Spatial Indexing support<\/a><\/p>\n 9. MBR Caching support <\/a><\/p>\n 10. SpatiaLite conformance and compatibility<\/a><\/div>\n\t\t\t\t<\/div>\n [\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″][et_pb_blurb admin_label=”QUICK START” url_new_window=”off” animation=”top” background_layout=”light” text_orientation=”center” \/][\/et_pb_column][et_pb_column type=”1_3″][et_pb_blurb admin_label=”Other” url_new_window=”off” animation=”top” background_layout=”light” text_orientation=”center” \/][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”1_3″][et_pb_blurb admin_label=”SQL Reference Functions” title=”SQL Reference Functions” url_new_window=”on” animation=”top” background_layout=”light” text_orientation=”left” url=”http:\/\/www.gaia-gis.it\/gaia-sins\/spatialite-sql-4.1.0.html” image=”http:\/\/adventurer.org.nz\/img\/qgist_spatialite-gui_successfulSQL.png”]Spatial SQL functions<\/b>\u00a0<\/span>reference guide<\/a><\/p>\n back<\/a><\/p>\n [\/et_pb_blurb][\/et_pb_column][et_pb_column type=”1_3″][et_pb_blurb admin_label=”SpatiaLite Tools” title=”SpatiaLite Tools” url=”https:\/\/www.gaia-gis.it\/fossil\/spatialite-tools\/index” url_new_window=”on” image=”https:\/\/www.gaia-gis.it\/fossil\/spatialite-tools\/logo” animation=”top” background_layout=”light” text_orientation=”left”] spatialite-tools are licensed under the GPL v3<\/a> (or any subsequent version) terms<\/p>\n![\"Devin](\"https:\/\/yt3.ggpht.com\/-sPaFLtK0EKQ\/AAAAAAAAAAI\/AAAAAAAAAAA\/PBsFSEFuB-4\/s48-c-k-no\/photo.jpg\")
\u00a0<\/span><\/span><\/span><\/a>Devin Markell<\/a><\/p>\n\n
About<\/span><\/span><\/h3>\n\t\t\t\t\t
Strengths of SpatiaLite<\/span><\/span><\/h3>\n\t\t\t\t\t
Table of Contents of Manual<\/span><\/span><\/h3>\n\t\t\t\t\t
SQL Reference<\/span><\/span><\/h3>\n\t\t\t\t\t
SpatiaLite 4.1.0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0SQL functions reference list<\/h2>\n
\n
\n
\n
Tools<\/span><\/span><\/h3>\n\t\t\t\t\t
\n