Download project data

[steveoh]

Allow map viewers and parent application code to download specific projects by id.

Tasks

• Place a mobile friendly download component on the mapping interface when viewing a specific project
• Allow a file geodatabase to be created for the project.
• Create a backend tool to generate downloads (currently a GP tool)

Dependencies

This tool may be used by DTS in other places and should accept multiple project id's. Coordinate with DTS if this has any breaking changes.

File geodatabase fields

For multipoint feature types include

• ('TypeDescription', 'TEXT', 'NULLABLE', 255)
• ('FeatureID', 'SHORT', 'NON_NULLABLE')
• ('FeatureSubTypeDescription', 'TEXT', 'NULLABLE', 255)
• ('ActionDescription', 'TEXT', 'NULLABLE', 255)
• ('Description', 'TEXT', 'NULLABLE', 255)
• 'Project_ID', 'SHORT', 'NON_NULLABLE')
• ('StatusDescription', 'TEXT', 'NULLABLE', 50)
• ('Composite_Key', 'TEXT', 'NON_NULLABLE', 255)
• ('Shape@',)

For polyline feature types include

• ('TypeDescription', 'TEXT', 'NULLABLE', 255)
• ('FeatureID', 'SHORT', 'NON_NULLABLE')
• ('FeatureSubTypeDescription', 'TEXT', 'NULLABLE', 255)
• ('ActionDescription', 'TEXT', 'NULLABLE', 255)
• ('Description', 'TEXT', 'NULLABLE', 255)
• ('Project_ID', 'SHORT', 'NON_NULLABLE')
• ('StatusDescription', 'TEXT', 'NULLABLE', 50)
• ('Composite_Key', 'TEXT', 'NON_NULLABLE', 255)
• ('Shape@',)

For polygon features include

• ('TypeDescription', 'TEXT', 'NULLABLE', 255)
• ('FeatureID', 'SHORT', 'NON_NULLABLE')
• ('Project_ID', 'SHORT', 'NON_NULLABLE')
• ('StatusDescription', 'TEXT', 'NULLABLE', 50)
• ('Retreatment', 'TEXT', 'NULLABLE', 1)
• ('Composite_Key', 'TEXT', 'NON_NULLABLE', 255)
• ('Shape@',)

Add the following related table for the above 3 types

COUNTY

• ('County', 'TEXT', 'NULLABLE', 255)
• ('CountyInfoID', 'SHORT', 'NON_NULLABLE')
• ('FeatureID', 'SHORT', 'NON_NULLABLE')
• ('County_ID', 'LONG', 'NON_NULLABLE')
• ('Intersection', 'FLOAT', 'NULLABLE')
• ('Composite_Key', 'TEXT', 'NON_NULLABLE', 255)]

For terrestrial and aquatic polygon feature types include the following related tables

AREAACTION

• ('ActionDescription', 'TEXT', 'NULLABLE', 255)
• ('AreaActionID', 'SHORT', 'NON_NULLABLE')
• ('FeatureID', 'SHORT', 'NON_NULLABLE')

AREATREATMENT

• ('TreatmentTypeDescription', 'TEXT', 'NULLABLE', 255)
• ('AreaTreatmentID', 'SHORT', 'NON_NULLABLE')
• ('AreaActionID', 'SHORT', 'NON_NULLABLE')

If the treatment has an herbicide

AREAHERBICIDE

• ('HerbicideDescription', 'TEXT', 'NULLABLE', 255)
• ('AreaHerbicideID', 'SHORT', 'NON_NULLABLE')
• ('AreaTreatmentID', 'SHORT', 'NON_NULLABLE')
• ('HerbicideID', 'SHORT', 'NULLABLE')

Improvements

• Add a PROJECT point table with the centroid geometry as well as basic project information e.g. name and description

Previous implementation

References

• Design for small screens #15