MrPowers commented on code in PR #64:
URL: https://github.com/apache/sedona-db/pull/64#discussion_r2342308495
##########
docs/programming-guide.md:
##########
@@ -0,0 +1,239 @@
+# SedonaDB Guide
+
+This page explains how to process vector data with SedonaDB.
+
+You will learn how to create SedonaDB DataFrames, run spatial queries, and
perform I/O operations with various types of files.
+
+Let’s start by establishing a SedonaDB connection.
+
+## Establish SedonaDB connection
+
+Here’s how to create the SedonaDB connection:
+
+```python
+import sedona.db
+
+sd = sedona.db.connect()
+```
+
+Now let’s see how to create SedonaDB DataFrames.
+
+## Create SedonaDB DataFrame
+
+**Manually creating SedonaDB DataFrame**
+
+Here’s how to manually create a SedonaDB DataFrame:
+
+```python
+df = sd.sql("""
+SELECT * FROM (VALUES
+ ('one', ST_GeomFromWkt('POINT(1 2)')),
+ ('two', ST_GeomFromWkt('POLYGON((-74.0 40.7, -74.0 40.8, -73.9 40.8, -73.9
40.7, -74.0 40.7))')),
+ ('three', ST_GeomFromWkt('LINESTRING(-74.0060 40.7128, -73.9352 40.7306,
-73.8561 40.8484)')))
+AS t(val, point)""")
+```
+
+Check the contents of the DataFrame:
+
+```python
+df.show()
+```
+
+```
+┌───────┬───────────────────────────────────────────────────────────────┐
+│ val ┆ point │
+│ utf8 ┆ wkb │
+╞═══════╪═══════════════════════════════════════════════════════════════╡
+│ one ┆ POINT(1 2) │
+├╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ two ┆ POLYGON((-74 40.7,-74 40.8,-73.9 40.8,-73.9 40.7,-74 40.7)) │
+├╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ three ┆ LINESTRING(-74.006 40.7128,-73.9352 40.7306,-73.8561 40.8484) │
+└───────┴───────────────────────────────────────────────────────────────┘
+```
+
+Check the type of the DataFrame.
+
+```python
+type(df)
+
+sedonadb.dataframe.DataFrame
+```
+
+**Create SedonaDB DataFrame from files in S3**
+
+For most production applications, you will create SedonaDB DataFrames by
reading data from a file. Let’s see how to read GeoParquet files in AWS S3
into a SedonaDB DataFrame.
+
+Import the required libraries and set environment variables:
+
+```python
+import os
+
+os.environ["AWS_SKIP_SIGNATURE"] = "true"
+os.environ["AWS_DEFAULT_REGION"] = "us-west-2"
Review Comment:
Oh, that's nice, will update!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
