PostGIS Cookbook. For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts
- Autorzy:
- Paolo Corti, Stephen Vincent Mather, Thomas Kraft, Bborie Park
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 484
- Dostępne formaty:
-
PDFePubMobi
Opis ebooka: PostGIS Cookbook. For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts
Wybrane bestsellery
-
PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. If you want to explore the complete range of PostGIS techniques and expose the related extensions, then this book is for you.
PostGIS Cookbook. Store, organize, manipulate, and analyze spatial data - Second Edition PostGIS Cookbook. Store, organize, manipulate, and analyze spatial data - Second Edition
Pedro Wightman, Bborie Park, Stephen Vincent Mather, Thomas Kraft, Mayra Zurbarán
-
Język SQL w świecie IT jest niczym tabliczka mnożenia dla ucznia. Stanowi absolutną podstawę w pracy zarówno analityków, jak i programistów, a jego opanowanie jest konieczne do efektywnej pracy z danymi. By w pełni skorzystać z możliwości tego języka zapytań, należy jeszcze wybrać odpowiedni syst...
Analiza danych w PostgreSQL. Kurs video. Relacyjne bazy danych w pigułce Analiza danych w PostgreSQL. Kurs video. Relacyjne bazy danych w pigułce
(39.90 zł najniższa cena z 30 dni)92.95 zł
169.00 zł(-45%) -
PostgreSQL is a powerful open-source database management system, now recognized as the expert choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL 14 solution.
PostgreSQL 14 Administration Cookbook. Over 175 proven recipes for database administrators to manage enterprise databases effectively PostgreSQL 14 Administration Cookbook. Over 175 proven recipes for database administrators to manage enterprise databases effectively
-
Jeśli planujesz karierę administratora systemów IT, temat zarządzania bazami danych powinien - a nawet więcej: musi - być Ci bliski. Bazami danych można zarządzać na rozmaite sposoby, jednym z nich jest model relacyjny. Jeśli masz lub będziesz mieć do czynienia z tego typu bazą danych, prędzej cz...
PostgreSQL. Kurs video. Zostań administratorem systemów IT PostgreSQL. Kurs video. Zostań administratorem systemów IT
(39.90 zł najniższa cena z 30 dni)54.45 zł
99.00 zł(-45%) -
This book is divided into two parts with the first helping you to build advanced and scalable PostgreSQL apps. The second part enables you to administer them using DevOps. All the projects in this book will be demonstrated via the use of a small banking application for managing ATM machine locati...
Developing Modern Database Applications with PostgreSQL. Use the highly available and object-relational PostgreSQL to build scalable and reliable apps Developing Modern Database Applications with PostgreSQL. Use the highly available and object-relational PostgreSQL to build scalable and reliable apps
-
PostgreSQL has become the most advanced open source database on the market. This book adopts a step-by-step approach to meet almost every requirement you can think of while deploying PostgreSQL in production environments. You will not only learn how to design and manage your database but also dis...
PostgreSQL 13 Cookbook. Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions PostgreSQL 13 Cookbook. Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions
-
Updated to include the new features introduced in PostgreSQL 13, this book shows you how to build better PostgreSQL applications and administer your PostgreSQL database efficiently. You’ll master the advanced features of PostgreSQL and develop the skills you need to build secure and highly...
Mastering PostgreSQL 13. Build, administer, and maintain database applications efficiently with PostgreSQL 13 - Fourth Edition Mastering PostgreSQL 13. Build, administer, and maintain database applications efficiently with PostgreSQL 13 - Fourth Edition
-
This book will get you up and running with the working of relational databases, data modeling, data manipulation, and more. You will learn to build efficient relational database solutions from scratch using the latest features of PostgreSQL 12 and 13. You’ll also be able to identify bottle...
Learn PostgreSQL. Build and manage high-performance database solutions using PostgreSQL 12 and 13 Learn PostgreSQL. Build and manage high-performance database solutions using PostgreSQL 12 and 13
-
Oto przystępny przewodnik, dzięki któremu nauczysz się krok po kroku pisać zapytania SQL. Poznasz też narzędzia, które umożliwiają zrozumienie, edytowanie i tworzenie zapytań SQL. Nową wiedzę utrwalisz poprzez analizę setek szczegółowo wyjaśnionych przykładów. Niepostrzeżenie zaczniesz rozwiązywa...(39.90 zł najniższa cena z 30 dni)
64.50 zł
129.00 zł(-50%) -
Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monitor and a...
PostgreSQL 12 High Availability Cookbook. Over 100 recipes to design a highly available server with the advanced features of PostgreSQL 12 - Third Edition PostgreSQL 12 High Availability Cookbook. Over 100 recipes to design a highly available server with the advanced features of PostgreSQL 12 - Third Edition
O autorach ebooka
Ebooka "PostGIS Cookbook. For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "PostGIS Cookbook. For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "PostGIS Cookbook. For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- Tytuł oryginału:
- PostGIS Cookbook. For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts
- ISBN Ebooka:
- 978-18-495-1867-3, 9781849518673
- Data wydania ebooka:
- 2014-01-24 Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku Pdf:
- 16.3MB
- Rozmiar pliku ePub:
- 24.5MB
- Rozmiar pliku Mobi:
- 52.4MB
Spis treści ebooka
- PostGIS Cookbook
- Table of Contents
- PostGIS Cookbook
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers and more
- Why Subscribe?
- Free Access for Packt account holders
- Support files, eBooks, discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- 1. Moving Data In and Out of PostGIS
- Introduction
- Importing nonspatial tabular data (CSV) using PostGIS functions
- Getting ready
- How to do it...
- How it works...
- Importing nonspatial tabular data (CSV) using GDAL
- Getting ready
- How to do it...
- How it works...
- Importing shapefiles with shp2pgsql
- How to do it...
- How it works...
- Theres more...
- Importing and exporting data with the ogr2ogr GDAL command
- How to do it...
- How it works...
- See also
- Handling batch importing and exporting of datasets
- Getting ready
- How to do it...
- How it works...
- Exporting data to the shapefile with the pgsql2shp PostGIS command
- How to do it...
- How it works...
- Importing OpenStreetMap data with the osm2pgsql command
- Getting ready
- How to do it...
- How it works...
- Importing raster data with the raster2pgsql PostGIS command
- Getting ready
- How to do it...
- How it works...
- Importing multiple rasters at a time
- Getting ready
- How to do it...
- How it works...
- Exporting rasters with the gdal_translate and gdalwarp GDAL commands
- Getting ready
- How to do it...
- How it works...
- See also
- 2. Structures that Work
- Introduction
- Using geospatial views
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using triggers to populate a geometry column
- Getting ready
- How to do it...
- There's more...
- Extending further...
- See also
- Structuring spatial data with table inheritance
- Getting ready
- How to do it...
- How it works...
- See also
- Extending inheritance table partitioning
- Getting ready
- How to do it...
- How it works...
- See also
- Normalizing imports
- Getting ready
- How to do it...
- How it works...
- There's more...
- Normalizing internal overlays
- Getting ready
- How to do it...
- Converting polygons to linestrings
- Converting linestrings back to polygons
- Finding center points of resultant polygons
- Using resultant points to query tabular relationships
- How it works...
- There's more...
- Using polygon overlays for proportional census estimates
- Getting ready
- How to do it...
- How it works...
- 3. Working with Vector Data The Basics
- Introduction
- Working with GPS data
- Getting ready
- How to do it...
- How it works...
- Fixing invalid geometries
- Getting ready
- How to do it...
- How it works...
- GIS analysis with spatial joins
- Getting ready
- How to do it...
- How it works...
- Simplifying geometries
- How to do it...
- How it works...
- Measuring distances
- Getting ready
- How to do it...
- How it works...
- Merging polygons using a common attribute
- Getting ready
- How to do it...
- How it works...
- Computing intersections
- Getting ready
- How to do it...
- How it works...
- Clipping geometries to deploy data
- Getting ready
- How to do it...
- How it works...
- Simplifying geometries with PostGIS topology
- Getting ready
- How to do it...
- How it works...
- 4. Working with Vector Data Advanced Recipes
- Introduction
- Improving proximity filtering with KNN
- Getting ready
- How to do it...
- How it works...
- See also
- Improving proximity filtering with KNN advanced
- Getting ready
- How to do it...
- How it works...
- See also
- Rotating geometries
- Getting ready
- How to do it...
- How it works...
- See also
- Improving ST_Polygonize
- Getting ready
- How to do it...
- See also
- Translating, scaling, and rotating geometries advanced
- Getting ready
- How to do it...
- How it works...
- See also
- Generating detailed building footprints from LiDAR
- Getting ready
- How to do it...
- How it works...
- Using external scripts to embed new functionality in order to calculate a Voronoi diagram
- Getting ready
- How to do it...
- See also
- Using external scripts to embed other libraries in order to calculate a Voronoi diagram advanced
- Getting ready
- How to do it...
- There's more...
- Step zero preparing the test table
- Step one preparing the input text
- Step two returning results
- Step three bundling as a function
- Step four translating into geometry
- 5. Working with Raster Data
- Introduction
- Getting and loading rasters
- Getting ready
- How to do it...
- How it works...
- Working with basic raster information and analysis
- Getting ready
- How to do it...
- How it works...
- Performing simple map-algebra operations
- Getting ready
- How to do it...
- How it works...
- Combining geometries with rasters for analysis
- Getting ready
- How to do it...
- How it works...
- Converting between rasters and geometries
- Getting ready
- How to do it...
- How it works...
- Processing and loading rasters with GDAL VRT
- Getting ready
- How to do it...
- How it works...
- Warping and resampling rasters
- Getting ready
- How to do it...
- How it works...
- Performing advanced map-algebra operations
- Getting ready
- How to do it...
- How it works...
- Executing DEM operations
- Getting ready
- How to do it...
- How it works...
- Sharing and visualizing rasters through SQL
- Getting ready
- How to do it...
- How it works...
- 6. Working with pgRouting
- Introduction
- Startup Dijkstra routing
- Getting ready
- How to do it...
- Loading data from OpenStreetMap and finding the shortest path using A*
- Getting ready
- How to do it...
- How it works...
- Driving distance/service area calculation
- Getting ready
- How to do it...
- See also
- Calculating demographics using driving distance
- Getting ready
- How to do it...
- Extracting the centerlines of polygons
- Getting ready
- How to do it...
- There's more...
- 7. Into the Nth Dimension
- Introduction
- Importing LiDAR data
- Getting ready
- How to do it...
- See also
- Performing 3D queries on a LiDAR point cloud
- How to do it...
- Constructing and serving buildings 2.5 D
- Getting ready
- How to do it...
- Using ST_Extrude to extrude building footprints
- Creating arbitrary 3D objects for PostGIS
- Getting ready
- How to do it...
- Exporting models as X3D for the Web
- Getting ready
- How to do it...
- There's more...
- Reconstructing Unmanned Aerial Vehicle (UAV) image footprints with PostGIS 3D
- Getting ready
- How to do it...
- UAV photogrammetry in PostGIS point cloud
- Getting ready
- How to do it...
- UAV photogrammetry in PostGIS orthorectification
- Getting ready
- How to do it...
- Converting the point cloud to Voronoi polygons
- Attributing polygons with the color
- Rendering polygons to raster
- UAV photogrammetry in PostGIS DSM creation
- Getting ready
- How it works...
- 8. PostGIS Programming
- Introduction
- Writing PostGIS vector data with Psycopg
- Getting ready
- How to do it...
- How it works...
- Writing PostGIS vector data with OGR Python bindings
- Getting ready
- How to do it...
- How it works...
- Writing PostGIS functions with PL/Python
- Getting ready
- How to do it...
- How it works...
- Geocoding and reverse-geocoding using the GeoNames datasets
- Getting ready
- How to do it...
- How it works...
- Geocoding using the OSM datasets with trigrams
- Getting ready
- How to do it...
- How it works...
- Geocoding with geopy and PL/Python
- Getting ready
- How to do it...
- How it works...
- Importing netCDF datasets with Python and GDAL
- Getting ready
- How to do it...
- How it works...
- 9. PostGIS and the Web
- Introduction
- Creating WMS and WFS services with MapServer
- Getting ready
- How to do it...
- How it works...
- See also
- Creating WMS and WFS services with GeoServer
- Getting ready
- How to do it...
- How it works...
- See also
- Creating a WMS Time with MapServer
- Getting ready
- How to do it...
- How it works...
- Consuming WMS services with OpenLayers
- Getting ready
- How to do it...
- How it works...
- Consuming WMS services with Leaflet
- How to do it...
- How it works...
- Consuming WFS-T services with OpenLayers
- Getting ready
- How to do it...
- How it works...
- Developing web applications with GeoDjango part 1
- Getting ready
- How to do it...
- How it works...
- Developing web applications with GeoDjango part 2
- Getting ready
- How to do it...
- How it works...
- 10. Maintenance, Optimization, and Performance Tuning
- Introduction
- Organizing the database
- Getting ready
- How to do it...
- How it works...
- Setting up the correct data privilege mechanism
- Getting ready
- How to do it...
- How it works...
- Backing up the database
- Getting ready
- How to do it...
- How it works...
- Using indexes
- Getting ready
- How to do it...
- How it works...
- Clustering for efficiency
- Getting ready
- How to do it...
- How it works...
- Optimizing SQL queries
- Getting ready
- How to do it...
- How it works...
- Migrating a PostGIS database to a different server
- Getting ready
- How to do it...
- How it works...
- Replicating a PostGIS database with streaming replication
- Getting ready
- How to do it...
- How it works...
- 11. Using Desktop Clients
- Introduction
- Adding PostGIS layers QGIS
- Getting ready
- How to do it...
- How it works...
- Using the Database Manager plugin QGIS
- Getting ready
- How to do it...
- How it works...
- Adding PostGIS layers OpenJUMP GIS
- Getting ready
- How to do it...
- How it works...
- Running database queries OpenJUMP GIS
- Getting ready
- How to do it...
- How it works...
- Adding PostGIS layers gvSIG
- Getting ready
- How to do it...
- How it works...
- Adding PostGIS layers uDig
- How to do it...
- How it works...
- Index
Packt Publishing - inne książki
-
Mastering Data transformation is essential for enhancing their data models and business intelligence. The Definitive Guide to Power Query equips you with the knowledge and skills to master the tool while leveraging its remarkable capabilities.
The Definitive Guide to Power Query (M). Mastering complex data transformation with Power Query The Definitive Guide to Power Query (M). Mastering complex data transformation with Power Query
Gregory Deckler, Rick de Groot, Melissa de Korte, Brian Julius
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
Oceny i opinie klientów: PostGIS Cookbook. For web developers and software architects this book will provide a vital guide to the tools and capabilities available to PostGIS spatial databases. Packed with hands-on recipes and powerful concepts Paolo Corti, Stephen Vincent Mather, Thomas Kraft, Bborie Park (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.