Geospatial analysis with SQL: a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham ; Mumbai
Packt Publishing
2022
|
| Online Access: | FHD01 |
| Physical Description: | 1 Online-Ressource (xv, 217 Seiten) |
| ISBN: | 9781804610640 |
Staff View
MARC
| LEADER | 00000nmm a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV048917759 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 230428s2022 |||| o||u| ||||||eng d | ||
| 020 | |a 9781804610640 |9 978-1-80461-064-0 | ||
| 035 | |a (OCoLC)1378501345 | ||
| 035 | |a (DE-599)BVBBV048917759 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1050 | ||
| 100 | 1 | |a McClain, Bonny P. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Geospatial analysis with SQL |b a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL |c Bonny P McClain |
| 264 | 1 | |a Birmingham ; Mumbai |b Packt Publishing |c 2022 | |
| 300 | |a 1 Online-Ressource (xv, 217 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 505 | 8 | |a Cover -- Title Page -- Copyright and Credits -- Dedication -- Contributors -- Table of Contents -- Preface -- Section 1: Getting Started with Geospatial Analytics -- Chapter 1: Introducing the Fundamentals of Geospatial Analytics -- Technical requirements -- Spatial databases -- SRIDs -- Understanding geospatial data types -- Raster models -- Exploring SQL -- SELECT statements -- WHERE statements -- CREATE statements -- Summary -- Chapter 2: Conceptual Framework for SQL Spatial Data Science -- Geometry Versus Geography -- Technical requirements -- Creating a spatial database | |
| 505 | 8 | |a Options for databases with spatial functions -- Exploring databases with psql -- Importing data -- Fundamentals of a query-based syntax -- Changing column names -- Identifying tables -- Introducing query-based syntax -- Analyzing spatial relationships -- Detecting patterns, anomalies, and testing hypotheses -- Summary -- Chapter 3: Analyzing and Understanding Spatial Algorithms -- Technical Requirements -- Developing knowledge about geographic space -- Connecting to databases and executing SQL queries -- Reasoning and key decisions about spatial concepts -- Exploring pattern detection tools | |
| 505 | 8 | |a Executing SQL queries in QGIS -- Summary -- Chapter 4: An Overview of Spatial Statistics -- Technical requirements -- Creating spatial vectors with SQL -- Renaming table columns -- US census -- What do the census table codes mean? -- Running queries in QGIS -- Building prediction models -- Summary -- Section 2: SQL for Spatial Analytics -- Chapter 5: Using SQL Functions -- Spatial and Non-Spatial -- Technical requirements -- Preparing data -- Creating a dataset using the Open Street Map plugin -- Null values in PostgreSQL -- Spatial concepts -- ST_Within -- CREATE VIEW -- ST_Buffer | |
| 505 | 8 | |a Creating functions in SQL -- Mining areas in Brazil -- Summary -- Chapter 6: Building SQL Queries Visually in a Graphical Query Builder -- Technical requirements -- Conditional queries -- SQL data queries using the graphical query builder -- Aggregation and sorting queries -- Understanding census-designated places -- The SQL Query Builder -- Exploring census data in the SQL Query Builder -- Summary -- Chapter 7: Exploring PostGIS for Geographic Analysis -- Technical requirements -- Configuring and authenticating PostGIS in QGIS -- Loading data into PostGIS -- Importing data into PostGIS | |
| 505 | 8 | |a Discovering the PgAdmin dashboard -- Executing SQL queries in pgAdmin -- Importing additional data -- power plants -- Additional data queries -- IS NOT NULL -- Differentiating polygons in OSM data -- Spatial queries -- Exploring ST_Contains and multi-table joins -- Summary -- Chapter 8: Integrating SQL with QGIS -- Technical Requirements -- Understanding the SQL query builder in QGIS -- Comparing polygons between two large datasets -- Raster data -- Installing plugins -- The GEE data catalog plugin -- Landscape Change Monitoring System -- raster2pgsql -- Terminal raster import -- Summary -- Index | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-80461-646-8 |
| 912 | |a ZDB-30-PQE | ||
| 999 | |a oai:aleph.bib-bvb.de:BVB01-034181862 | ||
| 966 | e | |u https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=30302624 |l FHD01 |p ZDB-30-PQE |q FHD01_PQE_Kauf |x Aggregator |3 Volltext | |
Record in the Search Index
| _version_ | 1804185095206076416 |
|---|---|
| adam_txt | |
| any_adam_object | |
| any_adam_object_boolean | |
| author | McClain, Bonny P. |
| author_facet | McClain, Bonny P. |
| author_role | aut |
| author_sort | McClain, Bonny P. |
| author_variant | b p m bp bpm |
| building | Verbundindex |
| bvnumber | BV048917759 |
| collection | ZDB-30-PQE |
| contents | Cover -- Title Page -- Copyright and Credits -- Dedication -- Contributors -- Table of Contents -- Preface -- Section 1: Getting Started with Geospatial Analytics -- Chapter 1: Introducing the Fundamentals of Geospatial Analytics -- Technical requirements -- Spatial databases -- SRIDs -- Understanding geospatial data types -- Raster models -- Exploring SQL -- SELECT statements -- WHERE statements -- CREATE statements -- Summary -- Chapter 2: Conceptual Framework for SQL Spatial Data Science -- Geometry Versus Geography -- Technical requirements -- Creating a spatial database Options for databases with spatial functions -- Exploring databases with psql -- Importing data -- Fundamentals of a query-based syntax -- Changing column names -- Identifying tables -- Introducing query-based syntax -- Analyzing spatial relationships -- Detecting patterns, anomalies, and testing hypotheses -- Summary -- Chapter 3: Analyzing and Understanding Spatial Algorithms -- Technical Requirements -- Developing knowledge about geographic space -- Connecting to databases and executing SQL queries -- Reasoning and key decisions about spatial concepts -- Exploring pattern detection tools Executing SQL queries in QGIS -- Summary -- Chapter 4: An Overview of Spatial Statistics -- Technical requirements -- Creating spatial vectors with SQL -- Renaming table columns -- US census -- What do the census table codes mean? -- Running queries in QGIS -- Building prediction models -- Summary -- Section 2: SQL for Spatial Analytics -- Chapter 5: Using SQL Functions -- Spatial and Non-Spatial -- Technical requirements -- Preparing data -- Creating a dataset using the Open Street Map plugin -- Null values in PostgreSQL -- Spatial concepts -- ST_Within -- CREATE VIEW -- ST_Buffer Creating functions in SQL -- Mining areas in Brazil -- Summary -- Chapter 6: Building SQL Queries Visually in a Graphical Query Builder -- Technical requirements -- Conditional queries -- SQL data queries using the graphical query builder -- Aggregation and sorting queries -- Understanding census-designated places -- The SQL Query Builder -- Exploring census data in the SQL Query Builder -- Summary -- Chapter 7: Exploring PostGIS for Geographic Analysis -- Technical requirements -- Configuring and authenticating PostGIS in QGIS -- Loading data into PostGIS -- Importing data into PostGIS Discovering the PgAdmin dashboard -- Executing SQL queries in pgAdmin -- Importing additional data -- power plants -- Additional data queries -- IS NOT NULL -- Differentiating polygons in OSM data -- Spatial queries -- Exploring ST_Contains and multi-table joins -- Summary -- Chapter 8: Integrating SQL with QGIS -- Technical Requirements -- Understanding the SQL query builder in QGIS -- Comparing polygons between two large datasets -- Raster data -- Installing plugins -- The GEE data catalog plugin -- Landscape Change Monitoring System -- raster2pgsql -- Terminal raster import -- Summary -- Index |
| ctrlnum | (OCoLC)1378501345 (DE-599)BVBBV048917759 |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>04133nmm a2200349 c 4500</leader><controlfield tag="001">BV048917759</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">230428s2022 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781804610640</subfield><subfield code="9">978-1-80461-064-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1378501345</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV048917759</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">McClain, Bonny P.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Geospatial analysis with SQL</subfield><subfield code="b">a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL</subfield><subfield code="c">Bonny P McClain</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham ; Mumbai</subfield><subfield code="b">Packt Publishing</subfield><subfield code="c">2022</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xv, 217 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Title Page -- Copyright and Credits -- Dedication -- Contributors -- Table of Contents -- Preface -- Section 1: Getting Started with Geospatial Analytics -- Chapter 1: Introducing the Fundamentals of Geospatial Analytics -- Technical requirements -- Spatial databases -- SRIDs -- Understanding geospatial data types -- Raster models -- Exploring SQL -- SELECT statements -- WHERE statements -- CREATE statements -- Summary -- Chapter 2: Conceptual Framework for SQL Spatial Data Science -- Geometry Versus Geography -- Technical requirements -- Creating a spatial database</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Options for databases with spatial functions -- Exploring databases with psql -- Importing data -- Fundamentals of a query-based syntax -- Changing column names -- Identifying tables -- Introducing query-based syntax -- Analyzing spatial relationships -- Detecting patterns, anomalies, and testing hypotheses -- Summary -- Chapter 3: Analyzing and Understanding Spatial Algorithms -- Technical Requirements -- Developing knowledge about geographic space -- Connecting to databases and executing SQL queries -- Reasoning and key decisions about spatial concepts -- Exploring pattern detection tools</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Executing SQL queries in QGIS -- Summary -- Chapter 4: An Overview of Spatial Statistics -- Technical requirements -- Creating spatial vectors with SQL -- Renaming table columns -- US census -- What do the census table codes mean? -- Running queries in QGIS -- Building prediction models -- Summary -- Section 2: SQL for Spatial Analytics -- Chapter 5: Using SQL Functions -- Spatial and Non-Spatial -- Technical requirements -- Preparing data -- Creating a dataset using the Open Street Map plugin -- Null values in PostgreSQL -- Spatial concepts -- ST_Within -- CREATE VIEW -- ST_Buffer</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Creating functions in SQL -- Mining areas in Brazil -- Summary -- Chapter 6: Building SQL Queries Visually in a Graphical Query Builder -- Technical requirements -- Conditional queries -- SQL data queries using the graphical query builder -- Aggregation and sorting queries -- Understanding census-designated places -- The SQL Query Builder -- Exploring census data in the SQL Query Builder -- Summary -- Chapter 7: Exploring PostGIS for Geographic Analysis -- Technical requirements -- Configuring and authenticating PostGIS in QGIS -- Loading data into PostGIS -- Importing data into PostGIS</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Discovering the PgAdmin dashboard -- Executing SQL queries in pgAdmin -- Importing additional data -- power plants -- Additional data queries -- IS NOT NULL -- Differentiating polygons in OSM data -- Spatial queries -- Exploring ST_Contains and multi-table joins -- Summary -- Chapter 8: Integrating SQL with QGIS -- Technical Requirements -- Understanding the SQL query builder in QGIS -- Comparing polygons between two large datasets -- Raster data -- Installing plugins -- The GEE data catalog plugin -- Landscape Change Monitoring System -- raster2pgsql -- Terminal raster import -- Summary -- Index</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">978-1-80461-646-8</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-034181862</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=30302624</subfield><subfield code="l">FHD01</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">FHD01_PQE_Kauf</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV048917759 |
| illustrated | Not Illustrated |
| index_date | 2024-07-03T21:55:04Z |
| indexdate | 2024-07-10T09:49:47Z |
| institution | BVB |
| isbn | 9781804610640 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-034181862 |
| oclc_num | 1378501345 |
| open_access_boolean | |
| owner | DE-1050 |
| owner_facet | DE-1050 |
| physical | 1 Online-Ressource (xv, 217 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE FHD01_PQE_Kauf |
| publishDate | 2022 |
| publishDateSearch | 2022 |
| publishDateSort | 2022 |
| publisher | Packt Publishing |
| record_format | marc |
| spelling | McClain, Bonny P. Verfasser aut Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL Bonny P McClain Birmingham ; Mumbai Packt Publishing 2022 1 Online-Ressource (xv, 217 Seiten) txt rdacontent c rdamedia cr rdacarrier Cover -- Title Page -- Copyright and Credits -- Dedication -- Contributors -- Table of Contents -- Preface -- Section 1: Getting Started with Geospatial Analytics -- Chapter 1: Introducing the Fundamentals of Geospatial Analytics -- Technical requirements -- Spatial databases -- SRIDs -- Understanding geospatial data types -- Raster models -- Exploring SQL -- SELECT statements -- WHERE statements -- CREATE statements -- Summary -- Chapter 2: Conceptual Framework for SQL Spatial Data Science -- Geometry Versus Geography -- Technical requirements -- Creating a spatial database Options for databases with spatial functions -- Exploring databases with psql -- Importing data -- Fundamentals of a query-based syntax -- Changing column names -- Identifying tables -- Introducing query-based syntax -- Analyzing spatial relationships -- Detecting patterns, anomalies, and testing hypotheses -- Summary -- Chapter 3: Analyzing and Understanding Spatial Algorithms -- Technical Requirements -- Developing knowledge about geographic space -- Connecting to databases and executing SQL queries -- Reasoning and key decisions about spatial concepts -- Exploring pattern detection tools Executing SQL queries in QGIS -- Summary -- Chapter 4: An Overview of Spatial Statistics -- Technical requirements -- Creating spatial vectors with SQL -- Renaming table columns -- US census -- What do the census table codes mean? -- Running queries in QGIS -- Building prediction models -- Summary -- Section 2: SQL for Spatial Analytics -- Chapter 5: Using SQL Functions -- Spatial and Non-Spatial -- Technical requirements -- Preparing data -- Creating a dataset using the Open Street Map plugin -- Null values in PostgreSQL -- Spatial concepts -- ST_Within -- CREATE VIEW -- ST_Buffer Creating functions in SQL -- Mining areas in Brazil -- Summary -- Chapter 6: Building SQL Queries Visually in a Graphical Query Builder -- Technical requirements -- Conditional queries -- SQL data queries using the graphical query builder -- Aggregation and sorting queries -- Understanding census-designated places -- The SQL Query Builder -- Exploring census data in the SQL Query Builder -- Summary -- Chapter 7: Exploring PostGIS for Geographic Analysis -- Technical requirements -- Configuring and authenticating PostGIS in QGIS -- Loading data into PostGIS -- Importing data into PostGIS Discovering the PgAdmin dashboard -- Executing SQL queries in pgAdmin -- Importing additional data -- power plants -- Additional data queries -- IS NOT NULL -- Differentiating polygons in OSM data -- Spatial queries -- Exploring ST_Contains and multi-table joins -- Summary -- Chapter 8: Integrating SQL with QGIS -- Technical Requirements -- Understanding the SQL query builder in QGIS -- Comparing polygons between two large datasets -- Raster data -- Installing plugins -- The GEE data catalog plugin -- Landscape Change Monitoring System -- raster2pgsql -- Terminal raster import -- Summary -- Index Erscheint auch als Druck-Ausgabe 978-1-80461-646-8 |
| spellingShingle | McClain, Bonny P. Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL Cover -- Title Page -- Copyright and Credits -- Dedication -- Contributors -- Table of Contents -- Preface -- Section 1: Getting Started with Geospatial Analytics -- Chapter 1: Introducing the Fundamentals of Geospatial Analytics -- Technical requirements -- Spatial databases -- SRIDs -- Understanding geospatial data types -- Raster models -- Exploring SQL -- SELECT statements -- WHERE statements -- CREATE statements -- Summary -- Chapter 2: Conceptual Framework for SQL Spatial Data Science -- Geometry Versus Geography -- Technical requirements -- Creating a spatial database Options for databases with spatial functions -- Exploring databases with psql -- Importing data -- Fundamentals of a query-based syntax -- Changing column names -- Identifying tables -- Introducing query-based syntax -- Analyzing spatial relationships -- Detecting patterns, anomalies, and testing hypotheses -- Summary -- Chapter 3: Analyzing and Understanding Spatial Algorithms -- Technical Requirements -- Developing knowledge about geographic space -- Connecting to databases and executing SQL queries -- Reasoning and key decisions about spatial concepts -- Exploring pattern detection tools Executing SQL queries in QGIS -- Summary -- Chapter 4: An Overview of Spatial Statistics -- Technical requirements -- Creating spatial vectors with SQL -- Renaming table columns -- US census -- What do the census table codes mean? -- Running queries in QGIS -- Building prediction models -- Summary -- Section 2: SQL for Spatial Analytics -- Chapter 5: Using SQL Functions -- Spatial and Non-Spatial -- Technical requirements -- Preparing data -- Creating a dataset using the Open Street Map plugin -- Null values in PostgreSQL -- Spatial concepts -- ST_Within -- CREATE VIEW -- ST_Buffer Creating functions in SQL -- Mining areas in Brazil -- Summary -- Chapter 6: Building SQL Queries Visually in a Graphical Query Builder -- Technical requirements -- Conditional queries -- SQL data queries using the graphical query builder -- Aggregation and sorting queries -- Understanding census-designated places -- The SQL Query Builder -- Exploring census data in the SQL Query Builder -- Summary -- Chapter 7: Exploring PostGIS for Geographic Analysis -- Technical requirements -- Configuring and authenticating PostGIS in QGIS -- Loading data into PostGIS -- Importing data into PostGIS Discovering the PgAdmin dashboard -- Executing SQL queries in pgAdmin -- Importing additional data -- power plants -- Additional data queries -- IS NOT NULL -- Differentiating polygons in OSM data -- Spatial queries -- Exploring ST_Contains and multi-table joins -- Summary -- Chapter 8: Integrating SQL with QGIS -- Technical Requirements -- Understanding the SQL query builder in QGIS -- Comparing polygons between two large datasets -- Raster data -- Installing plugins -- The GEE data catalog plugin -- Landscape Change Monitoring System -- raster2pgsql -- Terminal raster import -- Summary -- Index |
| title | Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL |
| title_auth | Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL |
| title_exact_search | Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL |
| title_exact_search_txtP | Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL |
| title_full | Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL Bonny P McClain |
| title_fullStr | Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL Bonny P McClain |
| title_full_unstemmed | Geospatial analysis with SQL a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL Bonny P McClain |
| title_short | Geospatial analysis with SQL |
| title_sort | geospatial analysis with sql a hands on guide to performing geospatial analysis by unlocking the syntax of spatial sql |
| title_sub | a hands-on guide to performing geospatial analysis by unlocking the syntax of spatial SQL |
| work_keys_str_mv | AT mcclainbonnyp geospatialanalysiswithsqlahandsonguidetoperforminggeospatialanalysisbyunlockingthesyntaxofspatialsql |