Skip to main content
Geographic Information Systems

Return to Question

Tweeted twitter.com/StackGIS/status/1435664248529723392
added 4 characters in body; edited tags; edited title
Source Link
Taras ♦
Taras ♦
  • 34.1k
  • 4
  • 73
  • 148

Performing Mergemerge in PostGIS

I am new toBy means of the PostgreSQL/PostGIS andI want to replicate a function from a Python script into a SQL query. In my Python script, I have a list of feature classes and I use ArcPy's Merge_Management to merge them together into a new layer called s_stud:

study_lyr_list = ["region_1", "region_2", "region_3"]
arcpy.Merge_management(studies_lyr_list, s_studs)

I essentially have the same thing setup in PostGIS. I have tables for regions 1, 2, and 3 and I want to merge them together. They all share the same fields, so basically, I am just combining them together into a new master table.

How would I do that as a query?

I have the PostGIS extensions.

Performing Merge in PostGIS

I am new to PostgreSQL/PostGIS and want to replicate a function from a Python script into a SQL query. In my Python script, I have a list of feature classes and I use ArcPy's Merge_Management to merge them together into a new layer called s_stud:

study_lyr_list = ["region_1", "region_2", "region_3"]
arcpy.Merge_management(studies_lyr_list, s_studs)

I essentially have the same thing setup in PostGIS. I have tables for regions 1, 2, and 3 and I want to merge them together. They all share the same fields, so basically, I am just combining them together into a new master table.

How would I do that as a query?

I have the PostGIS extensions.

Performing merge in PostGIS

By means of the PostgreSQL/PostGIS I want to replicate a function from a Python script into a SQL query. In my Python script, I have a list of feature classes and I use ArcPy's Merge_Management to merge them together into a new layer called s_stud:

study_lyr_list = ["region_1", "region_2", "region_3"]
arcpy.Merge_management(studies_lyr_list, s_studs)

I essentially have the same thing setup in PostGIS. I have tables for regions 1, 2, and 3 and I want to merge them together. They all share the same fields, so basically, I am just combining them together into a new master table.

How would I do that as a query?

I have the PostGIS extensions.

Became Hot Network Question
added 1 character in body; edited tags; edited title; deleted 1 character in body; edited title; edited title
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

Performing the `arcpy` Merge equivalent in PostGres SQLPostGIS

I am new to Postgres SQLPostgreSQL/PostGIS and want to replicate a function from a Python script into a SQL query. In my Python script, I have a list of feature classes and I use arcpy'sArcPy's Merge_Management to merge them together into a new layer called s_stud:

study_lyr_list = ["region_1", "region_2", "region_3"]
arcpy.Merge_management(studies_lyr_list, s_studs)

I essentially have the same thing setup in PostgresPostGIS. I have tables for regions 1, 2, and 3 and I want to merge them together. They all sharshare the same fields, so basically, I am just combining them together into a new master table. 

How would I do that as a query? *I

I have the PostGIS extensions.

Performing the `arcpy` Merge equivalent in PostGres SQL

I am new to Postgres SQL/PostGIS and want to replicate a function from a Python script into a SQL query. In my Python script, I have a list of feature classes and I use arcpy's Merge_Management to merge them together into a new layer called s_stud:

study_lyr_list = ["region_1", "region_2", "region_3"]
arcpy.Merge_management(studies_lyr_list, s_studs)

I essentially have the same thing setup in Postgres. I have tables for regions 1, 2, and 3 and I want to merge them together. They all shar the same fields, so basically, I am just combining them together into a new master table. How would I do that as a query? *I have the PostGIS extensions.

Performing Merge in PostGIS

I am new to PostgreSQL/PostGIS and want to replicate a function from a Python script into a SQL query. In my Python script, I have a list of feature classes and I use ArcPy's Merge_Management to merge them together into a new layer called s_stud:

study_lyr_list = ["region_1", "region_2", "region_3"]
arcpy.Merge_management(studies_lyr_list, s_studs)

I essentially have the same thing setup in PostGIS. I have tables for regions 1, 2, and 3 and I want to merge them together. They all share the same fields, so basically, I am just combining them together into a new master table. 

How would I do that as a query?

I have the PostGIS extensions.

Source Link
gwydion93
gwydion93
  • 1.9k
  • 4
  • 30
  • 64

Performing the `arcpy` Merge equivalent in PostGres SQL

I am new to Postgres SQL/PostGIS and want to replicate a function from a Python script into a SQL query. In my Python script, I have a list of feature classes and I use arcpy's Merge_Management to merge them together into a new layer called s_stud:

study_lyr_list = ["region_1", "region_2", "region_3"]
arcpy.Merge_management(studies_lyr_list, s_studs)

I essentially have the same thing setup in Postgres. I have tables for regions 1, 2, and 3 and I want to merge them together. They all shar the same fields, so basically, I am just combining them together into a new master table. How would I do that as a query? *I have the PostGIS extensions.