PostGIS Koop Provider

📖

API Documentation

Interactive API documentation with examples and schema definitions.

View Swagger Docs

🎯

Quick Test

Test the API with sample city data to get started quickly.

Try Sample Query

🔧

Database Admin

Manage your PostgreSQL database with pgAdmin interface.

Open pgAdmin

URL Format

This API uses clean, simplified URLs that follow ArcGIS Server conventions:

🎯

URL Structure

All endpoints follow this simple pattern:

                        /arcgis/rest/services/{schema.table}/FeatureServer/{layer}/
                    

Example: /arcgis/rest/services/public.cities/FeatureServer/0/

Available Endpoints

GET /arcgis/rest/info

GET /arcgis/rest/generateToken

GET /arcgis/rest/services/:id/FeatureServer

GET /arcgis/rest/services/:id/FeatureServer/layers

GET /arcgis/rest/services/:id/FeatureServer/:layer

GET /arcgis/rest/services/:id/FeatureServer/:layer/query

GET /arcgis/rest/services/:id/FeatureServer/:layer/generateRenderer

GET /arcgis/rest/services/:id/FeatureServer/:layer/queryRelatedRecords

🔗 Relationship Queries

This provider automatically detects PostgreSQL foreign key relationships and exposes them as ArcGIS-compatible relationship queries. Perfect for exploring related data like buildings at locations, infrastructure details, and points of interest.

🏢

Buildings Relationship

Get all buildings associated with specific locations

Location 1 Buildings Multiple Locations

🚧

Infrastructure Relationship

Query infrastructure records related to locations

Location Infrastructure All Fields

🌍

Land Use Relationship

Get land use information for specific locations

Land Use Data With Geometry

📍

Points of Interest

Find points of interest related to locations

POI for Location 1 Historic POIs

🔍

Filtered Relationships

Use definition expressions to filter related records

Commercial Buildings Tall Buildings

📊

Relationship Discovery

Discover available relationships and their metadata

Layer Relationships Service Info

💡

ArcGIS Client Integration

These relationship queries work seamlessly with ArcGIS clients:

✅ ArcGIS Map Viewer - Use "Related Data" buttons in pop-ups
✅ ArcGIS Pro - Right-click layers → "View Related Data"
✅ ArcGIS Desktop - Relationship queries in attribute tables
✅ ArcGIS Enterprise - Full relationship support

Add your service URL to any ArcGIS client to automatically discover and use relationships!

FeatureServer Test URLs

🏢

Service Metadata

Get service information, layers, and capabilities

Service Info All Layers

📊

Layer Information

Layer schema, geometry type, and field definitions

Layer Details Layer Info

🔍

Basic Queries

Simple feature queries with different parameters

All Features GeoJSON Format

🎯

WHERE Clause Queries

Filter features using SQL WHERE conditions

Large Cities Name Filter

📍

Spatial Queries

Query features using bounding box filters

World Bbox NYC Area

📄

Pagination & Sorting

Control result sets with pagination and ordering

First 10 Top 5 by Pop

🎨

Rendering Info

Generate rendering information for the layer

Generate Renderer Layer Schema

🔗

Field Operations

Work with specific fields and return formats

Select Fields IDs Only

🔐

Authentication & Tokens

Test authentication and token generation endpoints

Service Info Generate Token

🔄

Output Formats

Test different output formats supported by the service

JSON GeoJSON

⚡

Advanced Queries

Complex queries with multiple parameters and conditions

Complex Query USA Cities

Vector Tile Server

GET /arcgis/rest/services/:id/VectorTileServer

GET /arcgis/rest/services/:id/VectorTileServer/:z/:x/:y.pbf

GET /arcgis/:id/VectorTileServer/tiles.json

GET /arcgis/:id/VectorTileServer/:z/:x/:y.pbf

🗺️

Vector Tile Service

Access vector tiles for high-performance mapping applications

Service Info TileJSON

🎯

Sample Tiles

Test vector tile endpoints with sample coordinates

World Tile (0/0/0) Sample Tile