postgres:
connection_string: postgresql://postgres:password@localhost:5432/postgres
auto_publish: true
tables:
static_feeds:
schema: gtfs
table: static_feeds
srid: 4326
geometry_column: hull
bounds:
- -158.22903
- -35.8747155
- 145.252557
- 64.89969635009766
extent: 4096
buffer: 64
clip_geom: true
geometry_type: POLYGON
properties:
max_lat: float8
max_lon: float8
min_lat: float8
min_lon: float8
onestop_feed_id: text
only_realtime_ref: text
operators: text
operators_to_gtfs_ids: hstore
realtime_onestop_ids: text
realtime_onestop_ids_to_gtfs_ids: hstore
shapes:
schema: gtfs
table: shapes
srid: 4326
geometry_column: linestring
bounds:
- -158.22903
- -35.8747155
- 145.252557
- 64.89969635009766
extent: 4096
buffer: 64
clip_geom: true
geometry_type: LINESTRING
properties:
color: text
onestop_feed_id: text
route_label: text
route_type: int4
routes: text[]
shape_id: text
text_color: text
stops:
schema: gtfs
table: stops
srid: 4326
geometry_column: point
bounds:
- -158.228463
- -35.8738929
- 145.287201336112
- 64.8996653247773
extent: 4096
buffer: 64
clip_geom: true
geometry_type: POINT
properties:
code: text
gtfs_desc: text
gtfs_id: text
level_id: text
location_type: int4
name: text
onestop_feed_id: text
parent_station: text
platform_code: text
timezone: text
url: text
wheelchair_boarding: int4
zone_id: text
route_types: smallint[]
routes: text[]
children_ids: text[]
children_route_types: smallint[]
stoptimes:
schema: gtfs
table: stoptimes
srid: 4326
geometry_column: point
bounds:
- -158.228463
- -35.5790842
- 145.287201336112
- 64.89947422493645
extent: 4096
buffer: 64
clip_geom: true
geometry_type: POINT
properties:
arrival_time: int8
continuous_drop_off: int4
continuous_pickup: int4
departure_time: int8
drop_off_type: int4
onestop_feed_id: text
pickup_type: int4
route_id: text
shape_dist_traveled: float8
stop_headsign: text
stop_id: text
stop_sequence: int4
timepoint: int4
trip_id: text
functions:
busonly:
# Schema name (required)
schema: gtfs
# Function name (required)
function: busonly
# An integer specifying the minimum zoom level
minzoom: 6
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
notbus:
# Schema name (required)
schema: gtfs
# Function name (required)
function: notbus
# An integer specifying the minimum zoom level
minzoom: 3
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
localrail:
# Schema name (required)
schema: gtfs
# Function name (required)
function: localrail
# An integer specifying the minimum zoom level
minzoom: 3
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
intercityrail:
# Schema name (required)
schema: gtfs
# Function name (required)
function: intercityrail
# An integer specifying the minimum zoom level
minzoom: 3
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
other:
# Schema name (required)
schema: gtfs
# Function name (required)
function: other
# An integer specifying the minimum zoom level
minzoom: 3
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
busstops:
# Schema name (required)
schema: gtfs
# Function name (required)
function: busstops
# An integer specifying the minimum zoom level
minzoom: 6
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
stationfeatures:
# Schema name (required)
schema: gtfs
# Function name (required)
function: stationfeatures
# An integer specifying the minimum zoom level
minzoom: 7
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
railstops:
# Schema name (required)
schema: gtfs
# Function name (required)
function: railstops
# An integer specifying the minimum zoom level
minzoom: 3
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds:
otherstops:
# Schema name (required)
schema: gtfs
# Function name (required)
function: otherstops
# An integer specifying the minimum zoom level
minzoom: 3
# An integer specifying the maximum zoom level. MUST be >= minzoom
maxzoom: 30
# The maximum extent of available map tiles. Bounds MUST define an area
# covered by all zoom levels. The bounds are represented in WGS:84
# latitude and longitude values, in the order left, bottom, right, top.
# Values may be integers or floating point numbers.
bounds: