Setting Up Transaction to GIS Attributes Mapping

Your agency can export transaction and inspection location information for display on an ESRI map. Define and manage the mapping of transaction and inspection attributes to GIS attributes to export data to the map layer on the Transaction to GIS Attributes Mappings page.

The agency sets up the system like this to export transaction and inspection attributes to the map layer:

1. Your agency must use an editable feature service so that exported data can be written on the map layer. Set up the feature service on the GIS Feature Services page.

   For more information, see Setting Up GIS Feature Services.

2. Use the Transaction to GIS Attributes Mappings setup pages to map the GIS attributes that you want to get transaction and inspection data for.

   See the next section in this topic, "Mapping Required Attributes."

3. A scheduled action in the Business Rules Framework exports the data to the GIS layer using the latest mapping definitions. Set up a GIS export action in the Business Rules Framework to export the mapped data.

   For more information, see Setting Up Export GIS Data Actions.

Mapping Required Attributes

Your agency defines the mapping between the transaction attributes and respective GIS attributes so that the agency can send the permit transaction data to an Esri map layer.

Here's how to define and manage the mapping of transaction data to GIS attributes:

1. Access setup through the Functional Setup Manager by selecting Setup and Maintenance > Setup: Public Sector <Offering> > GIS > Manage Transaction to GIS Attributes Mappings.

2. On the Transaction to GIS Attributes Mappings page, click the + Add button.

3. On the New transaction to GIS attributes mapping drawer, enter this information:

   Page Element	Description
   Offering	Select the offering for mapping attributes: Business Licenses Code Enforcement Permits Planning and Zoning
   Mapping Name and Description	Enter a short name and description for the mapping.
   Feature Service	Enter an editable feature service so that exported data can be written on the map layer.
   Layer	Select a specific layer from the list of layers associated with the feature service. Use this layer to map the respective GIS attributes to transaction or inspection attributes. This is the layer where the attribute data resides after it has been exported using the transaction to GIS attributes mapping definition.
   Resource	Select a resource associated with the selected offering for mapping definitions. These resources are used by the Business Rules Framework to export GIS data: Business Licenses offering: Business License Inspection or Business Licenses Permits offering: Permit Inspection or Permits Workflow Communications Code Enforcement offering: Code Enforcement Case or Code Enforcement Incident Planning and Zoning offering: Planning and Zoning Workflow Communications For more information, see Setting Up Export GIS Data Actions.
   Transaction Type	Select from the available transaction types based on the selected offering. Use this option to select a transaction type if you want to map custom attributes defined for that transaction type along with the standard transaction attributes. This option isn't available when you select the inspection-related resource for the Business Licenses or Permits offering.

4. Each mapping must identify the record key or inspection key, latitude, and longitude values for the location of the transaction or inspection.

   In the Map required attributes section, enter GIS attributes for these required attributes:

   • Record Key or Inspection Key

   • Latitude

   • Longitude

5. Once you click Save to save the required attributes that you entered, the Map additional attributes section appears. You can map transaction attributes from all of the standard and global or reusable attributes exposed by the selected resource to a GIS attribute.

6. Turn on the Show only mapped attributes switch to hide attributes that aren't mapped. Turning off the switch displays all of the GIS attributes from the map layer whether they are mapped or not.

7. Turn on the Enable switch in the Map additional attributes section to enable the mapping for use in the Business Rules Framework, where you configure the action to export the attribute data to the GIS layer.

8. Click Save.

Saved mapping definitions appear on the Transaction to GIS Attributes Mappings page. You can also manage the mapping definitions like this:

• Click the mapping row in the table to open the Transaction to GIS attributes mapping details drawer. You can save updates to attributes in the mapping definition.

• Although you can't delete a mapping, you can disable it.

• Enter key words in the Search field to find matching mapping definitions.

• Click the Export button to download a list of mapping definitions on the page.

Caution:

Oracle highly recommends not deleting GIS attributes in the respective map layer after transaction to GIS attribute mapping.

If the feature service is already associated with a mapping definition, updating or removing the feature service will affect the associated map. If you delete a GIS attribute on the ESRI layer after mapping and the GIS attribute was already mapped to a transaction attribute, then when you access the mapping again, the respective row indicates that the attribute is deleted in GIS.