Name: Competition

Display Field: FEAT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Competition

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8793800.9139
YMin: 4244660.3826
XMax: -8736106.5076
YMax: 4304704.5062
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[215,252,179,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FEAT_NAME (type: esriFieldTypeString, alias: FEAT_NAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TENANT_GUIDFK (type: esriFieldTypeString, alias: Tenant GUID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• FEAT_DESC (type: esriFieldTypeString, alias: Feature Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ALT_NAME (type: esriFieldTypeString, alias: Alternate Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PRO_TYPE_CD (type: esriFieldTypeString, alias: Property Type (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [TS: Tenant Space], [OS: Office Space], [O: Other], ... 1 more ...)
• FEAT_STATUS_CD (type: esriFieldTypeString, alias: Feature Status (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [A: Closing/Vacant], [E: Existing], [F: Future], ... 1 more ...)
• SPACE_TYPE_CD (type: esriFieldTypeString, alias: Space Type (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [I: Inline], [E: Endcap], [O: Outparcel], ... 5 more ...)
• ACTIVE_CD (type: esriFieldTypeString, alias: Active (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• CAPT_METHOD_CD (type: esriFieldTypeString, alias: Capture Method (CD), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Geocoded: Geocoded], [GPS: GPS], [Site Visit: Site Visit], ... 5 more ...)
• UNIT_DETAILS (type: esriFieldTypeString, alias: Space / Building Details, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STORE_NUM (type: esriFieldTypeString, alias: Store #, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LICENSE_ID (type: esriFieldTypeString, alias: Tax License #, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• INTER_STREET1 (type: esriFieldTypeString, alias: Intersection Street 1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• INTER_STREET2 (type: esriFieldTypeString, alias: Intersectio Street 2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STATE_CD (type: esriFieldTypeString, alias: State (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [AL: Alabama], [AK: Alaska], [AS: American Samoa], ... 55 more ...)
• ZIP_CODE (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• OVER_BOOK_SECTION (type: esriFieldTypeString, alias: Over Book Section, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CORNER_QUAD (type: esriFieldTypeString, alias: Corner Quadrant, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: Longitude (X), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Latitude (Y), SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRO_SITE_GUIDFK (type: esriFieldTypeString, alias: Property Site GUID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• SQ_FT (type: esriFieldTypeInteger, alias: Space Square Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAX_CAPACITY (type: esriFieldTypeDouble, alias: Maximum Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CAPACITY_UM_CD (type: esriFieldTypeString, alias: Capacity Unit of Measure (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [AC: Acres], [BD: Hospital Beds], [BX: Boxes (Fire Alarms)], ... 32 more ...)
• TSCG_MANAGE_CD (type: esriFieldTypeString, alias: TSCG Managed (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• TSCG_LEASE_CD (type: esriFieldTypeString, alias: TSCG Leased (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• TSCG_DISPOSITION_CD (type: esriFieldTypeString, alias: TSCG Disposition (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
• USER_MOD (type: esriFieldTypeString, alias: User Modified, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FEAT_GUID (type: esriFieldTypeString, alias: Feature GUID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• ORIGIN_ID (type: esriFieldTypeString, alias: Original ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SRC_NAME (type: esriFieldTypeString, alias: Source Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SRC_CATALOGGUIDFK (type: esriFieldTypeString, alias: Source Catalog GUID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• FEATURE_TYPE_CD (type: esriFieldTypeSmallInteger, alias: Feature Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRAW_LEVEL (type: esriFieldTypeSmallInteger, alias: Drawing Level (CD), SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: L00 - 1:591,657,528], [1: L01 - 1:295,828,764], [2: L02 - 1:147,914,382], ... 17 more ...)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Placeholder (type: esriFieldTypeString, alias: Placeholder, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEAT_GUID_1 (type: esriFieldTypeString, alias: Feature GUID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• TENANT_NAME (type: esriFieldTypeString, alias: Tenant Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TENANT_WEBSITE (type: esriFieldTypeString, alias: Tenant Website, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• TSCG_CODE10 (type: esriFieldTypeString, alias: TSCG Code 10, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LOGO_FONT (type: esriFieldTypeString, alias: LOGO_FONT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LETTER (type: esriFieldTypeString, alias: LABEL_LETTER , SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• FONT_RGB (type: esriFieldTypeString, alias: FONT_RGB, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• HALO_RGB (type: esriFieldTypeString, alias: HALO_RGB, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• IMAGE_URL (type: esriFieldTypeString, alias: HOSTED_IMAGE_URL , SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• LOGO_LETTER (type: esriFieldTypeString, alias: LOGO_LETTER, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FONT_R (type: esriFieldTypeSmallInteger, alias: FONT_R, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FONT_G (type: esriFieldTypeSmallInteger, alias: FONT_G, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FONT_B (type: esriFieldTypeSmallInteger, alias: FONT_B, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSize1 (type: esriFieldTypeSmallInteger, alias: FSize1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSize2 (type: esriFieldTypeSmallInteger, alias: FSize2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FSize3 (type: esriFieldTypeSmallInteger, alias: FSize3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEAT_USE_CD (type: esriFieldTypeString, alias: Feature Use Code, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• HQ_CONTACT_NAME (type: esriFieldTypeString, alias: HQ Contact Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• HQ_CONTACT_PHONE (type: esriFieldTypeString, alias: HQ Contact Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• HQ_CONTACT_EMAIL (type: esriFieldTypeString, alias: HQ Contact Title, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HQ_CONTACT_TITLE (type: esriFieldTypeString, alias: HQ_CONTACT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CREATE_BY (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATE_DATE (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MOD_BY (type: esriFieldTypeString, alias: Modified By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MOD_DATE (type: esriFieldTypeDate, alias: Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ORIGIN_ID_1 (type: esriFieldTypeString, alias: Original ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SRC_NAME_1 (type: esriFieldTypeString, alias: Source Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SRC_CATALOGGUIDFK_1 (type: esriFieldTypeString, alias: Source Catalog GUID, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• User_Modified (type: esriFieldTypeString, alias: User Modified, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TSCG_CAT_7 (type: esriFieldTypeString, alias: TSCG Category 7 ID (CD), SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [2010113: 2010113-Social-Food & Drink-Restaurant - Quick Service-Italian], [2010114: 2010114-Social-Food & Drink-Restaurant - Quick Service-Latin / Spanish / Tapas], [2010115: 2010115-Social-Food & Drink-Restaurant - Quick Service-Mexican], ... 441 more ...)
• LabelScript (type: esriFieldTypeString, alias: LabelScript, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• created_user_1 (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date_1 (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user_1 (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date_1 (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID_1 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CHAINXY_ID (type: esriFieldTypeInteger, alias: ChainXY_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Competition
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• PRO_TYPE_CD: TS
• FEAT_STATUS_CD: E
• SPACE_TYPE_CD: TBR
• ACTIVE_CD: Y
• TSCG_MANAGE_CD: N
• TSCG_LEASE_CD: N
• FEATURE_TYPE_CD: 0
• FONT_RGB: 0,77,168
• FONT_R: 0
• FONT_G: 77
• FONT_B: 168
• FSize1: 7
• FSize2: 9
• SRC_NAME_1: edit
• CAPT_METHOD_CD: Placed on Map
• TSCG_DISPOSITION_CD: N
• DRAW_LEVEL: 0
• LOGO_FONT: Tahoma
• HALO_RGB: 255,255,190
• FSize3: 11
• SRC_CATALOGGUIDFK_1: 3C2E837F-C776-4957-AE44-8ED2EFE5ABFA

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/13/2019 2:25:22 PM

Schema Last Edit Date: 11/13/2019 2:25:22 PM

Data Last Edit Date: 11/13/2019 2:25:22 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat