File Information

Import from public.states

Imported from PostGIS table: public.states

POSTGIS Uploaded Aug 9, 2025 at 12:03 PM
Dataset Information
No Information Available

No additional information has been provided for this dataset.

Import from public.states
49 records
Advanced Filters
Quick Tips:
• Use Ctrl+F to focus search
• Use Ctrl+Shift+F to toggle filters
• Combine multiple filters for precise results
Operators:
• Between for ranges (e.g., 10,100)
• Regex for pattern matching
• Case sensitive for exact matches
Showing all 49 records
ID State abbr State fips State name
1 IL 17 Illinois
2 DC 11 District of Columbia
3 DE 10 Delaware
4 WV 54 West Virginia
5 MD 24 Maryland
6 CO 08 Colorado
7 KY 21 Kentucky
8 KS 20 Kansas
9 MO 29 Missouri
10 VA 51 Virginia
11 AZ 04 Arizona
12 OK 40 Oklahoma
13 NC 37 North Carolina
14 TN 47 Tennessee
15 TX 48 Texas
16 NM 35 New Mexico
17 AL 01 Alabama
18 MS 28 Mississippi
19 GA 13 Georgia
20 SC 45 South Carolina
21 AR 05 Arkansas
22 LA 22 Louisiana
23 FL 12 Florida
24 MI 26 Michigan
25 MT 30 Montana
26 ME 23 Maine
27 ND 38 North Dakota
28 SD 46 South Dakota
29 WY 56 Wyoming
30 WI 55 Wisconsin
31 ID 16 Idaho
32 VT 50 Vermont
33 MN 27 Minnesota
34 OR 41 Oregon
35 NH 33 New Hampshire
36 IA 19 Iowa
37 MA 25 Massachusetts
38 NE 31 Nebraska
39 NY 36 New York
40 PA 42 Pennsylvania
41 CT 09 Connecticut
42 RI 44 Rhode Island
43 NJ 34 New Jersey
44 IN 18 Indiana
45 NV 32 Nevada
46 UT 49 Utah
47 CA 06 California
48 OH 39 Ohio
49 WA 53 Washington
Loading Map...
Preparing spatial data visualization
Data Analysis
Chart Options
Export Spatial Data
CSV Export

Download data as a comma-separated values file with coordinates and properties.

Download CSV
GeoJSON Export

Download data in GeoJSON format, compatible with most GIS applications.

Download GeoJSON
KML Export

Download data in KML format for use with Google Earth and other mapping applications.

Download KML
Shapefile Export

Download data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.

Download Shapefile
Export Information
  • CSV: Contains coordinates and all properties in a tabular format
  • GeoJSON: Standard format for web mapping and GIS applications
  • KML: Compatible with Google Earth, Google Maps, and other mapping platforms
  • Shapefile: Industry standard format for GIS software (requires GDAL/ogr2ogr)
Export Details
Total Features: 49
File Name: Import from public.states
Original Type: POSTGIS
Properties: 23 fields
Note: Shapefile export requires GDAL/ogr2ogr to be installed on the server. If unavailable, a GeoJSON file will be provided instead. Check your server's error logs for more details.
API Endpoints
Dataset Details

Get detailed information about this dataset including metadata and available properties.

Test Endpoint
Query Data

Query spatial data with filtering, pagination, and spatial operations.

Test Endpoint
Query Parameters
Pagination
  • page - Page number (default: 1)
  • limit - Results per page (max: 1000, default: 100)
Property Filtering
  • properties - JSON object for property filtering
  • geometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)
Spatial Filtering
  • bbox - Bounding box (minX,minY,maxX,maxY)
  • lat - Center latitude for radius search
  • lon - Center longitude for radius search
  • radius - Search radius in meters
Response Format
  • Returns GeoJSON FeatureCollection
  • Includes pagination metadata
  • Contains query information
Example Queries
Basic Queries
Advanced Queries
API Information
Base URL: https://tor.datacatalog.ca//api.php
Dataset ID: 200
Total Features: 49
Response Format: GeoJSON
Note: All API endpoints return JSON responses. The query endpoint returns GeoJSON FeatureCollection format for spatial data.
Rate Limiting: Consider implementing rate limiting for production use to prevent abuse.
Spatial Data Metadata
Basic Information
Statistical units
Spatial Reference
Technical Information
Citation Information
Temporal Information
Metadata Contact
Data Quality
Constraints
Distribution
Additional Information