Name: ruthco2.DBO.GISCAMA2

Display Field: OwnerNameFormatted

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• GISKey ( type: esriFieldTypeString , alias: GISKey , length: 50 )
• PropertyID ( type: esriFieldTypeInteger , alias: PropertyID )
• YearID ( type: esriFieldTypeSmallInteger , alias: YearID )
• ParcelID ( type: esriFieldTypeString , alias: ParcelID , length: 100 )
• UserAccount ( type: esriFieldTypeString , alias: UserAccount , length: 50 )
• LandUseCode ( type: esriFieldTypeString , alias: LandUseCode , length: 103 )
• CompositeLandUseCode ( type: esriFieldTypeString , alias: CompositeLandUseCode , length: 63 )
• Neighborhood ( type: esriFieldTypeString , alias: Neighborhood , length: 113 )
• NeighborhoodModifier ( type: esriFieldTypeString , alias: NeighborhoodModifier , length: 63 )
• ImprovedStatus ( type: esriFieldTypeString , alias: ImprovedStatus , length: 63 )
• TotalArea ( type: esriFieldTypeDouble , alias: TotalArea )
• TotalAreaUOM ( type: esriFieldTypeString , alias: TotalAreaUOM , length: 63 )
• ParcelGroup ( type: esriFieldTypeString , alias: ParcelGroup , length: 63 )
• InactiveYear ( type: esriFieldTypeSmallInteger , alias: InactiveYear )
• PropertyCreationDate ( type: esriFieldTypeDate , alias: PropertyCreationDate , length: 8 )
• PropertyCreationYear ( type: esriFieldTypeSmallInteger , alias: PropertyCreationYear )
• DistrictGroup ( type: esriFieldTypeString , alias: DistrictGroup , length: 63 )
• AccountType ( type: esriFieldTypeString , alias: AccountType , length: 63 )
• MarketArea ( type: esriFieldTypeString , alias: MarketArea , length: 63 )
• AppraisalArea ( type: esriFieldTypeString , alias: AppraisalArea , length: 63 )
• TotalFrontage ( type: esriFieldTypeDouble , alias: TotalFrontage )
• GEONeighborhood ( type: esriFieldTypeString , alias: GEONeighborhood , length: 63 )
• DeedSize ( type: esriFieldTypeDouble , alias: DeedSize )
• GISSize ( type: esriFieldTypeDouble , alias: GISSize )
• StreetCondition ( type: esriFieldTypeString , alias: StreetCondition , length: 63 )
• Topography ( type: esriFieldTypeString , alias: Topography , length: 63 )
• Traffic ( type: esriFieldTypeString , alias: Traffic , length: 63 )
• HighestAndBestUse ( type: esriFieldTypeString , alias: HighestAndBestUse , length: 63 )
• AssessorMap ( type: esriFieldTypeString , alias: AssessorMap , length: 20 )
• CensusTract ( type: esriFieldTypeString , alias: CensusTract , length: 50 )
• ZCoordinate ( type: esriFieldTypeString , alias: ZCoordinate , length: 50 )
• YCoordinate ( type: esriFieldTypeString , alias: YCoordinate , length: 50 )
• XCoordinate ( type: esriFieldTypeString , alias: XCoordinate , length: 50 )
• DistrictGroupAnnexDate ( type: esriFieldTypeDate , alias: DistrictGroupAnnexDate , length: 8 )
• PreviousOwnerYear ( type: esriFieldTypeSmallInteger , alias: PreviousOwnerYear )
• PreviousOwnerPercent ( type: esriFieldTypeSingle , alias: PreviousOwnerPercent )
• MapBook ( type: esriFieldTypeString , alias: MapBook , length: 20 )
• Block ( type: esriFieldTypeString , alias: Block , length: 20 )
• Subdivision ( type: esriFieldTypeString , alias: Subdivision , length: 103 )
• Lot ( type: esriFieldTypeString , alias: Lot , length: 30 )
• Sect ( type: esriFieldTypeString , alias: Sect , length: 20 )
• Township ( type: esriFieldTypeString , alias: Township , length: 20 )
• FloodPlain ( type: esriFieldTypeString , alias: FloodPlain , length: 63 )
• Range ( type: esriFieldTypeString , alias: Range , length: 20 )
• SalePrice ( type: esriFieldTypeDouble , alias: SalePrice )
• SaleDate ( type: esriFieldTypeDate , alias: SaleDate , length: 8 )
• SaleLandUseCode ( type: esriFieldTypeString , alias: SaleLandUseCode , length: 63 )
• Grantor ( type: esriFieldTypeString , alias: Grantor , length: 100 )
• Grantee ( type: esriFieldTypeString , alias: Grantee , length: 100 )
• Baths ( type: esriFieldTypeSingle , alias: Baths )
• Beds ( type: esriFieldTypeString , alias: Beds , length: 10 )
• YearBuilt ( type: esriFieldTypeSmallInteger , alias: YearBuilt )
• BuildingTypeDescription ( type: esriFieldTypeString , alias: BuildingTypeDescription , length: 50 )
• OwnerNameFormatted ( type: esriFieldTypeString , alias: OwnerNameFormatted , length: 600 )
• StreetName ( type: esriFieldTypeString , alias: StreetName , length: 255 )
• StreetNumber ( type: esriFieldTypeString , alias: StreetNumber , length: 50 )
• AlternateStreetNumber ( type: esriFieldTypeString , alias: AlternateStreetNumber , length: 50 )
• LocationCity ( type: esriFieldTypeString , alias: LocationCity , length: 50 )
• CondoComplex ( type: esriFieldTypeString , alias: CondoComplex , length: 100 )
• Owner1 ( type: esriFieldTypeString , alias: Owner1 , length: 600 )
• Owner2 ( type: esriFieldTypeString , alias: Owner2 , length: 600 )
• Owner3 ( type: esriFieldTypeString , alias: Owner3 , length: 600 )
• Zone1 ( type: esriFieldTypeString , alias: Zone1 , length: 10 )
• TotalLandValue ( type: esriFieldTypeDouble , alias: TotalLandValue )
• TotalYardItemValue ( type: esriFieldTypeDouble , alias: TotalYardItemValue )
• TotalLandArea ( type: esriFieldTypeDouble , alias: TotalLandArea )
• TotalFinishedArea ( type: esriFieldTypeDouble , alias: TotalFinishedArea )
• TotalValue ( type: esriFieldTypeDouble , alias: TotalValue )
• TotalBuildingValue ( type: esriFieldTypeDouble , alias: TotalBuildingValue )
• LegalReference ( type: esriFieldTypeString , alias: LegalReference , length: 50 )
• FormattedLocation ( type: esriFieldTypeString , alias: FormattedLocation , length: 255 )
• Business ( type: esriFieldTypeString , alias: Business , length: 10 )
• BusinessName ( type: esriFieldTypeString , alias: BusinessName , length: 255 )
• PropertyStatus ( type: esriFieldTypeString , alias: PropertyStatus , length: 50 )
• TblEdtDesc ( type: esriFieldTypeString , alias: TblEdtDesc , length: 50 )
• LocationZip ( type: esriFieldTypeString , alias: LocationZip , length: 100 )
• TotalAssessedValue ( type: esriFieldTypeDouble , alias: TotalAssessedValue )
• NALCode ( type: esriFieldTypeString , alias: NALCode , length: 50 )
• SoldAsVacant ( type: esriFieldTypeString , alias: SoldAsVacant , length: 50 )
• ParcelID1 ( type: esriFieldTypeString , alias: ParcelID1 , length: 30 )
• ParcelID2 ( type: esriFieldTypeString , alias: ParcelID2 , length: 12 )
• ParcelID3 ( type: esriFieldTypeString , alias: ParcelID3 , length: 12 )
• ParcelID4 ( type: esriFieldTypeString , alias: ParcelID4 , length: 12 )
• ParcelID5 ( type: esriFieldTypeString , alias: ParcelID5 , length: 12 )
• ParcelID6 ( type: esriFieldTypeString , alias: ParcelID6 , length: 8 )
• ParcelID7 ( type: esriFieldTypeString , alias: ParcelID7 , length: 8 )
• MailingAddress ( type: esriFieldTypeString , alias: MailingAddress , length: 778 )
• MailingAddress2 ( type: esriFieldTypeString , alias: MailingAddress2 , length: 255 )
• MailingApartmentUnitNumber ( type: esriFieldTypeString , alias: MailingApartmentUnitNumber , length: 50 )
• MailingCity ( type: esriFieldTypeString , alias: MailingCity , length: 50 )
• MailingState ( type: esriFieldTypeString , alias: MailingState , length: 50 )
• MailingZipCode ( type: esriFieldTypeString , alias: MailingZipCode , length: 50 )
• MailingCountry ( type: esriFieldTypeString , alias: MailingCountry , length: 50 )

Supported Operations:   Query   Generate Renderer   Return Updates