Name: Unlocated_points

Display Field: Loc_name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Disp_Lon (type: esriFieldTypeDouble, alias: Disp_Lon, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Disp_Lat (type: esriFieldTypeDouble, alias: Disp_Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Street_ID (type: esriFieldTypeString, alias: Street_ID, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Match_time (type: esriFieldTypeDouble, alias: Match_time, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Comp_score (type: esriFieldTypeString, alias: Comp_score, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• User_fld (type: esriFieldTypeString, alias: User_fld, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• ARC_Street (type: esriFieldTypeString, alias: Street or Intersection, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ARC_City (type: esriFieldTypeString, alias: City or Placename, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ARC_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ARC_ZIP (type: esriFieldTypeString, alias: ZIP Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Name_of_Project (type: esriFieldTypeString, alias: Name of Project, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Sponsor (type: esriFieldTypeString, alias: Sponsor, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LaborData (type: esriFieldTypeString, alias: LaborData, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Plus_codes (type: esriFieldTypeString, alias: Plus codes, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Lat_Long (type: esriFieldTypeString, alias: Lat_Long, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Address1 (type: esriFieldTypeString, alias: Address1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Contractor_Sourced (type: esriFieldTypeString, alias: Contractor/Sourced, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Bucket (type: esriFieldTypeString, alias: Bucket, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Projected_Project_Cost (type: esriFieldTypeDouble, alias: Projected Project Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hard_Costs (type: esriFieldTypeDouble, alias: Hard Costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Estimated_Hours (type: esriFieldTypeString, alias: Estimated Hours, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Projected_Total_Hours (type: esriFieldTypeString, alias: Projected Total Hours, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Projected_Trades_Hours (type: esriFieldTypeString, alias: Projected Trades Hours, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Projected_Start_Date (type: esriFieldTypeInteger, alias: Projected Start Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Projected_Completion_Date (type: esriFieldTypeInteger, alias: Projected Completion Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Duration (type: esriFieldTypeDouble, alias: Duration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Detailed_Trade_Labor_Hrs (type: esriFieldTypeString, alias: Detailed Trade Labor Hrs, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Projected_FTE (type: esriFieldTypeString, alias: Projected FTE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PCT_Apprentices (type: esriFieldTypeString, alias: PCT Apprentices, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PCT_Women (type: esriFieldTypeString, alias: PCT Women, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PCT_Minorities (type: esriFieldTypeString, alias: PCT Minorities, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• what (type: esriFieldTypeString, alias: what, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Num_Apprentices (type: esriFieldTypeDouble, alias: Num Apprentices, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Num_Women (type: esriFieldTypeDouble, alias: Num Women, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Num_Minorities (type: esriFieldTypeDouble, alias: Num Minorities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCt_Apprentices_1 (type: esriFieldTypeDouble, alias: PCt Apprentices, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pct_Women_1 (type: esriFieldTypeDouble, alias: Pct Women, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pct_Minorities_1 (type: esriFieldTypeDouble, alias: Pct Minorities, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Carpenters (type: esriFieldTypeDouble, alias: Carpenters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Electricians (type: esriFieldTypeDouble, alias: Electricians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Construction_Laborers (type: esriFieldTypeDouble, alias: Construction Laborers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Plumber__Pipefitters (type: esriFieldTypeDouble, alias: Plumber _Pipefitters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Architectural_Sheet_Metal_Worke (type: esriFieldTypeDouble, alias: Architectural Sheet Metal Workers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Painters (type: esriFieldTypeDouble, alias: Painters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HVAC (type: esriFieldTypeDouble, alias: HVAC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roofers (type: esriFieldTypeDouble, alias: Roofers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Excavators_Operating_Engineers_ (type: esriFieldTypeDouble, alias: Excavators_Operating Engineers_Equip Operators, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Drywall_Ceiling_Installers (type: esriFieldTypeDouble, alias: Drywall_Ceiling Installers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Glaziers (type: esriFieldTypeDouble, alias: Glaziers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cement_Masons (type: esriFieldTypeDouble, alias: Cement Masons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bricklayers (type: esriFieldTypeDouble, alias: Bricklayers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ironworkers (type: esriFieldTypeDouble, alias: Ironworkers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sprinkler_Fitters (type: esriFieldTypeDouble, alias: Sprinkler Fitters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Insulators (type: esriFieldTypeDouble, alias: Insulators, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Other_Construction_Trades (type: esriFieldTypeDouble, alias: Other Construction Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Carpenters_1 (type: esriFieldTypeDouble, alias: Carpenters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Electricians_1 (type: esriFieldTypeDouble, alias: Electricians, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Construction_Laborers_1 (type: esriFieldTypeDouble, alias: Construction Laborers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Plumbers_Pipefitters (type: esriFieldTypeDouble, alias: Plumbers_Pipefitters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Architectural_Sheet_Metal_Wor_1 (type: esriFieldTypeDouble, alias: Architectural Sheet Metal Workers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Painters_1 (type: esriFieldTypeDouble, alias: Painters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HVAC_1 (type: esriFieldTypeDouble, alias: HVAC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Roofers_1 (type: esriFieldTypeDouble, alias: Roofers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Excavators_Operating_Engineers1 (type: esriFieldTypeDouble, alias: Excavators_Operating Engineers_Equip Operators, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Drywall_Ceiling_Installers_1 (type: esriFieldTypeDouble, alias: Drywall_Ceiling Installers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Glaziers_1 (type: esriFieldTypeDouble, alias: Glaziers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cement_Masons_1 (type: esriFieldTypeDouble, alias: Cement Masons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bricklayers_1 (type: esriFieldTypeDouble, alias: Bricklayers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ironworkers_1 (type: esriFieldTypeDouble, alias: Ironworkers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sprinkler_Fitters_1 (type: esriFieldTypeDouble, alias: Sprinkler Fitters, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Insulators_1 (type: esriFieldTypeDouble, alias: Insulators, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Other_Construction_Trades_1 (type: esriFieldTypeDouble, alias: Other Construction Trades, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Unlocated_points
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ARC_Street:
• ARC_City:
• ARC_State:
• ARC_ZIP:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/24/2019 8:53:59 PM

Schema Last Edit Date: 5/24/2019 8:53:59 PM

Data Last Edit Date: 5/24/2019 8:53:59 PM

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