Name: Public Structures

Display Field: STRUCID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 314fe46e648242169af91de4556da414

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
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: true
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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• STRUCID ( type: esriFieldTypeString, alias: STRUCID, editable: true, nullable: false, length: 60, defaultValue: null, modelName: STRUCID )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PIN )
• EFFECTYEAR ( type: esriFieldTypeSmallInteger, alias: EFFECTYEAR, editable: true, nullable: true, defaultValue: null, modelName: EFFECTYEAR )
• DWELLING ( type: esriFieldTypeInteger, alias: DWELLING, editable: true, nullable: true, defaultValue: null, modelName: DWELLING )
• GRDSQFT ( type: esriFieldTypeInteger, alias: GRDSQFT, editable: true, nullable: true, defaultValue: null, modelName: GRDSQFT )
• LWRSQFTUN ( type: esriFieldTypeInteger, alias: LWRSQFTUN, editable: true, nullable: true, defaultValue: null, modelName: LWRSQFTUN )
• LWRSQFTFN ( type: esriFieldTypeInteger, alias: LWRSQFTFN, editable: true, nullable: true, defaultValue: null, modelName: LWRSQFTFN )
• BASSQFTUN ( type: esriFieldTypeInteger, alias: BASSQFTUN, editable: true, nullable: true, defaultValue: null, modelName: BASSQFTUN )
• BASSQFTFN ( type: esriFieldTypeInteger, alias: BASSQFTFN, editable: true, nullable: true, defaultValue: null, modelName: BASSQFTFN )
• ATCSQFTFN ( type: esriFieldTypeInteger, alias: ATCSQFTFN, editable: true, nullable: true, defaultValue: null, modelName: ATCSQFTFN )
• ATCSQFTUN ( type: esriFieldTypeInteger, alias: ATCSQFTUN, editable: true, nullable: true, defaultValue: null, modelName: ATCSQFTUN )
• UPRSQFT ( type: esriFieldTypeInteger, alias: UPRSQFT, editable: true, nullable: true, defaultValue: null, modelName: UPRSQFT )
• TOTALSQFT ( type: esriFieldTypeBigInteger, alias: TOTALSQFT, editable: true, nullable: true, defaultValue: null, modelName: TOTALSQFT )
• CAR1SQFT ( type: esriFieldTypeInteger, alias: CAR1SQFT, editable: true, nullable: true, defaultValue: null, modelName: CAR1SQFT )
• CAR2SQFT ( type: esriFieldTypeInteger, alias: CAR2SQFT, editable: true, nullable: true, defaultValue: null, modelName: CAR2SQFT )
• VALUE_ ( type: esriFieldTypeBigInteger, alias: VALUE_, editable: true, nullable: true, defaultValue: null, modelName: VALUE_ )
• BATHROOMS ( type: esriFieldTypeSingle, alias: BATHROOMS, editable: true, nullable: true, defaultValue: null, modelName: BATHROOMS )
• KITCHENS ( type: esriFieldTypeSmallInteger, alias: KITCHENS, editable: true, nullable: true, defaultValue: null, modelName: KITCHENS )
• BEDROOMS ( type: esriFieldTypeSmallInteger, alias: BEDROOMS, editable: true, nullable: true, defaultValue: null, modelName: BEDROOMS )
• YEARBUILT ( type: esriFieldTypeSmallInteger, alias: YEARBUILT, editable: true, nullable: true, defaultValue: null, modelName: YEARBUILT )
• STRUCQUAL ( type: esriFieldTypeString, alias: STRUCQUAL, editable: true, nullable: true, length: 1, defaultValue: null, modelName: STRUCQUAL )
• FLOORS ( type: esriFieldTypeString, alias: FLOORS, editable: true, nullable: true, length: 1, defaultValue: null, modelName: FLOORS )
• SUFFIX ( type: esriFieldTypeString, alias: SUFFIX, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SUFFIX )
• IMAGEPATH ( type: esriFieldTypeString, alias: IMAGEPATH, editable: true, nullable: false, length: 78, defaultValue: null, modelName: IMAGEPATH )
• HOEVAL ( type: esriFieldTypeBigInteger, alias: HOEVAL, editable: true, nullable: true, defaultValue: null, modelName: HOEVAL )

Templates:

• Name: Public Structures
  Description:
  Prototype:
  IMAGEPATH:
  STRUCID:
  PIN: null
  EFFECTYEAR: null
  DWELLING: null
  GRDSQFT: null
  LWRSQFTUN: null
  LWRSQFTFN: null
  BASSQFTUN: null
  BASSQFTFN: null
  ATCSQFTFN: null
  ATCSQFTUN: null
  UPRSQFT: null
  TOTALSQFT: null
  CAR1SQFT: null
  CAR2SQFT: null
  VALUE_: null
  BATHROOMS: null
  KITCHENS: null
  BEDROOMS: null
  YEARBUILT: null
  STRUCQUAL: null
  FLOORS: null
  SUFFIX: null
  HOEVAL: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Footprint (1) -- Related To: Footprints (0)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata