database spasial dengan postgresql n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
DATABASE SPASIAL DENGAN POSTGRESQL PowerPoint Presentation
Download Presentation
DATABASE SPASIAL DENGAN POSTGRESQL

Loading in 2 Seconds...

play fullscreen
1 / 24

DATABASE SPASIAL DENGAN POSTGRESQL - PowerPoint PPT Presentation


  • 183 Views
  • Uploaded on

DATABASE SPASIAL DENGAN POSTGRESQL. GALIH WASIS WICAKSONO TEKNIK INFORMATIKA UMM. PENGANTAR. PostGIS adalah extensi spasial untuk PostgreSQL PostGIS bertujuan untuk menjadikan OpenGIS menjadi fitur yang mudah dan sederhana bagi SQL dalam database spasial. TUJUAN POSTGIS.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'DATABASE SPASIAL DENGAN POSTGRESQL' - dieter-santana


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
database spasial dengan postgresql

DATABASE SPASIAL DENGAN POSTGRESQL

GALIH WASIS WICAKSONO

TEKNIK INFORMATIKA UMM

pengantar
PENGANTAR
  • PostGISadalahextensispasialuntukPostgreSQL
  • PostGISbertujuanuntukmenjadikanOpenGISmenjadifitur yang mudahdansederhanabagi SQL dalam database spasial.
tujuan postgis
TUJUAN POSTGIS
  • Database spasial yang Open source
    • Database denganfiturspasialsangatmahal ex oracle
  • Memilikibanyakfitur – fitur/fungsispasial
    • Mengembangkanfungsispasialcukupsulit.
    • Mendukungfungsispasialuntukberbagaitujuan.
  • Mendukungorganisasiinformasi, visualisasi, dananalisaspasial.
model data spasial
MODEL DATA SPASIAL
  • Jalandirepresentasikandengangaris
  • kotaksuratdirepresentasikandengantitik.
model data spasial1
MODEL DATA SPASIAL
  • Landusedirepresentasikanpoligon
model data spasial2
MODEL DATA SPASIAL
  • Kombinasi data spasial (point, line, poligon)
penggunaan db spasial
PENGGUNAAN DB SPASIAL
  • Geocodable addresses
  • Customer location
  • Store locations
  • Transportation tracking
  • Statistical/Demographic
  • Cartography
  • Epidemiology
  • Crime patterns
  • Weather Information
  • Land holdings
  • Natural resources
  • City Planning
  • Environmental planning
  • Information Visualization
  • Hazard detection
keuntungan db spasial
KEUNTUNGAN DB SPASIAL
  • Dapatmemperlakukan data spasialdengan model apapundalam database :
  • transactions
  • backups
  • integrity checks
  • less data redundancy
  • fundamental organization and operations handled by the Database
  • multi-user support
  • security/access control
  • locking
keuntungan db spasial1
KEUNTUNGAN DB SPASIAL
  • Mengatasitugas – tugasbesardari db server
  • organisasidan indexing
  • tidakperlu re-implementasibagi operator
  • tidakperlu re-implementasibagifungsi
  • Waktu yang dibutuhkanuntukmengembangkanaplikasi database disisi client lebihmudah
keuntungan db spasial2
KEUNTUNGAN DB SPASIAL
  • Query spasialuntukrelasi
    • distance
    • adjacency
    • containment
  • Query spasialuntuk operator
    • area
    • length
    • intersection
    • union
    • buffer
query operator spasial
QUERY OPERATOR SPASIAL

Original Polygons

Intersection

Union

query operator spasial1
QUERY OPERATOR SPASIAL

Buffered rivers

Original river network

contoh sql
CONTOH SQL
  • Membuat table pubs

create table pubs

name varchar,beer_price float4);

addgeometrycolumn(‘beer_db’,'pubs','location’,2167,'POINT',3);

contoh sql1
CONTOH SQL
  • Insert data

insert into pubs values(

'Garricks Head‘,

4.50,

GeometryFromText(

'POINT(1196131 383324)’,

2167

)

);

contoh sql2
CONTOH SQL

Insert data

perform query
PERFORM QUERY

select name, beer_price, distance(location, GeometryFromText('POINT(1195722 383854)',2167)) from pubs order by beer_price;

name | beer_price | distance

---------------+------------+------------------

Fireside | 4.25 | 1484.10275160491

The Forge | 4.33 | 1533.06561109862

Rumours | 4.46 | 2042.00094093097

Garricks Head | 4.5 | 669.389105609889

Slap Happy | 4.5 | 1882.31910168298

Old Bailys | 4.55 | 1147.20900404641

Black Sheep | 4.66 | 536.859935972633

Big Bad Daves | 4.75 | 907.446543878884

perform query1
PERFORM QUERY

select name, beer_price + 0.001 * distance(location, GeometryFromText('POINT(1195722 383854)',2167)) as net_price from pubs order by price;

name | net_price

---------------+------------------

Garricks Head | 5.16938910560989

Black Sheep | 5.19685978338474

Big Bad Daves | 5.65744654387888

Old Bailys | 5.69720919478127

Fireside | 5.73410275160491

The Forge | 5.86306553480468

Slap Happy | 6.38231910168298

Rumours | 6.50200097907794