Name: AllDataQuery
Display Field: FACILITYNAME
Type: Feature Layer
Geometry Type: esriGeometryPolygon
Description:
Service Item Id: 3a995cf04a1a41b5abd6ac83050bb53f
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Has Labels: false
Can Modify Layer: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports Datum Transformation: true
Extent:
XMin: 132282.77660000324
YMin: -1048736.8363999985
XMax: 1380639.2683999985
YMax: 652751.3007999994
Spatial Reference: 102212
(32159)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSFSSolid
Color: [189, 205, 252, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: false
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field: null
Fields:
-
myJOIN
(
type: esriFieldTypeDouble, alias: myJOIN
)
-
SPACEID
(
type: esriFieldTypeString, alias: SPACEID, length: 50
)
-
BUILDINGID
(
type: esriFieldTypeString, alias: BUILDINGID, length: 50
)
-
AGREEMENT_ID
(
type: esriFieldTypeDouble, alias: AGREEMENT_ID
)
-
LEASE_ID
(
type: esriFieldTypeDouble, alias: LEASE_ID
)
-
ADDRESS
(
type: esriFieldTypeString, alias: ADDRESS, length: 120
)
-
ASSIGNMENTKEY
(
type: esriFieldTypeString, alias: ASSIGNMENTKEY, length: 50
)
-
BUILDINGTYPEKEY
(
type: esriFieldTypeString, alias: BUILDINGTYPEKEY, length: 50
)
-
BUILDINGMANAGER
(
type: esriFieldTypeString, alias: BUILDINGMANAGER, length: 50
)
-
CAPACITY
(
type: esriFieldTypeSmallInteger, alias: CAPACITY
)
-
CONDITIONKEY
(
type: esriFieldTypeString, alias: CONDITIONKEY, length: 50
)
-
DESCRIPTION
(
type: esriFieldTypeString, alias: DESCRIPTION, length: 255
)
-
FACILITYKEY
(
type: esriFieldTypeString, alias: FACILITYKEY, length: 50
)
-
FACILITYNAME
(
type: esriFieldTypeString, alias: FACILITYNAME, length: 255
)
-
GROSSAREA
(
type: esriFieldTypeDouble, alias: GROSSAREA
)
-
FLOORCOUNT
(
type: esriFieldTypeInteger, alias: FLOORCOUNT
)
-
LONGNAME
(
type: esriFieldTypeString, alias: LONGNAME, length: 100
)
-
MAINTBY
(
type: esriFieldTypeString, alias: MAINTBY, length: 50
)
-
NETAREA
(
type: esriFieldTypeDouble, alias: NETAREA
)
-
OCCUPANCY
(
type: esriFieldTypeSmallInteger, alias: OCCUPANCY
)
-
OPERHOURSKEY
(
type: esriFieldTypeString, alias: OPERHOURSKEY, length: 50
)
-
SPACEKEY
(
type: esriFieldTypeString, alias: SPACEKEY, length: 50
)
-
OWNEDBY
(
type: esriFieldTypeString, alias: OWNEDBY, length: 50
)
-
REPLCOST
(
type: esriFieldTypeDouble, alias: REPLCOST
)
-
SHORTNAME
(
type: esriFieldTypeString, alias: SHORTNAME, length: 25
)
-
URL
(
type: esriFieldTypeString, alias: URL, length: 255
)
-
YEARBUILT
(
type: esriFieldTypeSmallInteger, alias: YEARBUILT
)
-
USABLEAREA
(
type: esriFieldTypeDouble, alias: USABLEAREA
)
-
ASSIGNABLEAREA
(
type: esriFieldTypeDouble, alias: ASSIGNABLEAREA
)
-
PERCENTUSABLE
(
type: esriFieldTypeDouble, alias: PERCENTUSABLE
)
-
PERCENTASSIGNABLE
(
type: esriFieldTypeDouble, alias: PERCENTASSIGNABLE
)
-
OCCUPANCYRATE
(
type: esriFieldTypeDouble, alias: OCCUPANCYRATE
)
-
VACANCY
(
type: esriFieldTypeSmallInteger, alias: VACANCY
)
-
VACANCYRATE
(
type: esriFieldTypeDouble, alias: VACANCYRATE
)
-
DENSITY
(
type: esriFieldTypeDouble, alias: DENSITY
)
-
UW_BLDG_CODE
(
type: esriFieldTypeString, alias: UW_BLDG_CODE, length: 10
)
-
UW_PROP_NAME
(
type: esriFieldTypeString, alias: UW_PROP_NAME, length: 50
)
-
UW_PROP_CODE
(
type: esriFieldTypeString, alias: UW_PROP_CODE, length: 10
)
-
X_LONGITUDE
(
type: esriFieldTypeDouble, alias: X_LONGITUDE
)
-
Y_LATITUDE
(
type: esriFieldTypeDouble, alias: Y_LATITUDE
)
-
IMPROVEMENT_ACQUIRED
(
type: esriFieldTypeString, alias: IMPROVEMENT_ACQUIRED, length: 10
)
-
BLDG_ADDITIONS
(
type: esriFieldTypeString, alias: BLDG_ADDITIONS, length: 100
)
-
YEARS_REMODELED
(
type: esriFieldTypeString, alias: YEARS_REMODELED, length: 100
)
-
IMPROVEMENT_USE
(
type: esriFieldTypeString, alias: IMPROVEMENT_USE, length: 255
)
-
ACTIVE_LEASE
(
type: esriFieldTypeString, alias: ACTIVE_LEASE, length: 3
)
-
ACTIVE_AGREEMENT
(
type: esriFieldTypeString, alias: ACTIVE_AGREEMENT, length: 3
)
-
IMPROVEMENT_STATUS
(
type: esriFieldTypeString, alias: IMPROVEMENT_STATUS, length: 25
)
-
STATE
(
type: esriFieldTypeString, alias: STATE, length: 2
)
-
CITY
(
type: esriFieldTypeString, alias: CITY, length: 50
)
-
YEAR_REMOVED
(
type: esriFieldTypeString, alias: YEAR_REMOVED, length: 10
)
-
ZIP_CODE
(
type: esriFieldTypeString, alias: ZIP_CODE, length: 10
)
-
UW_BLDG_NAME_ABBREV
(
type: esriFieldTypeString, alias: UW_BLDG_NAME_ABBREV, length: 25
)
-
NOTES
(
type: esriFieldTypeString, alias: NOTES, length: 100
)
-
ACCESSTYPEKEY
(
type: esriFieldTypeString, alias: ACCESSTYPEKEY, length: 50
)
-
RoomCapacity
(
type: esriFieldTypeInteger, alias: RoomCapacity
)
-
RoomDescription
(
type: esriFieldTypeString, alias: RoomDescription, length: 255
)
-
FLOORKEY
(
type: esriFieldTypeString, alias: FLOORKEY, length: 50
)
-
RoomGrossArea
(
type: esriFieldTypeDouble, alias: RoomGrossArea
)
-
ASSIGNABLE
(
type: esriFieldTypeString, alias: ASSIGNABLE, length: 10
)
-
USABLE
(
type: esriFieldTypeString, alias: USABLE, length: 10
)
-
FLOOR
(
type: esriFieldTypeString, alias: FLOOR, length: 5
)
-
BUILDINGKEY
(
type: esriFieldTypeString, alias: BUILDINGKEY, length: 50
)
-
RoomNetArea
(
type: esriFieldTypeDouble, alias: RoomNetArea
)
-
RoomNumber
(
type: esriFieldTypeString, alias: RoomNumber, length: 25
)
-
EFFECTIVE_DATE
(
type: esriFieldTypeDate, alias: EFFECTIVE_DATE, length: 8
)
-
EXPIRATION_DATE
(
type: esriFieldTypeDate, alias: EXPIRATION_DATE, length: 8
)
-
SQ_FT
(
type: esriFieldTypeDouble, alias: SQ_FT
)
-
LeaseDocumentLink
(
type: esriFieldTypeString, alias: LeaseDocumentLink, length: 100
)
-
LEGAL_DESCRIPTION
(
type: esriFieldTypeString, alias: LEGAL_DESCRIPTION, length: 255
)
-
LEASE_TERM_YEARS
(
type: esriFieldTypeDouble, alias: LEASE_TERM_YEARS
)
-
ANNUAL_REVENUE
(
type: esriFieldTypeDouble, alias: ANNUAL_REVENUE
)
-
ANNUAL_EXPENSE
(
type: esriFieldTypeDouble, alias: ANNUAL_EXPENSE
)
-
LESSOR_NAME
(
type: esriFieldTypeString, alias: LESSOR_NAME, length: 255
)
-
LESSEE_NAME
(
type: esriFieldTypeString, alias: LESSEE_NAME, length: 255
)
-
STATUS
(
type: esriFieldTypeString, alias: STATUS, length: 50
)
-
CONTACT_DEPT
(
type: esriFieldTypeString, alias: CONTACT_DEPT, length: 255
)
-
LEASE_USE
(
type: esriFieldTypeString, alias: LEASE_USE, length: 255
)
-
LEASE_TYPE
(
type: esriFieldTypeString, alias: LEASE_TYPE, length: 50
)
-
LeaseNotes
(
type: esriFieldTypeString, alias: LeaseNotes, length: 200
)
-
DOC_ACRES
(
type: esriFieldTypeDouble, alias: DOC_ACRES
)
-
DOLLARS_PER_SQ_FT
(
type: esriFieldTypeDouble, alias: DOLLARS_PER_SQ_FT
)
-
RENEWAL_NOTIFICATION
(
type: esriFieldTypeString, alias: RENEWAL_NOTIFICATION, length: 10
)
-
CONTACT_DEPT_ID
(
type: esriFieldTypeInteger, alias: CONTACT_DEPT_ID
)
-
LEASE_MONTHLY_REVENUE
(
type: esriFieldTypeDouble, alias: LEASE_MONTHLY_REVENUE
)
-
LEASE_MONTHLY_EXPENSE
(
type: esriFieldTypeDouble, alias: LEASE_MONTHLY_EXPENSE
)
-
TERMINATION_NOTIFICATION
(
type: esriFieldTypeString, alias: TERMINATION_NOTIFICATION, length: 10
)
-
LeaseCity
(
type: esriFieldTypeString, alias: LeaseCity, length: 50
)
-
ACQUISITION_ID
(
type: esriFieldTypeInteger, alias: ACQUISITION_ID
)
-
AgreementContactDeptID
(
type: esriFieldTypeInteger, alias: AgreementContactDeptID
)
-
AGREE_USE
(
type: esriFieldTypeString, alias: AGREE_USE, length: 50
)
-
RENEWAL_DATE
(
type: esriFieldTypeDate, alias: RENEWAL_DATE, length: 8
)
-
AgreemntDocumentLink
(
type: esriFieldTypeString, alias: AgreemntDocumentLink, length: 100
)
-
FROM_NAME
(
type: esriFieldTypeString, alias: FROM_NAME, length: 255
)
-
TO_NAME
(
type: esriFieldTypeString, alias: TO_NAME, length: 255
)
-
AgreementContactDerpartment
(
type: esriFieldTypeString, alias: AgreementContactDerpartment, length: 255
)
-
AgreementAnnualRevenue
(
type: esriFieldTypeDouble, alias: AgreementAnnualRevenue
)
-
AgreementAnnualExspense
(
type: esriFieldTypeDouble, alias: AgreementAnnualExspense
)
-
AgreementEffectiveDate
(
type: esriFieldTypeDate, alias: AgreementEffectiveDate, length: 8
)
-
AgreementExpirationDate
(
type: esriFieldTypeDate, alias: AgreementExpirationDate, length: 8
)
-
AgreementStatus
(
type: esriFieldTypeString, alias: AgreementStatus, length: 50
)
-
LESSEE
(
type: esriFieldTypeInteger, alias: LESSEE
)
-
LESSOR
(
type: esriFieldTypeInteger, alias: LESSOR
)
-
FROM_
(
type: esriFieldTypeInteger, alias: FROM_
)
-
TO_
(
type: esriFieldTypeInteger, alias: TO_
)
-
RoomOBJECTID
(
type: esriFieldTypeInteger, alias: RoomOBJECTID
)
-
RoomNotes
(
type: esriFieldTypeString, alias: RoomNotes, length: 255
)
-
IMPRV_OBJECTID
(
type: esriFieldTypeInteger, alias: IMPRV_OBJECTID
)
-
CROSS_OBJECTID
(
type: esriFieldTypeInteger, alias: CROSS_OBJECTID
)
-
IMPRV_SHAPE
(
type: esriFieldTypeGeometry, alias: IMPRV_SHAPE
)
-
MapOBJECTID
(
type: esriFieldTypeOID, alias: MapOBJECTID
)
-
AgreementNotes
(
type: esriFieldTypeString, alias: AgreementNotes, length: 100
)
-
Lease_ORGANIZATIONID
(
type: esriFieldTypeString, alias: Lease_ORGANIZATIONID, length: 50
)
-
Agreement_ORGANIZATIONID
(
type: esriFieldTypeString, alias: Agreement_ORGANIZATIONID, length: 50
)
-
IMPRV_SHAPE.STArea()
(
type: esriFieldTypeDouble, alias: IMPRV_SHAPE.STArea()
)
-
IMPRV_SHAPE.STLength()
(
type: esriFieldTypeDouble, alias: IMPRV_SHAPE.STLength()
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata