SmcConnect Data Mapping

Overview

SmcConnect data are provided in 10 .csv files. Files should be named as follows:

1. locations.csv
2. mail_addresses.csv
3. organizations.csv
4. phones.csv
5. addresses.csv
6. regular_schedules.csv
7. holiday_schedules.csv
8. services.csv
9. contacts.csv
10. programs.csv

Data can be provided in .json files as well.

Locations

Provider field	Example value	Mapped to
id	1028	used to detect relationships
name	Health Center	Location.name
alternate_name	H. C.	Location.alternateName
description	Offers treatment to people in need	Location.description
transportation	Provided by parents	Location.transportation
latitude	100.2303332932	considered as Double and mapped to Location.latitude
longitude	-46.3231233213	considered as Double and mapped to Location.longitude
organization_id	1500	used to detect relationships
accessibility	wheelchair	ignored
admin_emails	[email protected]	ignored
email	[email protected]	ignored
hours	Monday-Friday, 9-11	ignored
kind	Other	ignored
languages	French, Spanish	Split by "," and each mapped to Language.language
market_name	false	ignored
virtual	false	ignored
website	http://www.example.org	ignored
short_desc	Offers information	ignored
products	Emergency Services, Credit	ignored
payments	Vegetables, Eggs	ignored

Mail Addresses

Provider field	Example value	Mapped to
id	423423	used to detect relationships
address_1	150 Super Street	PostalAddress.address1
city	San Francisco	PostalAddress.city
state_province	CA	PostalAddress.stateProvince
postal_code	90909	PostalAddress.postalCode
country	US	PostalAddress.country
location_id	3123213	used to detect relationships
attention	Health Clinic	PostalAddress.attention
address_2	suite 50	ignored

Organizations

Provider field	Example value	Mapped to
id	1028	used to detect relationships
website	http://example.com	Organization.url
name	The organization	Organization.name
alternate_name	Org	Organization.alternateName
description	Helps with problems	Organization.description
email	[email protected]	Organization.email
tax_status	43217(c)(3)	Organization.taxStatus
tax_id	484-4434943	Organization.taxId
legal_status	non-profit	Organization.legalStatus
date_incorporated	March 14, 1987	if not empty, mapped to Organization.yearIncorporated, with pattern "MMMM dd, yyyy"
funding_sources	Donations, Grants	if not empty, mapped to Funding.source
accreditations	babies, pets	ignored
licenses	License of California	ignored

Phones

Provider field	Example value	Mapped to
id	1028	used to detect relationships
extension	655	Phone.extension
type	voice	Phone.type
country_prefix	no info	added as a prefix to Phone.number, with space between
number	489 434-3892	Phone.number
contact_id	4432423	ignored
location_id	493249823	used to detect relationships
organization_id	24320	used to detect relationships
service_id	39323	used to detect relationships
department	Building	ignored
vanity_number	800-333-DLSN	ignored

Addresses

Provider field	Example value	Mapped to
id	423423	used to detect relationships
address_1	150 Super Street	PhysicalAddress.address1
city	San Francisco	PhysicalAddress.city
state_province	CA	PhysicalAddress.stateProvince
postal_code	90909	PhysicalAddress.postalCode
country	US	PhysicalAddress.country
location_id	3123213	used to detect relationships
address_2	suite 50	ignored

Regular Schedules

Provider field	Example value	Mapped to
id	1028	used to detect relationships
opens_at	09:00	OpeningHours.opensAt
closes_at	14:00	OpeningHours.closesAt
weekday	Monday	proper number of OpeningHours.weekday (assuming that possible values are Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday)
service_id	434234	used to detect relationships, groups of related entities are then associated with new RegularSchedule entry
location_id	4324	used to detect relationships, groups of related entities are then associated with new RegularSchedule entry

Holiday Schedules

Provider field	Example value	Mapped to
id	1028	used to detect relationships
opens_at	09:00	HolidaySchedule.opensAt
closes_at	14:00	HolidaySchedule.closesAt
closed	true	considered as Boolean an mapped to HolidaySchedule.closed
service_id	434234	used to detect relationships
location_id	4324	used to detect relationships
start_date	March 14, 0001	mapped to Organization.yearIncorporated, with pattern "MMMM dd, 00yy"
end_date	March 14, 0001	mapped to Organization.yearIncorporated, with pattern "MMMM dd, 00yy"

Services

Provider field	Example value	Mapped to
id	1028	used to detect relationships
name	The Service	Service.name
alternate_name	Service	Service.alternateName
description	Food	Service.description
email	[email protected]	Service.email
status	active	Service.status
interpretation_services	Women	Service.interpretationServices
application_process	Apply by phone	Service.applicationProcess
wait_time	No wait	Service.waitTime
fees	$56 per year	Service.fees
required_documents	Picture identification	if not empty, added as a postfix to Service.application process, preceded with " Required documents: "
eligibility	None	Eligibility.eligibility
funding_sources	Donations, Fees	Funding.sources
languages	Spanish	Split by "," and each mapped to Language.language
location_id	54534	used to detect relationships
accepted_payments	Cash, Credit Card	ignored
audience	All	ignored
keywords	ADULT Museums	ignored
service_areas	CA County	ignored
website	http://www.org.com	url
taxonomy_ids	300, 200	ignored

Contacts

Provider field	Example value	Mapped to
id	1028	used to detect relationships
name	John Doe	Contact.name
title	President, CEO	Contact.title
department	City Council	Contact.department
email	[email protected]	Contact.email
location_id	3847	used to detect relationships
organization_id	8493	used to detect relationships
service_id	48393	used to detect relationships

Programs

Provider field	Example value	Mapped to
id	1028	used to detect relationships
name	PP	Program.name
alternate_name	Program P	Program.alternateName
organization_id	8493	used to detect relationships

Entities relationships

To ensure all required relationships between entities are set, each of them is listed below.

• Each Language has a reference to the Service or Location
• Eligibility has a reference to the Service
• Each Phone has a reference to the Service
• PhysicalAddress has a reference to the Location
• PostalAddress has a reference to the Location
• Service has a reference to the Organization
• Organization has a reference to the Location and the Source Document
• Each OpeningHours has a reference to the RegularSchedule
• RegularSchedule has a reference to the Serivce or Location
• Funding has a reference to the Service or Organization
• Each Contact has a reference to the Service or Organization
• Each Program has a reference to the Organization
• HolidaySchedule has reference to the Service or Location