Name: UnitMix

Display Field: p_buildingname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 801d5c5b7f384f08b70f40e347fde08e

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• propertyid ( modelName: propertyid, nullable: false, editable: true, defaultValue: null, alias: PropertyID, type: esriFieldTypeInteger )
• p_trueowner ( modelName: p_trueowner, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: P_TrueOwner, type: esriFieldTypeString )
• p_recordedowner ( modelName: p_recordedowner, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: P_RecordedOwner, type: esriFieldTypeString )
• p_buildingname ( modelName: p_buildingname, nullable: true, editable: true, defaultValue: null, length: 150, alias: P_BuildingName, type: esriFieldTypeString )
• p_buildingstatus ( modelName: p_buildingstatus, nullable: true, editable: true, defaultValue: null, length: 20, alias: P_BuildingStatus, type: esriFieldTypeString )
• p_buildingclass ( modelName: p_buildingclass, nullable: true, editable: true, defaultValue: null, length: 1, alias: P_BuildingClass, type: esriFieldTypeString )
• p_buildingratingdesc ( modelName: p_buildingratingdesc, nullable: true, editable: true, defaultValue: null, length: 30, alias: P_BuildingRatingDesc, type: esriFieldTypeString )
• p_landareaac ( modelName: p_landareaac, nullable: true, editable: true, defaultValue: null, alias: P_LandAreaAC, type: esriFieldTypeDouble )
• p_totalunits ( modelName: p_totalunits, nullable: true, editable: true, defaultValue: null, alias: P_TotalUnits, type: esriFieldTypeInteger )
• p_avgunitsize ( modelName: p_avgunitsize, nullable: true, editable: true, defaultValue: null, alias: P_AvgUnitSize, type: esriFieldTypeInteger )
• p_parkingspacesperunit ( modelName: p_parkingspacesperunit, nullable: true, editable: true, defaultValue: null, alias: P_ParkingSpacesPerUnit, type: esriFieldTypeInteger )
• p_yearbuilt ( modelName: p_yearbuilt, nullable: true, editable: true, defaultValue: null, alias: P_YearBuilt, type: esriFieldTypeInteger )
• p_yearrenovated ( modelName: p_yearrenovated, nullable: true, editable: true, defaultValue: null, alias: P_YearRenovated, type: esriFieldTypeInteger )
• p_numberofstories ( modelName: p_numberofstories, nullable: true, editable: true, defaultValue: null, alias: P_NumberOfStories, type: esriFieldTypeInteger )
• p_amenities ( modelName: p_amenities, nullable: true, editable: true, defaultValue: null, length: 500, alias: P_Amenities, type: esriFieldTypeString )
• p_avgmonthlyrent ( modelName: p_avgmonthlyrent, nullable: true, editable: true, defaultValue: null, alias: P_AvgMonthlyRent, type: esriFieldTypeDouble )
• p_weightedavgrentpersf ( modelName: p_weightedavgrentpersf, nullable: true, editable: true, defaultValue: null, alias: P_WeightedAvgRentPerSF, type: esriFieldTypeDouble )
• p_submarketname ( modelName: p_submarketname, nullable: true, editable: true, defaultValue: null, length: 40, alias: P_SubmarketName, type: esriFieldTypeString )
• p_zipcode ( modelName: p_zipcode, nullable: true, editable: true, defaultValue: null, length: 9, alias: P_ZipCode, type: esriFieldTypeString )
• p_city ( modelName: p_city, nullable: true, editable: true, defaultValue: null, length: 30, alias: P_City, type: esriFieldTypeString )
• p_countyname ( modelName: p_countyname, nullable: true, editable: true, defaultValue: null, length: 25, alias: P_CountyName, type: esriFieldTypeString )
• p_lastsaledate ( modelName: p_lastsaledate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: P_LastSaleDate, type: esriFieldTypeDate )
• p_lastsaleprice ( modelName: p_lastsaleprice, nullable: true, editable: true, defaultValue: null, alias: P_LastSalePrice, type: esriFieldTypeDouble )
• numbeds ( modelName: numbeds, nullable: false, editable: true, defaultValue: null, alias: NumBeds, type: esriFieldTypeInteger )
• numbaths ( modelName: numbaths, nullable: true, editable: true, defaultValue: null, alias: NumBaths, type: esriFieldTypeDouble )
• numunits ( modelName: numunits, nullable: true, editable: true, defaultValue: null, alias: NumUnits, type: esriFieldTypeInteger )
• minunitsizesqft ( modelName: minunitsizesqft, nullable: true, editable: true, defaultValue: null, alias: MinUnitSizeSqFt, type: esriFieldTypeInteger )
• maxunitsizesqft ( modelName: maxunitsizesqft, nullable: true, editable: true, defaultValue: null, alias: MaxUnitSizeSqFt, type: esriFieldTypeInteger )
• avgunitsizesqft ( modelName: avgunitsizesqft, nullable: true, editable: true, defaultValue: null, alias: AvgUnitSizeSqFt, type: esriFieldTypeInteger )
• minmonthlyrent ( modelName: minmonthlyrent, nullable: true, editable: true, defaultValue: null, alias: MinMonthlyRent, type: esriFieldTypeInteger )
• maxmonthlyrent ( modelName: maxmonthlyrent, nullable: true, editable: true, defaultValue: null, alias: MaxMonthlyRent, type: esriFieldTypeInteger )
• avgmonthlyrent ( modelName: avgmonthlyrent, nullable: true, editable: true, defaultValue: null, alias: AvgMonthlyRent, type: esriFieldTypeInteger )
• updatedate ( modelName: updatedate, nullable: false, editable: true, defaultValue: null, precision: 1, length: 29, alias: UpdateDate, type: esriFieldTypeDate )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• lv_extractdate ( modelName: lv_extractdate, nullable: true, editable: true, defaultValue: null, length: 10, alias: LV_ExtractDate, type: esriFieldTypeString )
• objectid ( modelName: objectid, nullable: false, defaultValue: null, editable: false, alias: OBJECTID, type: esriFieldTypeOID )

Templates:

• Name: UnitMix
  Description:
  Prototype:
  p_parkingspacesperunit: null
  p_numberofstories: null
  p_zipcode: null
  p_buildingstatus: null
  latitude: null
  p_buildingname: null
  p_countyname: null
  p_yearbuilt: null
  maxmonthlyrent: null
  p_city: null
  minunitsizesqft: null
  p_lastsaledate: null
  maxunitsizesqft: null
  updatedate: -2209161600000
  numbaths: null
  p_buildingratingdesc: null
  p_weightedavgrentpersf: null
  numbeds: 0
  p_avgmonthlyrent: null
  longitude: null
  p_totalunits: null
  p_landareaac: null
  p_yearrenovated: null
  lv_extractdate: null
  p_trueowner: null
  p_amenities: null
  p_lastsaleprice: null
  p_buildingclass: null
  p_avgunitsize: null
  minmonthlyrent: null
  p_submarketname: null
  p_recordedowner: null
  avgunitsizesqft: null
  avgmonthlyrent: null
  numunits: null
  propertyid: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Property (0) -- Related To: CoStarProperty (0)

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata