Name: Building & Septic Inspections Review

Display Field: regardingobjectidname

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: a03d0b10aded4b6f9de0bd70333fc606

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• actualend ( type: esriFieldTypeDate, alias: Actual End, length: 8 )
• actualstart ( type: esriFieldTypeDate, alias: Actual Start, length: 8 )
• createdby ( type: esriFieldTypeString, alias: Created By, length: 200 )
• createdon ( type: esriFieldTypeDate, alias: Created On, length: 8 )
• createdonbehalfby ( type: esriFieldTypeString, alias: Created On Behalf By, length: 200 )
• modifiedby ( type: esriFieldTypeString, alias: Modified By, length: 200 )
• modifiedon ( type: esriFieldTypeDate, alias: Modified On, length: 8 )
• modifiedonbehalfby ( type: esriFieldTypeString, alias: Modified on Behalf By, length: 200 )
• additionsmeetingsetbacksnote ( type: esriFieldTypeString, alias: Additions Meeting Setbacks Note, length: 1073741822 )
• basement ( type: esriFieldTypeString, alias: Basement, length: 4000 , Coded Values: [Full: Full] , [Rough In: Rough In] , [Unfinished: Unfinished] )
• buildingheight ( type: esriFieldTypeString, alias: Building Height, length: 100 )
• buildingtypeallowed ( type: esriFieldTypeString, alias: Building Type Allowed, length: 4000 )
• date ( type: esriFieldTypeDate, alias: Date, length: 8 )
• decknote ( type: esriFieldTypeString, alias: Deck Note, length: 100 )
• disposal ( type: esriFieldTypeString, alias: Disposal, length: 100 )
• doallmeasurementsaddup ( type: esriFieldTypeString, alias: Do All Measurements Add Up, length: 4000 )
• projectcreaterunoff ( type: esriFieldTypeString, alias: Project Create Run-off Problem, length: 4000 )
• drainfieldfttowell ( type: esriFieldTypeString, alias: Drainfield Ft To Well, length: 100 )
• drainfieldtohouse ( type: esriFieldTypeString, alias: Drainfield To House, length: 100 )
• fireplacenote ( type: esriFieldTypeString, alias: Fireplace Note, length: 100 )
• firstreviewcomments ( type: esriFieldTypeString, alias: First Review Comments, length: 1073741822 )
• firstreview ( type: esriFieldTypeString, alias: First Review, length: 4000 )
• fixturenote ( type: esriFieldTypeString, alias: Fixture Note, length: 100 )
• foundation ( type: esriFieldTypeString, alias: Foundation, length: 4000 , Coded Values: [Concrete Block: Concrete Block] , [Poured Walls: Poured Walls] , [Posts: Posts] , ...3 more... )
• dfttoneighborswells ( type: esriFieldTypeString, alias: Drainfield Ft To Neighbors Wells, length: 100 )
• tankfttoneighborswells ( type: esriFieldTypeString, alias: Tank Ft To Neighbors Wells, length: 100 )
• futuredeckplanned ( type: esriFieldTypeString, alias: Future Deck Planned, length: 4000 )
• garage ( type: esriFieldTypeString, alias: Garage, length: 4000 , Coded Values: [Attached: Attached] , [Detached: Detached] , [None: None] )
• garagesize ( type: esriFieldTypeString, alias: Garage Size, length: 100 )
• houseorbuildingtype ( type: esriFieldTypeString, alias: House Or Building Type, length: 4000 )
• housesiteboring ( type: esriFieldTypeString, alias: House Site Boring, length: 4000 )
• ifsohowmuch ( type: esriFieldTypeString, alias: If So How Much, length: 100 )
• lowentryelevation ( type: esriFieldTypeString, alias: Low Entry Elevation, length: 100 )
• minlowfloorelev ( type: esriFieldTypeString, alias: Min Low Floor Elev, length: 100 )
• porchnote ( type: esriFieldTypeString, alias: Porch Note, length: 100 )
• proposedlee ( type: esriFieldTypeString, alias: Proposed LEE, length: 100 )
• proposedlfe ( type: esriFieldTypeString, alias: Proposed LFE, length: 100 )
• secondreviewcomments ( type: esriFieldTypeString, alias: Second Review Comments, length: 1073741822 )
• secondreview ( type: esriFieldTypeString, alias: Second Review, length: 4000 )
• sqfeetmainnote ( type: esriFieldTypeString, alias: Main Floor Sq Ft Note, length: 100 )
• tankfttowell ( type: esriFieldTypeString, alias: Tank Ft To Well, length: 100 )
• tanktohouse ( type: esriFieldTypeString, alias: Tank To House, length: 100 )
• valuationfeenote ( type: esriFieldTypeString, alias: Valuation Fee Note, length: 100 )
• willitmeetsetbacks ( type: esriFieldTypeString, alias: Will It Meet Setbacks, length: 4000 )
• willtherebefillbroughtin ( type: esriFieldTypeString, alias: Will There Be Fill Brought In, length: 4000 , Coded Values: [Yes: Yes] , [No: No] )
• countyfee ( type: esriFieldTypeDouble, alias: County Fee )
• erosioncontrolfee ( type: esriFieldTypeDouble, alias: Erosion Control Fee )
• featuresnotes ( type: esriFieldTypeString, alias: Features Note, length: 1073741822 )
• licensecheckfee ( type: esriFieldTypeDouble, alias: License Check Fee )
• totalpermitfee ( type: esriFieldTypeDouble, alias: Total Permit Fee )
• planreviewfee ( type: esriFieldTypeDouble, alias: Plan Review Fee )
• plumbingfixturesfee ( type: esriFieldTypeDouble, alias: Plumbing Fixtures Fee )
• septicresidentialother ( type: esriFieldTypeString, alias: Septic Residential Other, length: 4000 )
• septicfee ( type: esriFieldTypeDouble, alias: Septic Fee )
• sqfeetnotes ( type: esriFieldTypeString, alias: Sq Feet Notes, length: 1073741822 )
• statefee ( type: esriFieldTypeDouble, alias: State Fee )
• septicsystemtype ( type: esriFieldTypeString, alias: Septic System Type, length: 4000 , Coded Values: [Type I: Type I] , [Type II: Type II] , [Type III: Type III] , ...5 more... )
• tanksetbacksnotes ( type: esriFieldTypeString, alias: Tank Setbacks Notes, length: 1073741822 )
• ownerid ( type: esriFieldTypeString, alias: Owner ID, length: 160 )
• regardingobjectidname ( type: esriFieldTypeString, alias: Permit Number, length: 4000 )
• statuscode ( type: esriFieldTypeString, alias: Status Code, length: 4000 )
• subject ( type: esriFieldTypeString, alias: Subject, length: 200 )
• reviewedby ( type: esriFieldTypeString, alias: Reviewed By, length: 200 )
• valuationfee ( type: esriFieldTypeDouble, alias: Valuation Fee )
• mainfloorsqft ( type: esriFieldTypeDouble, alias: Main Floor Sq Ft )
• bonusroomunfinsqft ( type: esriFieldTypeDouble, alias: Bonus Room Unfinished Sq Ft )
• bonusroomfinsqft ( type: esriFieldTypeDouble, alias: Bonus Room Finished Sq Ft )
• sportcourtsqft ( type: esriFieldTypeDouble, alias: Sport Court Sq Ft )
• sportcourtnote ( type: esriFieldTypeString, alias: Sport Court Note, length: 255 )
• fireplacenum ( type: esriFieldTypeDouble, alias: Number of Fireplaces )
• decksqft ( type: esriFieldTypeDouble, alias: Deck Sq Ft )
• porchtype ( type: esriFieldTypeString, alias: Porch Type, length: 255 , Coded Values: [Covered Porch: Covered Porch] , [3-Season Porch: 3-Season Porch] , [MN Rooms: MN Rooms] )
• porchsqft ( type: esriFieldTypeDouble, alias: Porch Sq Ft )
• polebldgtype ( type: esriFieldTypeString, alias: Pole Bldg Type, length: 255 )
• polebldgsqft ( type: esriFieldTypeDouble, alias: Pole Bldg Sq Ft )
• pooltype ( type: esriFieldTypeString, alias: Pool Type, length: 255 , Coded Values: [Above Ground: Above Ground] , [Below Ground: Below Ground] )
• poolsqft ( type: esriFieldTypeDouble, alias: Pool Sq Ft )
• BonusRoomFinish ( type: esriFieldTypeString, alias: BonusRoomFinish, length: 255 , Coded Values: [Full: Full] , [Unfinished: Unfinished] )
• BedroomCount ( type: esriFieldTypeSmallInteger, alias: BedroomCount )
• BathroomsCount ( type: esriFieldTypeSmallInteger, alias: BathroomsCount )
• FireplaceType ( type: esriFieldTypeString, alias: FireplaceType, length: 255 , Coded Values: [Gas: Gas] , [Wood: Wood] , [Wood Stove: Wood Stove] , ...1 more... )
• Deck ( type: esriFieldTypeString, alias: Deck, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Future: Future] )
• ContractorLicenseLookup ( type: esriFieldTypeString, alias: ContractorLicenseLookup, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• FeatureNotes ( type: esriFieldTypeString, alias: FeatureNotes, length: 2000 )
• AdditionPosts ( type: esriFieldTypeDouble, alias: AdditionPosts )
• FullFinishedBasement ( type: esriFieldTypeDouble, alias: FullFinishedBasement )
• RoughInBasement ( type: esriFieldTypeDouble, alias: RoughInBasement )
• UnfinishedBasement ( type: esriFieldTypeDouble, alias: UnfinishedBasement )
• FinishedBasementExistingHome ( type: esriFieldTypeDouble, alias: FinishedBasementExistingHome )
• SecondStory ( type: esriFieldTypeDouble, alias: SecondStory )
• AttachedGarage ( type: esriFieldTypeDouble, alias: AttachedGarage )
• DetachedGarage ( type: esriFieldTypeDouble, alias: DetachedGarage )
• StructureDescription ( type: esriFieldTypeString, alias: StructureDescription, length: 500 )
• AccessoryFoundationType ( type: esriFieldTypeString, alias: AccessoryFoundationType, length: 500 , Coded Values: [Frost Protected: Frost Protected] , [Monolithic Slab: Monolithic Slab] , [Post: Post] , ...1 more... )
• AccessoryStructureType ( type: esriFieldTypeString, alias: AccessoryStructureType, length: 255 , Coded Values: [Post Frame: Post Frame] , [Stick Built: Stick Built] , [Prebuilt: Prebuilt] , ...1 more... )
• AccessoryStructureSqFt ( type: esriFieldTypeDouble, alias: AccessoryStructureSqFt )
• SetbackSepticTank ( type: esriFieldTypeString, alias: SetbackSepticTank, length: 255 )
• SetbackSoilTreatment ( type: esriFieldTypeString, alias: SetbackSoilTreatment, length: 255 )
• AccessoryStructureNotes ( type: esriFieldTypeString, alias: AccessoryStructureNotes, length: 500 )
• BuildingTypeGradingPlan ( type: esriFieldTypeString, alias: BuildingTypeGradingPlan, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• RedboxElevation ( type: esriFieldTypeString, alias: RedboxElevation, length: 255 )
• MinimumLFE ( type: esriFieldTypeString, alias: MinimumLFE, length: 255 )
• MinimumLEE ( type: esriFieldTypeString, alias: MinimumLEE, length: 255 )
• ElevationsGradingNotes ( type: esriFieldTypeString, alias: ElevationsGradingNotes, length: 500 )
• SepticCategory ( type: esriFieldTypeString, alias: SepticCategory, length: 255 , Coded Values: [Residential: Residential] , [Other: Other] )
• SoilTreatmentType ( type: esriFieldTypeString, alias: SoilTreatmentType, length: 255 , Coded Values: [At-Grade: At-Grade] , [Holding Tank: Holding Tank] , [Mound: Mound] , ...6 more... )
• DisposalPumpBasement ( type: esriFieldTypeString, alias: DisposalPumpBasement, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• SoilVerification ( type: esriFieldTypeString, alias: SoilVerification, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• SepticNotes ( type: esriFieldTypeString, alias: SepticNotes, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• ActivityType ( type: esriFieldTypeString, alias: Activity Type, length: 255 , Coded Values: [Accessory Structure: Accessory Structure] , [Basement Finish / Remodel: Basement Finish / Remodel] , [Commercial Solar: Commercial Solar] , ...12 more... )
• AccessoryStructureFinish ( type: esriFieldTypeString, alias: AccessoryStructureFinish, length: 100 , Coded Values: [Unfinished: Unfinished] , [Finished: Finished] )
• PoolDeck ( type: esriFieldTypeString, alias: PoolDeck, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• PoolDeckSqFt ( type: esriFieldTypeDouble, alias: PoolDeckSqFt )
• PoolSetbackSepticTank ( type: esriFieldTypeString, alias: PoolSetbackSepticTank, length: 255 )
• PoolSetbackSoilTreatmentArea ( type: esriFieldTypeString, alias: PoolSetbackSoilTreatmentArea, length: 255 )
• PoolNotes ( type: esriFieldTypeString, alias: PoolNotes, length: 2000 )
• SpecifiedValuationNumber ( type: esriFieldTypeDouble, alias: SpecifiedValuationNumber )
• AllSetbacksMet ( type: esriFieldTypeString, alias: AllSetbacksMet, length: 255 , Coded Values: [Yes: Yes] , [No: No] )
• SecondPorchType ( type: esriFieldTypeString, alias: SecondPorchType, length: 255 , Coded Values: [Covered Porch: Covered Porch] , [3-Season Porch: 3-Season Porch] , [MN Rooms: MN Rooms] )
• SecondPorchSqFt ( type: esriFieldTypeDouble, alias: SecondPorchSqFt )
• RemodelSqFt ( type: esriFieldTypeDouble, alias: RemodelSqFt )
• DrainfieldSize ( type: esriFieldTypeString, alias: DrainfieldSize, length: 255 )
• RockDepth ( type: esriFieldTypeString, alias: RockDepth, length: 255 )
• Benchmark ( type: esriFieldTypeString, alias: Benchmark, length: 2000 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• DBO.NewPermit (0) -- Related To: New Permit (0)

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

  Iteminfo   Thumbnail   Metadata