All Projects → appelmar → Scidb4geo

appelmar / Scidb4geo

Licence: other
A SciDB Plugin for Managing Spatial and Temporal Reference Information of Arrays

Labels

Projects that are alternatives of or similar to Scidb4geo

Vector Datasource
Tilezen vector tile service - OpenStreetMap data in several formats
Stars: ✭ 427 (+5237.5%)
Mutual labels:  plpgsql
Mysql Sys
The MySQL sys schema
Stars: ✭ 758 (+9375%)
Mutual labels:  plpgsql
Geocode
Batch geocoding addressess, map to census block with PostGIS Tiger Geocoder
Stars: ✭ 23 (+187.5%)
Mutual labels:  plpgsql
Audit Trigger
Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
Stars: ✭ 493 (+6062.5%)
Mutual labels:  plpgsql
Blog
Everything about database,business.(Most for PostgreSQL).
Stars: ✭ 6,330 (+79025%)
Mutual labels:  plpgsql
Chinook Database
Sample database for SQL Server, Oracle, MySQL, PostgreSQL, SQLite, DB2
Stars: ✭ 786 (+9725%)
Mutual labels:  plpgsql
Practical Sql
Code and Data for the book "Practical SQL" by Anthony DeBarros, published by No Starch Press (2018).
Stars: ✭ 392 (+4800%)
Mutual labels:  plpgsql
Foodnutrition
食物营养大数据
Stars: ✭ 27 (+237.5%)
Mutual labels:  plpgsql
Demo
“Happy Lager” Craft CMS demo site.
Stars: ✭ 730 (+9025%)
Mutual labels:  plpgsql
Pg query internals
Query PostgreSQL internals using SQL
Stars: ✭ 17 (+112.5%)
Mutual labels:  plpgsql
Node Sqlite3
Asynchronous, non-blocking SQLite3 bindings for Node.js
Stars: ✭ 5,083 (+63437.5%)
Mutual labels:  plpgsql
Postgrest Starter Kit
Starter Kit and tooling for authoring REST API backends with PostgREST
Stars: ✭ 657 (+8112.5%)
Mutual labels:  plpgsql
Odata V4 Typeorm
OData to TYPEORM query compiler
Stars: ✭ 16 (+100%)
Mutual labels:  plpgsql
Mixerp
Open Source ERP, HRM, MRP, MPS
Stars: ✭ 472 (+5800%)
Mutual labels:  plpgsql
Postgis
PostGIS spatial database extension to PostgreSQL [mirror]
Stars: ✭ 925 (+11462.5%)
Mutual labels:  plpgsql
Pg Shortkey
YouTube-like Short IDs as Postgres Primary Keys
Stars: ✭ 402 (+4925%)
Mutual labels:  plpgsql
Mysql Deadlocks
收集一些常见的 MySQL 死锁案例
Stars: ✭ 777 (+9612.5%)
Mutual labels:  plpgsql
Elite
Stars: ✭ 7 (-12.5%)
Mutual labels:  plpgsql
Mallcloud Platform
mallcloud商城基于SpringBoot2.x、SpringCloud和SpringCloudAlibaba并采用前后端分离vue的企业级微服务敏捷开发系统架构。并引入组件化的思想实现高内聚低耦合,项目代码简洁注释丰富上手容易,适合学习和企业中使用。真正实现了基于RBAC、jwt和oauth2的无状态统一权限认证的解决方案,面向互联网设计同时适合B端和C端用户,支持CI/CD多环境部署,并提供应用管理方便第三方系统接入;同时还集合各种微服务治理功能和监控功能。模块包括:企业级的认证系统、开发平台、应用监控、慢sql监控、统一日志、单点登录、Redis分布式高速缓存、配置中心、分布式任务调度、接口文档、代码生成等等
Stars: ✭ 27 (+237.5%)
Mutual labels:  plpgsql
Pg Mask
Simple data masking for PostgreSQL
Stars: ✭ 16 (+100%)
Mutual labels:  plpgsql

scidb4geo

A SciDB plugin for managing spacetime earth-observation arrays.

Description

scidb4geo is a plugin for managing spatial and temporal reference information of SciDB arrays. It defines a couple of additional operators and adds actual reference information to SciDB's system catalog. It can be used within AFL or AQL.

Getting Started

The following sequence of SciDB queries demonstrate how the plugin can be used to store spatiotemporal reference of arrays. These are the most basic operations though there are more complex operators that will be demonstrated in a case study in the near future.

  1. Create a random spatiotemporal array covering the whole world
set no fetch; # do not print results of store
store(build(<val:double>[lat=0:179,256,0,lon=0:359,256,0,t=0:364,32,0],double(random(),world); 
eo_setsrs(world,'lon','lat','EPSG',4326,'x0=-180 y0=90 a11=1 a22=-1');
eo_settrs(world,'t','2001-01-01', 'P1D');
set fetch; # we do want to see output of the following queries.
  1. Get spatial / temporal reference information
eo_getsrs(world); 
eo_gettrs(world);
eo_extent(world);

rename(world,earth); # renaming does not change spatial reference

eo_getsrs(earth); 
eo_gettrs(earth);
eo_extent(earth);
  1. Clean up
remove(earth);

Operators

The table below lists novel AFL operators. Detailed descriptions of arguments, return values, and examples can be found in the gh-pages branch at http://appelmar.github.io/scidb4geo/operators.

Operator Description
eo_arrays() Lists geographically referenced arrays
eo_setsrs() Sets the spatial reference of existing arrays
eo_getsrs() Gets the spatial reference of existing arrays
eo_regnewsrs() Registers custom spatial reference systems
eo_extent() Computes the geographic extent of referenced arrays
eo_cpsrs() Copies the spatial reference from one array to another array
eo_settrs() Sets the temporal reference of arrays
eo_gettrs() Gets the temporal reference of arrays
eo_setmd() Sets key value metadata of arrays and array attributes
eo_getmd() Gets key value metadata of arrays and array attributes
eo_over() Overlays two geographically referenced arrays

Build and Installation

The following instructions refer to using SciDB version 15.7 on Ubuntu 14.04. You will need the SciDB development packages which you normally have automatically installed if you built SciDB from sources. Furthermore, the plugin requires libcurl.

  1. Clone this repository git clone https://github.com/appelmar/scidb4geo.
  2. Compile by running make in the base directory. If SciDB libraries and headers are installed at a nonstandard location, you may use make SCIDB=/path/to/scidb.
  3. Use the install/setup.sh script to extend SciDB's system catalog by running cd install && chmod +x setup.sh && ./setup.sh as the root user or with sudo rights.
  4. Copy libscidb4geo.so to the plugins directory of SciDB on all instances, i.e. cp libscidb4geo.so /opt/scidb/15.7/lib/scidb/plugins/ for a default local SciDB installation.
  5. Now, you should be able to load the plugin using AFL% load_library('scidb4geo');
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].