Name: FinalInspectionsRT

Display Field: ProjectName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 8e8eff8d62f54fe0a360187e229d7033

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• RelatedGlobalID ( type: esriFieldTypeGUID, alias: RelatedGlobalID, length: 38 )
• DateOfFinalInspection ( type: esriFieldTypeDate, alias: Date Of Inspection Or Review, length: 8 )
• NotesConcerns ( type: esriFieldTypeString, alias: Notes & Concerns, length: 1000 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, length: 254 )
• ShawnJorgensenTime ( type: esriFieldTypeDouble, alias: Shawn Jorgensen Time )
• PaulTaylorTime ( type: esriFieldTypeDouble, alias: Paul Taylor Time )
• EdRobertsTime ( type: esriFieldTypeDouble, alias: Ed Roberts Time )
• KevinTaylorTime ( type: esriFieldTypeDouble, alias: Kevin Taylor Time )
• BartMorrillTime ( type: esriFieldTypeDouble, alias: Bart Morrill Time )
• JohnWatersTime ( type: esriFieldTypeDouble, alias: John Waters Time )
• BryanGraceTime ( type: esriFieldTypeDouble, alias: Bryan Grace Time )
• CoryPierceTime ( type: esriFieldTypeDouble, alias: Cory Pierce Time )
• BostonBradfordTime ( type: esriFieldTypeDouble, alias: Boston Bradford Time )
• BryceJacksonTime ( type: esriFieldTypeDouble, alias: Bryce Jackson Time )
• JamieChappelTime ( type: esriFieldTypeDouble, alias: Jamie Chappel Time )
• RickHawkinsTime ( type: esriFieldTypeDouble, alias: Rick Hawkins Time )
• RaulChristensenTime ( type: esriFieldTypeDouble, alias: Raul Christensen Time )
• RobNielsenTime ( type: esriFieldTypeDouble, alias: Rob Nielsen Time )
• ByronHaslamTime ( type: esriFieldTypeDouble, alias: Byron Haslam Time )
• JeredJohnsonTime ( type: esriFieldTypeDouble, alias: Jered Johnson Time )
• JacobQuinnTime ( type: esriFieldTypeDouble, alias: Jacob Quinn Time )
• ExtraPerson1 ( type: esriFieldTypeString, alias: Extra Person 1, length: 100 )
• ExtraPerson1Time ( type: esriFieldTypeDouble, alias: Extra Person 1 Time )
• ExtraPerson2 ( type: esriFieldTypeString, alias: Extra Person 2, length: 100 )
• ExtraPerson2Time ( type: esriFieldTypeDouble, alias: Extra Person 2 Time )
• ExtraPerson3 ( type: esriFieldTypeString, alias: Extra Person 3, length: 100 )
• ExtraPerson3Time ( type: esriFieldTypeDouble, alias: Extra Person 3 Time )
• ChrisHarmonTime ( type: esriFieldTypeDouble, alias: Chris Harmon Time )
• WyattWaldenTime ( type: esriFieldTypeDouble, alias: Wyatt Walden Time )
• ZacStaheliTime ( type: esriFieldTypeDouble, alias: Zac Staheli Time )
• MasonSpencerTime ( type: esriFieldTypeDouble, alias: Mason Spencer Time )
• JamesDarlingTime ( type: esriFieldTypeDouble, alias: James Darling Time )
• RussJacksonTime ( type: esriFieldTypeDouble, alias: Russ Jackson Time )
• BrandonJohnsonTime ( type: esriFieldTypeDouble, alias: Brandon Johnson Time )
• JakeTheurerTime ( type: esriFieldTypeDouble, alias: Jake Theurer Time )
• MattHyattTime ( type: esriFieldTypeDouble, alias: Matt Hyatt Time )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Deficiency1 ( type: esriFieldTypeString, alias: Deficiency 1, length: 500 )
• Deficiency2 ( type: esriFieldTypeString, alias: Deficiency 2, length: 500 )
• Deficiency3 ( type: esriFieldTypeString, alias: Deficiency 3, length: 500 )
• Deficiency4 ( type: esriFieldTypeString, alias: Deficiency 4, length: 500 )
• Deficiency5 ( type: esriFieldTypeString, alias: Deficiency 5, length: 500 )
• Deficiency6 ( type: esriFieldTypeString, alias: Deficiency 6, length: 500 )
• Deficiency7 ( type: esriFieldTypeString, alias: Deficiency 7, length: 500 )
• Deficiency8 ( type: esriFieldTypeString, alias: Deficiency 8, length: 500 )
• Deficiency9 ( type: esriFieldTypeString, alias: Deficiency 9, length: 500 )
• Deficiency10 ( type: esriFieldTypeString, alias: Deficiency 10, length: 500 )
• Deficiency11 ( type: esriFieldTypeString, alias: Deficiency 11, length: 500 )
• Deficiency12 ( type: esriFieldTypeString, alias: Deficiency 12, length: 500 )
• Deficiency13 ( type: esriFieldTypeString, alias: Deficiency 13, length: 500 )
• Deficiency14 ( type: esriFieldTypeString, alias: Deficiency 14, length: 500 )
• Deficiency15 ( type: esriFieldTypeString, alias: Deficiency 15, length: 500 )
• Deficiency16 ( type: esriFieldTypeString, alias: Deficiency 16, length: 500 )
• Deficiency17 ( type: esriFieldTypeString, alias: Deficiency 17, length: 500 )
• Deficiency18 ( type: esriFieldTypeString, alias: Deficiency 18, length: 500 )
• Deficiency19 ( type: esriFieldTypeString, alias: Deficiency 19, length: 500 )
• Deficiency20 ( type: esriFieldTypeString, alias: Deficiency 20, length: 500 )
• Deficiency21 ( type: esriFieldTypeString, alias: Deficiency 21, length: 500 )
• Deficiency22 ( type: esriFieldTypeString, alias: Deficiency 22, length: 500 )
• Deficiency23 ( type: esriFieldTypeString, alias: Deficiency 23, length: 500 )
• Deficiency24 ( type: esriFieldTypeString, alias: Deficiency 24, length: 500 )
• Deficiency25 ( type: esriFieldTypeString, alias: Deficiency 25, length: 500 )
• SignOff1 ( type: esriFieldTypeString, alias: Sign Off1?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• Inspector ( type: esriFieldTypeString, alias: Inspector , length: 255 )
• Contractor ( type: esriFieldTypeString, alias: Contractor , length: 255 )
• ContractorPhone ( type: esriFieldTypeString, alias: Contractor Phone , length: 255 )
• ContractorEmail ( type: esriFieldTypeString, alias: Contractor Email, length: 255 )
• ContractorEmail2 ( type: esriFieldTypeString, alias: Contractor Email 2, length: 255 )
• ContractorEmail3 ( type: esriFieldTypeString, alias: Contractor Email 3, length: 255 )
• ContractorEmail4 ( type: esriFieldTypeString, alias: Contractor Email 4, length: 255 )
• ContractorEmail5 ( type: esriFieldTypeString, alias: Contractor Email 5, length: 255 )
• FinalInspectionApproval ( type: esriFieldTypeString, alias: Final Inspection Approval?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• FinalInspectionDateApproved ( type: esriFieldTypeDate, alias: Final Inspection Date Approved, length: 8 )
• SignOff2 ( type: esriFieldTypeString, alias: Sign Off 2?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff3 ( type: esriFieldTypeString, alias: Sign Off 3?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff4 ( type: esriFieldTypeString, alias: Sign Off 4?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff5 ( type: esriFieldTypeString, alias: Sign Off 5?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff6 ( type: esriFieldTypeString, alias: Sign Off 6?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff7 ( type: esriFieldTypeString, alias: Sign Off 7?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff8 ( type: esriFieldTypeString, alias: Sign Off 8?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff9 ( type: esriFieldTypeString, alias: Sign Off 9?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff10 ( type: esriFieldTypeString, alias: Sign Off 10?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff11 ( type: esriFieldTypeString, alias: Sign Off 11?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff12 ( type: esriFieldTypeString, alias: Sign Off 12?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff13 ( type: esriFieldTypeString, alias: Sign Off 13?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff14 ( type: esriFieldTypeString, alias: Sign Off 14?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff15 ( type: esriFieldTypeString, alias: Sign Off 15?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff16 ( type: esriFieldTypeString, alias: Sign Off 16?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff17 ( type: esriFieldTypeString, alias: Sign Off 17?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff18 ( type: esriFieldTypeString, alias: Sign Off 18?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff19 ( type: esriFieldTypeString, alias: Sign Off 19?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff20 ( type: esriFieldTypeString, alias: Sign Off 20?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff21 ( type: esriFieldTypeString, alias: Sign Off 21?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff22 ( type: esriFieldTypeString, alias: Sign Off 22?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff23 ( type: esriFieldTypeString, alias: Sign Off 23?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff24 ( type: esriFieldTypeString, alias: Sign Off 24?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SignOff25 ( type: esriFieldTypeString, alias: Sign Off 25?, length: 5 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SecretaryEmail ( type: esriFieldTypeString, alias: Secretary Email, length: 100 , Coded Values: [jfinch@spanishfork.org: jfinch@spanishfork.org] , [marciec@spanishfork.org: marciec@spanishfork.org] )
• LogType ( type: esriFieldTypeString, alias: Log Type, length: 50 , Coded Values: [Development Poly: Development Poly] , [Development Line: Development Line] , [City Poly: City Poly] , ...3 more... )

Relationships:

• DBO.DevelopmentProjectLines (5) -- Related To: Development Project Lines (0)
• DBO.CityProjectPolygons (16) -- Related To: City Project Polygons (3)
• DBO.ExcavationPermits (3) -- Related To: Excavation Permits (10)
• DBO.DevelopmentProjectPolygons (14) -- Related To: Development Project Polygons (2)
• DBO.CityProjectLines (8) -- Related To: City Project Lines (1)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata