Skip to main content

SQLAlchemy extension for indexed cone searches in astronomical catalogs

Project description

PyPI Status GitHub Workflow Status codecov

Cone Search Alchemy

The conesearch_alchemy Python package enhances SQLAlchemy to provide fast, indexed cone searches on astronomical catalogs using a PostgreSQL database. It does not rely on any database extensions.

Installation

You can install conesearch_alchemy the Python Package Index:

$ pip install conesearch-alchemy

Usage

from conesearch_alchemy.point import Point
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


# Create two tables Catalog1 and Catalog2 that both have spherical coordinates.

class Catalog1(Point, Base):
    __tablename__ = 'catalog1'
    id = Column(Integer, primary_key=True)


class Catalog2(Point, Base):
    __tablename__ = 'catalog2'
    id = Column(Integer, primary_key=True)


...

# Populate Catalog1 and Catalog2 tables with some sample data...
session.add(Catalog1(id=0, ra=320.5, dec=-23.5))
...
session.add(Catalog2(id=0, ra=18.1, dec=18.3))
...
session.commit()


# Cross-match the two tables.
separation = 1  # separation in degrees
query = session.query(
    Catalog1.id, Catalog2.id
).join(
    Catalog2,
    Catalog1.within(point, separation)
).order_by(
    Catalog1.id, Catalog2.id
)
for row in query:
    ...  # do something with the query results


# Do a cone search around literal ra, dec values.
separation = 1  # separation in degrees
point = Point(ra=212.5, dec=-33.2)
query = session.query(
    Catalog1.id
).filter(
    Catalog1.within(point, separation)
).order_by(
    Catalog1.id
)
for row in query:
    ...  # do something with the query results

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

conesearch_alchemy-1.1.0.tar.gz (4.4 kB view details)

Uploaded Source

Built Distribution

conesearch_alchemy-1.1.0-py3-none-any.whl (5.5 kB view details)

Uploaded Python 3

File details

Details for the file conesearch_alchemy-1.1.0.tar.gz.

File metadata

  • Download URL: conesearch_alchemy-1.1.0.tar.gz
  • Upload date:
  • Size: 4.4 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.12.5

File hashes

Hashes for conesearch_alchemy-1.1.0.tar.gz
Algorithm Hash digest
SHA256 63bb97aa32f9da6457338fd7202a907b8c0eee43b5f9362daebe2a594db132b3
MD5 5844b6b6a732824ae464140c75b5c6e5
BLAKE2b-256 1db91ebd688a3ce0232626f974eab37ece6a0683979c8ac4ed54d1664d5349c4

See more details on using hashes here.

File details

Details for the file conesearch_alchemy-1.1.0-py3-none-any.whl.

File metadata

File hashes

Hashes for conesearch_alchemy-1.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 8291321b277ad18504d89f74e634c055dd35e70b1b1e967a57db10610e26df35
MD5 3f524660e572310f711f21a965be5c6d
BLAKE2b-256 adf2a4aaf8f783b9c57ef308143ddb75c56804eb0ee79f179f869f4d7b9fdb88

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page