![WellDatabase-Rect-1000x159-1.png]](https://support.welldatabase.com/hs-fs/hubfs/WellDatabase-Rect-1000x159-1.png?height=40&name=WellDatabase-Rect-1000x159-1.png){kind=small}
What is Simple ID?
Simple ID is a numeric identifier assigned to a well for efficient querying and joining across WellDatabase datasets.
How Does Simple ID Work?
Each well is assigned a Simple ID when the well is first ingested into WellDatabase. The Simple ID remains associated with that well over time.
Simple ID can be used to associate related records across WellDatabase datasets. For example, Header and Completions can be joined using Simple ID.
Both Simple ID and Infinity ID identify the same well and can be used to join related WellDatabase datasets.
When Should I Use Simple ID vs. Infinity ID?
The primary difference between Simple ID and Infinity ID is where each identifier is most useful.
-
Simple ID is a small integer that is convenient for querying and joining WellDatabase data. Its shorter format also makes it easier to use in filters and spreadsheets.
-
Infinity ID (WellID) is a globally unique identifier (GUID) recommended when storing or mapping WellDatabase wells in an external system.
Related Article
Frequently Asked Questions
Q: What is Simple ID?
A: Simple ID is a numeric identifier assigned to a well for efficient querying and joining across WellDatabase datasets.
Q: What is Simple ID used for?
A: Simple ID can be used to query well-related data and associate records across datasets. For example, Header and Completions can be joined using Simple ID.
Q: What does the Simple ID REST API filter match?
A: The Simple ID filter matches the Simple ID assigned to a well and returns records associated with the specified Simple ID values.
Q: What is the difference between Simple ID and Infinity ID?
A: Both Simple ID and Infinity ID identify the same well and can be used to join related WellDatabase datasets. Simple ID is a shorter numeric identifier designed for efficient querying and joining, while Infinity ID (WellID) is a globally unique identifier recommended when storing or mapping WellDatabase wells in external systems.
Q: Does Simple ID change over time?
A: No. Simple ID is assigned when a well is first ingested into WellDatabase and remains associated with that well over time.
Explore additional articles by searching the topics on the left. If you have any questions, feel free to email support@welldatabase.com