Recreation

Tables in the Recreation connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	permits	15
2	activities	4		Full Refresh
3	organizations	10		Full Refresh
4	recreationareas	26		Full Refresh
5	links	7		Full Refresh
6	media	15		Full Refresh
7	facilities	33		Full Refresh
8	tours	12		Full Refresh
9	events	3		Full Refresh
10	facilityaddresses	11		Full Refresh
11	campsites	14		Full Refresh
12	recreationareaaddresses	11		Full Refresh

Table: permits

No	Column Name	Type	Notes
1	LastUpdatedDate	VARCHAR
2	ATTRIBUTES	VARCHAR
3	PermitEntranceName	VARCHAR
4	Latitude	INTEGER
5	PermitEntranceDescription	VARCHAR
6	Longitude	INTEGER
7	FacilityID	VARCHAR
8	Town	VARCHAR
9	ENTITYMEDIA	VARCHAR
10	CreatedDate	VARCHAR
11	PermitEntranceID	VARCHAR
12	PermitEntranceAccessible	BOOLEAN
13	District	VARCHAR
14	ZONES	VARCHAR
15	GEOSJON	VARCHAR

Table: activities

No	Column Name	Type	Notes
1	ActivityParentID	INTEGER
2	ActivityName	VARCHAR
3	ActivityID	INTEGER
4	ActivityLevel	INTEGER

Table: organizations

No	Column Name	Type	Notes
1	LastUpdatedDate	VARCHAR
2	OrgID	VARCHAR
3	OrgImageURL	VARCHAR
4	OrgType	VARCHAR
5	OrgJurisdictionType	VARCHAR
6	OrgName	VARCHAR
7	OrgURLText	VARCHAR
8	OrgAbbrevName	VARCHAR
9	OrgURLAddress	VARCHAR
10	OrgParentID	VARCHAR

Table: recreationareas

No	Column Name	Type	Notes
1	LastUpdatedDate	VARCHAR
2	Keywords	VARCHAR
3	RECAREAADDRESS	VARCHAR
4	GEOJSON	VARCHAR
5	RecAreaLongitude	DOUBLE
6	StayLimit	VARCHAR
7	EVENT	VARCHAR
8	ORGANIZATION	VARCHAR
9	RecAreaMapURL	VARCHAR
10	RecAreaID	VARCHAR
11	OrgRecAreaID	VARCHAR
12	MEDIA	VARCHAR
13	LINK	VARCHAR
14	RecAreaDescription	VARCHAR
15	ParentOrgID	VARCHAR
16	FACILITY	VARCHAR
17	Enabled	BOOLEAN
18	RecAreaName	VARCHAR
19	RecAreaPhone	VARCHAR
20	RecAreaFeeDescription	VARCHAR
21	Reservable	BOOLEAN
22	RecAreaEmail	VARCHAR
23	RecAreaDirections	VARCHAR
24	RecAreaLatitude	DOUBLE
25	ACTIVITY	VARCHAR
26	RecAreaReservationURL	VARCHAR

Table: links

No	Column Name	Type	Notes
1	EntityID	VARCHAR
2	EntityType	VARCHAR
3	Description	VARCHAR
4	Title	VARCHAR
5	LinkType	VARCHAR
6	EntityLinkID	VARCHAR
7	URL	VARCHAR

Table: media

No	Column Name	Type	Notes
1	Description	VARCHAR
2	IsGallery	BOOLEAN
3	Title	VARCHAR
4	EmbedCode	VARCHAR
5	URL	VARCHAR
6	EntityID	VARCHAR
7	EntityType	VARCHAR
8	Subtitle	VARCHAR
9	IsPreview	BOOLEAN
10	Credits	VARCHAR
11	IsPrimary	BOOLEAN
12	MediaType	VARCHAR
13	Height	INTEGER
14	Width	INTEGER
15	EntityMediaID	VARCHAR

Table: facilities

