Name: PDI_Project_Template_v2

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"PDI Project Template v2","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field:

Fields:

• objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• proj_name (type: esriFieldTypeString, alias: Work Request Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• subproj_name (type: esriFieldTypeString, alias: Sub Work Request Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• briefproj_name (type: esriFieldTypeString, alias: Brief Work Request/Sub Work Request Name (unique identifier for display on charts, < 40 chars):, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• fullproj_name (type: esriFieldTypeString, alias: Concatenated Work Request/Sub Work Request Name, SQL Type: sqlTypeOther, length: 520, nullable: true, editable: true)
• projdesc (type: esriFieldTypeString, alias: Work Request Description:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• workorder (type: esriFieldTypeString, alias: Work Order:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submittername (type: esriFieldTypeString, alias: Project Coordinator submitting proposal:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submitterfullname (type: esriFieldTypeString, alias: Submitter Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submitterfirst (type: esriFieldTypeString, alias: Submitter First Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submitterlast (type: esriFieldTypeString, alias: Submitter Last Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• submitteremail (type: esriFieldTypeString, alias: Submitter Email:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• scientistfullname (type: esriFieldTypeString, alias: Principal Investigator Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• scientistfirst (type: esriFieldTypeString, alias: Principal Investigator First Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• scientistlast (type: esriFieldTypeString, alias: Principal Investigator Last Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• scientistaffiliation (type: esriFieldTypeString, alias: Principal Investigator Institution:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• scientistemail (type: esriFieldTypeString, alias: Principal Investigator Email Address:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• data_custodianfullname (type: esriFieldTypeString, alias: Data Custodian Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• data_custodianfirst (type: esriFieldTypeString, alias: Data Custodian First Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• data_custodianlast (type: esriFieldTypeString, alias: Data Custodian Last Name:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• data_custodianemail (type: esriFieldTypeString, alias: Data Custodian Email:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• subdate (type: esriFieldTypeDate, alias: Date of Original Submission:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techresource (type: esriFieldTypeString, alias: Will this project be assigned to the tech team or to an external resource?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techreviewer (type: esriFieldTypeString, alias: Which tech team member will review this project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techrevieweremail (type: esriFieldTypeString, alias: Tech Team Member Email:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techreviewerdate (type: esriFieldTypeDate, alias: Date Tech Team Member Assigned:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• producttype (type: esriFieldTypeString, alias: What type of tool or product is to be created (select all that apply)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• toolupdate (type: esriFieldTypeString, alias: Is this tool an update or revision of an existing PDI tool?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tooldescription (type: esriFieldTypeString, alias: Describe the required tool in detail:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• deliverables (type: esriFieldTypeString, alias: Describe the specific deliverables for the project, e.g., "data collection tool described above along with associated database templates":, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• dataformat (type: esriFieldTypeString, alias: In what format is data stored or to be stored (select all that apply)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• otherdatadetails (type: esriFieldTypeString, alias: Describe other data characteristics:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• privacy (type: esriFieldTypeString, alias: Will this data be kept private or made publicly accessible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• stakeholder (type: esriFieldTypeString, alias: Will this tool support internal or external stakeholders, or both?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• toolneed (type: esriFieldTypeString, alias: Explain how this tool will improve efficiency or expand data utility/availability:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• targetdate (type: esriFieldTypeDate, alias: Target date for tool availability:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• readiness (type: esriFieldTypeString, alias: If approved, how soon will you be ready to discuss your project in depth with the Tech Team?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• internalsource (type: esriFieldTypeString, alias: Describe internal funding source(s):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• internalfunds (type: esriFieldTypeDouble, alias: Total funding from internal source(s):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• externalsource (type: esriFieldTypeString, alias: Describe external funding source(s):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• externalfunds (type: esriFieldTypeDouble, alias: Total funding from external source(s):, SQL Type: sqlTypeOther, nullable: true, editable: true)
• techfollowup (type: esriFieldTypeString, alias: If you have received a request for additional information from the Tech Team, please revise the preceding sections of the proposal accordingly and summarize those revisions here:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• techresponder (type: esriFieldTypeString, alias: Project Coordinator responding to tech comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techfollowdate (type: esriFieldTypeDate, alias: Date of response to tech comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• boardfollowup (type: esriFieldTypeString, alias: If you have received a request for additional information from the Board, please respond here (DO NOT make changes to the original proposal):, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• boardresponder (type: esriFieldTypeString, alias: Project Coordinator responding to Board comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• boardfollowdate (type: esriFieldTypeDate, alias: Date of response to Board comments:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techreviewdate (type: esriFieldTypeDate, alias: Date of technical review:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reviewready (type: esriFieldTypeString, alias: Is this proposal detailed, feasible, and ready for Board review?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techquery (type: esriFieldTypeString, alias: Please detail what factors prevent recommending this proposal for Board review and specify what changes or additional information would make the proposal suitable for Board review:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• completetime (type: esriFieldTypeString, alias: Please provide an estimate of the time (in weeks) required to complete the proposed project, assuming tech team resources are available:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• addresource (type: esriFieldTypeString, alias: Please select additional PDI (second tech team member, developer) or external (ESRI, MS) resources that you believe will be required to complete the project:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• resourcedesc (type: esriFieldTypeString, alias: Please provide further explanation of additional resources required:, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• techcomments (type: esriFieldTypeString, alias: Please provide any other comments that may help inform the Board's review:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• approvername (type: esriFieldTypeString, alias: Board member entering decision:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reviews (type: esriFieldTypeSmallInteger, alias: Number of Reviews:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• approved (type: esriFieldTypeString, alias: Is this project approved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• declinereason (type: esriFieldTypeString, alias: Please select the reason for not approving this project:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• declinebasis (type: esriFieldTypeString, alias: Please provide further information on the basis for not approving the project and/or detail any changes to the proposal that would allow reconsideration for approval:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• meanscore (type: esriFieldTypeDouble, alias: Mean Evaluator Score:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• finalscore (type: esriFieldTypeDouble, alias: Final Priority Score:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• approvaldate (type: esriFieldTypeDate, alias: Date of approval/disapproval decision:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• priority (type: esriFieldTypeString, alias: What priority level is assigned to this project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• assignee (type: esriFieldTypeString, alias: Project Coordinator:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• coorddate (type: esriFieldTypeDate, alias: Date project coordinator assigned:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: Location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• projowner (type: esriFieldTypeString, alias: Which tech team member will have responsibility for this project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• techdate (type: esriFieldTypeDate, alias: Date tech team member assigned:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• agcros (type: esriFieldTypeString, alias: How will project connect to AgCROS?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• furtherinfo (type: esriFieldTypeString, alias: Is further information required prior to commencing work on this project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• infodetail (type: esriFieldTypeString, alias: Please detail what additonal information is required in order to commence work on this project:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• startdate (type: esriFieldTypeDate, alias: Start Work Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• statusdate (type: esriFieldTypeDate, alias: Date Current Status Assigned:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Current status:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• statusnotes (type: esriFieldTypeString, alias: Notes regarding current status:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• finalstatus (type: esriFieldTypeString, alias: Final project status:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• enddate (type: esriFieldTypeDate, alias: Final Status Date:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• completeactions (type: esriFieldTypeString, alias: Please provide details regarding further actions needed for completion:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• cancelreason (type: esriFieldTypeString, alias: Please provide details regarding why the project was cancelled:, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• extratext1 (type: esriFieldTypeString, alias: extratext1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext2 (type: esriFieldTypeString, alias: extratext2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext3 (type: esriFieldTypeString, alias: extratext3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext4 (type: esriFieldTypeString, alias: extratext4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext5 (type: esriFieldTypeString, alias: extratext5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext6 (type: esriFieldTypeString, alias: extratext6, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext7 (type: esriFieldTypeString, alias: extratext7, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext8 (type: esriFieldTypeString, alias: extratext8, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext9 (type: esriFieldTypeString, alias: extratext9, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratext10 (type: esriFieldTypeString, alias: extratext10, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extratextlong1 (type: esriFieldTypeString, alias: extratextlong1, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• extratextlong2 (type: esriFieldTypeString, alias: extratextlong2, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• extratextlong3 (type: esriFieldTypeString, alias: extratextlong3, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• extratextlong4 (type: esriFieldTypeString, alias: extratextlong4, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• extratextlong5 (type: esriFieldTypeString, alias: extratextlong5, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• extradouble1 (type: esriFieldTypeDouble, alias: extradouble1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• extradouble2 (type: esriFieldTypeDouble, alias: extradouble2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• extradouble3 (type: esriFieldTypeDouble, alias: extradouble3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• extradouble4 (type: esriFieldTypeDouble, alias: extradouble4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• extradouble5 (type: esriFieldTypeDouble, alias: extradouble5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• extradate1 (type: esriFieldTypeDate, alias: extradate1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extradate2 (type: esriFieldTypeDate, alias: extradate2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extradate3 (type: esriFieldTypeDate, alias: extradate3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extradate4 (type: esriFieldTypeDate, alias: extradate4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• extradate5 (type: esriFieldTypeDate, alias: extradate5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/6/2024 5:30:58 PM

Schema Last Edit Date: 3/6/2024 5:30:58 PM

Data Last Edit Date: 3/6/2024 5:30:58 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat