PulsarPlot - Advanced Pulsar Data Analysis Platform

Platform Overview

PulsarPlot is a comprehensive scientific data analysis platform providing advanced Online Analytical Processing (OLAP) capabilities for pulsar research. The platform integrates multiple astronomical databases and provides interactive visualization, statistical analysis, and custom SQL querying capabilities for researchers, students, and astronomy professionals.

Available Data Sources

  • ATNF Pulsar Catalogue: Primary database containing 4,303 pulsars with 12 core parameters including period (P0), period derivative (P1), magnetic field strength (BSURF), age, distance, dispersion measure, and galactic coordinates.
  • Database Metadata: Comprehensive field descriptions, units, completion percentages, and data quality metrics for all available parameters.
  • PulsarDatabase.parquet: High-performance columnar data format optimized for analytical queries and statistical operations.
  • DatabaseMetadata.parquet: Schema documentation and data dictionary for all available fields and their scientific significance.

SQL and OLAP Capabilities

PulsarPlot provides full SQL querying capabilities powered by DuckDB, enabling complex analytical queries and statistical operations on the entire pulsar dataset.

Available Tables

  • PULSARS: Main pulsar data table with 4,303 records
  • METADATA: Field definitions and data quality information

Query Capabilities

  • Standard SQL SELECT, WHERE, GROUP BY, ORDER BY, and JOIN operations
  • Aggregate functions: COUNT, SUM, AVG, MIN, MAX, STDDEV
  • Statistical analysis: correlation, regression, and distribution analysis
  • Complex filtering and data subsetting
  • Custom calculations and derived parameters
  • Export results to multiple formats (CSV, JSON, Parquet)

Pre-built Analytical Queries

  • Millisecond Pulsars: Pulsars with period less than 30ms
  • Magnetars: High-period pulsars with period greater than 1 second
  • High Magnetic Field Pulsars: Pulsars with BSURF > 10^12 G
  • Period Derivative Analysis: P1/P0 ratio calculations
  • Globular Cluster Pulsars: Pulsars organized by cluster association
  • Pulsar Type Distribution: Statistical breakdown by pulsar classification

Interactive Visualization Features

The platform provides advanced 2D scatter plot visualizations with real-time interaction capabilities for exploring pulsar parameter relationships.

Plottable Parameters

  • P0: Pulsar period in seconds
  • P1: Period derivative (s/s)
  • AGE: Characteristic age in years
  • BSURF: Surface magnetic field strength in Gauss
  • EDOT: Spin-down energy loss rate (erg/s)
  • DIST: Distance from Earth in kiloparsecs
  • DM: Dispersion measure (pc/cm³)
  • GL: Galactic longitude in degrees
  • GB: Galactic latitude in degrees

Interactive Features

  • Real-time zoom and pan for exploring dense data clusters
  • Multi-criteria filtering with AND/OR logic
  • Color coding by various parameters (magnetic field, type, age, etc.)
  • Interactive tooltips with detailed pulsar information
  • Customizable point size and opacity
  • Logarithmic and linear scaling options

Data Export and Analysis

PulsarPlot supports comprehensive data export and analysis capabilities for research publication and further statistical analysis.

Export Formats

  • PNG: High-resolution raster images for publications
  • PDF: Vector-based plots for scientific papers
  • SVG: Scalable vector graphics with embedded styling
  • CSV: Tabular data export for statistical software
  • JSON: Structured data for programmatic analysis

Analysis Tools

  • Statistical summaries and descriptive statistics
  • Data quality assessment and completeness analysis
  • Custom parameter calculations and derived quantities
  • Filtered dataset generation for specific research questions

Accessibility Features

PulsarPlot is designed with accessibility in mind, providing comprehensive support for screen readers and assistive technologies.

  • Full keyboard navigation support
  • Screen reader compatible data tables and results
  • High contrast mode support
  • Alternative text for all visual elements
  • Structured heading hierarchy for easy navigation
  • ARIA labels and roles for complex interactive elements

Technical Specifications

  • Data Format: Parquet columnar storage for optimal performance
  • Query Engine: DuckDB for high-performance analytical queries
  • Visualization: D3.js for interactive data visualization
  • Storage: IndexedDB for offline data persistence
  • Validation: Zod schemas for data integrity and type safety
  • Framework: Next.js 15 with React 19 for modern web standards
XY
XY
?
Enter Standard SQL Query
This allows for OLAP-style SQL analytics
on the entire pulsar database
Tables: PULSARS, METADATA
Check Query Preset for examples