No	Column Name	Type	Notes
1	LastUpdatedDate	VARCHAR
2	FacilityReservationURL	VARCHAR
3	Keywords	VARCHAR
4	FacilityLongitude	DOUBLE
5	GEOJSON	VARCHAR
6	StayLimit	VARCHAR
7	FacilityName	VARCHAR
8	EVENT	VARCHAR
9	ORGANIZATION	VARCHAR
10	FacilityID	VARCHAR
11	FacilityUseFeeDescription	VARCHAR
12	PERMITENTRANCE	VARCHAR
13	FacilityDescription	VARCHAR
14	LINK	VARCHAR
15	MEDIA	VARCHAR
16	LegacyFacilityID	VARCHAR
17	ParentOrgID	VARCHAR
18	FacilityTypeDescription	VARCHAR
19	CAMPSITE	VARCHAR
20	FacilityLatitude	DOUBLE
21	FacilityEmail	VARCHAR
22	Enabled	BOOLEAN
23	FACILITYADDRESS	VARCHAR
24	ParentRecAreaID	VARCHAR
25	RECAREA	VARCHAR
26	FacilityMapURL	VARCHAR
27	Reservable	BOOLEAN
28	FacilityDirections	VARCHAR
29	FacilityPhone	VARCHAR
30	FacilityAdaAccess	VARCHAR
31	ACTIVITY	VARCHAR
32	OrgFacilityID	VARCHAR
33	TOUR	VARCHAR

Table: tours

No	Column Name	Type	Notes
1	TourDuration	INTEGER
2	LastUpdatedDate	VARCHAR
3	ATTRIBUTES	VARCHAR
4	FacilityID	VARCHAR
5	TourDescription	VARCHAR
6	ENTITYMEDIA	VARCHAR
7	CreatedDate	VARCHAR
8	TourID	VARCHAR
9	TourType	VARCHAR
10	TourAccessible	BOOLEAN
11	MEMBERTOURS	VARCHAR
12	TourName	VARCHAR

Table: events

No	Column Name	Type	Notes
1	ResourceLink	VARCHAR
2	EventID	VARCHAR
3	EventName	VARCHAR

Table: facilityaddresses

No	Column Name	Type	Notes
1	LastUpdatedDate	VARCHAR
2	FacilityID	VARCHAR
3	FacilityStreetAddress1	VARCHAR
4	AddressCountryCode	VARCHAR
5	FacilityStreetAddress2	VARCHAR
6	FacilityStreetAddress3	VARCHAR
7	FacilityAddressType	VARCHAR
8	PostalCode	VARCHAR
9	FacilityAddressID	VARCHAR
10	City	VARCHAR
11	AddressStateCode	VARCHAR

Table: campsites

No	Column Name	Type	Notes
1	Loop	VARCHAR
2	LastUpdatedDate	VARCHAR
3	ATTRIBUTES	VARCHAR
4	CampsiteLongitude	DOUBLE
5	CampsiteName	VARCHAR
6	TypeOfUse	VARCHAR
7	CampsiteLatitude	DOUBLE
8	FacilityID	VARCHAR
9	PERMITTEDEQUIPMENT	VARCHAR
10	ENTITYMEDIA	VARCHAR
11	CampsiteID	VARCHAR
12	CampsiteType	VARCHAR
13	CreatedDate	VARCHAR
14	CampsiteAccessible	BOOLEAN

Table: recreationareaaddresses

No	Column Name	Type	Notes
1	LastUpdatedDate	VARCHAR
2	AddressCountryCode	VARCHAR
3	RecAreaAddressID	VARCHAR
4	RecAreaID	VARCHAR
5	RecAreaStreetAddress2	VARCHAR
6	RecAreaAddressType	VARCHAR
7	RecAreaStreetAddress3	VARCHAR
8	RecAreaStreetAddress1	VARCHAR
9	PostalCode	VARCHAR
10	City	VARCHAR
11	AddressStateCode	VARCHAR

External Resources

• Recreation Api
• Here

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.