PostgreSQL-DeepGeo

WARNING : This project is under development. If you want to try a project, you can use it in old verison.

• Easy Deep Learning for PostgreSQL
• Copyright (c) 2019 InfoLab (Donggun LEE)

Temporary Table

• This project supports temporary tables by default.
• Below are statistics based on the availability of temporary tables.
• The results may not be real.

How to install

STEP 1 PostgreSQL 11 with pl/python3u, pl/java 1.5.1, PostGIS 2.5

• Install Guide
• Etc
  • PostgreSQL 11
  • PostGIS
  • pl/python
  • pl/java

STEP 2 python3.6

• Download

STEP 3 DeepGeo

• Install

  pip install deepgeo==0.0.1  /* https://github.com/Sotaneum/DeepGeo */

• Support Library
  • Mask R-CNN
• Supported Upcoming Library
  • Caffe2
  • YOLO

STEP 4 DeepGeo-For-PostgreSQL

• Install Engine

  • Red Hat family Linux (including CentOS/Fedora/Scientific/Oracle variants)

    yum install postgresql-deepgeo //This method will soon be supported.

  • Ubuntu Linux and derivatives

    apt-get install postgresql-deepgeo //This method will soon be supported.

  • Other Linux

• Copy & Paste

  • EXTENSION

  CREATE EXTENSION deepgeo; /* This method will soon be supported. */

  • SELF

How to use

• Function List

  name	input	output
  M_deepCount	model_name:text, category:text, uri:text	count:int
  M_deepFind	model_name:text, categories:text, uri:text	result:json

• Example

  /* Find a picture of a car. */
  SELECT idx, picture_uri
  FROM pictures
  WHERE M_deepCount('mscoco', 'car', picture_uri) > 0;
  
  /* Finding a picture with a car and a person together. */
  SELECT idx, picture_uri
  FROM pictures
  WHERE M_deepCount('mscoco', 'car', picture_uri) > 0 and M_deepCount('mscoco', 'person', picture_uri) > 0;
  
  /* Looking for pictures with no people and only cars. */
  SELECT idx, picture_uri
  FROM pictures
  WHERE M_deepCount('mscoco', 'car', picture_uri) > 0 and M_deepCount('mscoco', 'person', picture_uri) = 0;
  
  /* Find a picture of two to four cars. */
  SELECT idx, picture_uri
  FROM pictures
  WHERE M_deepCount('mscoco', 'car', picture_uri) between 2 to 4;