apsg | Structural geology package for Python | Data Visualization library
kandi X-RAY | apsg Summary
kandi X-RAY | apsg Summary
APSG is package for structural geologists. It defines several new python classes to easily manage, analyze and visualize orientational structural geology data.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Draw the plot
- Plot a triangle
- Create a quick network from a list of arguments
- Create a cone artist
- Add a great circle artist
- Create a fault artist
- Plot the contour
- Project data onto the plane
- Plot a contour
- Convenience method to fetch a set of structures
- Generate a select statement based on structs
- Create a rotation matrix
- Calculates the angle of a fault
- Create a rotation matrix from two vectors
- Creates a contour
- Plot the grid of the grid
- Write a pmd file
- Scatter plot
- Plot a bar chart
- Cluster the model
- Generate a random normal vector
- Constructor of Orientation Tensor3
- Plot the arc
- Plot coords
- Transform this vector to a Vector3
- Display information about the database
apsg Key Features
apsg Examples and Code Snippets
pip install apsg
pip install git+git://github.com/ondrolexa/apsg.git
python setup.py install
pip install apsg --upgrade --no-deps
pip install --no-binary :all: apsg
conda config --add channels conda-forge
conda install apsg
conda search apsg --channel conda-forge
Community Discussions
Trending Discussions on apsg
QUESTION
I work primarily with SAS and Oracle and am still new to DB2. Im faced with needing a hierarchical query to separate a clob into chunks that can be pulled into sas. SAS has a limit of 32K for character variables so I cant just pull the dataset in normally.
I found an old stackoverflow question about the best way to pull a clob into a sas data set but it is written in Oracle. Import blob through SAS from ORACLE DB
Since I am new to DB2 and the syntax for this type of join seems very different I was hoping to find someone that could help convert it and explain the syntax. I find the Oracle syntax to be much easier to understand. I'm not sure in DB2 if you would use a CTE recursion like this https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/apsg/src/tpc/db2z_xmprecursivecte.html or if you would use hierarchical queries like this https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/sqlp/rbafyrecursivequeries.htm
Here is the Oracle query.
...ANSWER
Answered 2019-Mar-22 at 01:20Here is a solution that should work in DB2 with few changes (but please be advised that I don't know DB2 at all; I am just using Oracle features that are in the SQL Standard, so they should be implemented identically - or almost so - in DB2).
Below I create a table with your sample data; then I show how to chunk it into substrings of length at most 8 characters. Although the strings are short, I defined the column as CLOB and I am using CLOB tools; this should work on much larger CLOBs.
You can make both the chunk size and the id into bind parameters, if needed. In my demo below I hardcoded the chunk size and I show the result for all IDs in the table. In case the CLOB is NULL, I do return one chunk (which is NULL, of course).
Note that touching CLOBs in a query is very expensive; so most of the work is done without touching the CLOBs. I only work on them as little as possible.
PREP WORK
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install apsg
You can see APSG in action in accompanied Jupyter notebook http://nbviewer.jupyter.org/github/ondrolexa/apsg/blob/master/examples/apsg_tutorial.ipynb. And for fun check how simply you can animate stereonets http://nbviewer.jupyter.org/github/ondrolexa/apsg/blob/master/examples/animation_example.ipynb.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page