topic Re: Create a VIEW (PIVOT) in Enterprise Geodatase in Geodatabase Questions

Create a VIEW (PIVOT) in Enterprise Geodatase

WilsonLee — Sat, 28 Mar 2020 23:07:07 GMT

Hi,

I'm new to sql/creating a pivot table as a view in Geodatabase.

I'm looking for the SQL query for the "Create New View" tool (see attached screenshot)

I tried to google many samples but it didn't work out. While I'm still googling, i thought i could ask you guys for help.

My goal is to create a VIEW (PIVOT) based on an existing table in the Geodatabase:

any direction, inputs, sample are appreciated!!!

million thanks!!

Existing table in Geodatabase:

Building Name

Status

Building A

Open

Building A

Open

Building A

Closed

Building B

Closed

Building B

Unknown

Building C

Unknown

Building D

Open

my goal is to create a VIEW (pivot) below based on the TABLE above

Building Name

Open

Closed

Unknown

Building A

Building B

Building C

Building D

Re: Create a VIEW (PIVOT) in Enterprise Geodatase

DanPatterson_Retired — Sat, 28 Mar 2020 23:16:13 GMT

like this but not exact, but worth a look

Pivot Table—Data Management toolbox | Documentation

Re: Create a VIEW (PIVOT) in Enterprise Geodatase

WilsonLee — Sat, 28 Mar 2020 23:46:06 GMT

thanks,

but i'm looking for the actual SQL Definition in the "Create New View" Tool , see my screenshot

but thanks anyway

Re: Create a VIEW (PIVOT) in Enterprise Geodatase

DanPatterson_Retired — Sun, 29 Mar 2020 00:04:04 GMT

Sorry, I use python/numpy based solutions

/blogs/dan_patterson/2018/02/12/table-tools-a-set-of-tools-for-working-with-tabular-data

Re: Create a VIEW (PIVOT) in Enterprise Geodatase

JoshuaBixby — Sun, 29 Mar 2020 15:13:18 GMT

The syntax for creating higher-level aggregation SQL, like PIVOT, tends to be very implementation specific, so it is crucial to share what DBMS is hosting the geodatabase.