Name: Join_Output

Display Field: PlaceName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: 2978441.89369084
YMin: 13767421.5781878
XMax: 3253537.26147801
YMax: 13962433.5270739
Spatial Reference: 102740 (2278)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[38,147,45,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: FID

Unique ID Field:

Name : FID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FID_1 (type: esriFieldTypeInteger, alias: FID_1, SQL Type: sqlTypeOther, 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: 254, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: LongLabel, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: ShortLabel, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlaceName (type: esriFieldTypeString, alias: PlaceName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place_addr, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rank (type: esriFieldTypeDouble, alias: Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddBldg (type: esriFieldTypeString, alias: AddBldg, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: AddNum, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: AddNumFrom, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: AddNumTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: AddRange, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StPreDir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: BldgType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: BldgName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: LevelType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: LevelName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: UnitType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: UnitName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SubAddr (type: esriFieldTypeString, alias: SubAddr, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Nbrhd (type: esriFieldTypeString, alias: Nbrhd, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• MetroArea (type: esriFieldTypeString, alias: MetroArea, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• RegionAbbr (type: esriFieldTypeString, alias: RegionAbbr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Territory (type: esriFieldTypeString, alias: Territory, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PostalExt (type: esriFieldTypeString, alias: PostalExt, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, 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)
• DisplayX (type: esriFieldTypeDouble, alias: DisplayX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: DisplayY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmin (type: esriFieldTypeDouble, alias: Xmin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Xmax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Ymin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Ymax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: ExInfo, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• ADDR_ID (type: esriFieldTypeDouble, alias: ADDR_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ARC_Addres (type: esriFieldTypeString, alias: ARC_Addres, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ARC_Addr_1 (type: esriFieldTypeString, alias: ARC_Addr_1, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ARC_Addr_2 (type: esriFieldTypeString, alias: ARC_Addr_2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ARC_Neighb (type: esriFieldTypeString, alias: ARC_Neighb, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ARC_City (type: esriFieldTypeString, alias: ARC_City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ARC_Subreg (type: esriFieldTypeString, alias: ARC_Subreg, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ARC_Region (type: esriFieldTypeString, alias: ARC_Region, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ARC_Postal (type: esriFieldTypeString, alias: ARC_Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ARC_Post_1 (type: esriFieldTypeString, alias: ARC_Post_1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ARC_Countr (type: esriFieldTypeString, alias: ARC_Countr, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Property_A (type: esriFieldTypeString, alias: Property_A, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Property_N (type: esriFieldTypeString, alias: Property_N, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Star_Ratin (type: esriFieldTypeInteger, alias: Star_Ratin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Energy_Sta (type: esriFieldTypeString, alias: Energy_Sta, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• LEED_Certi (type: esriFieldTypeString, alias: LEED_Certi, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Building_S (type: esriFieldTypeString, alias: Building_S, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Number_Of (type: esriFieldTypeInteger, alias: Number_Of, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Style (type: esriFieldTypeString, alias: Style, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RBA (type: esriFieldTypeInteger, alias: RBA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Secondary (type: esriFieldTypeString, alias: Secondary, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Market_Nam (type: esriFieldTypeString, alias: Market_Nam, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Submarket (type: esriFieldTypeString, alias: Submarket, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• City_1 (type: esriFieldTypeString, alias: City_1, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• County_Nam (type: esriFieldTypeString, alias: County_Nam, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• For_Sale_P (type: esriFieldTypeInteger, alias: For_Sale_P, SQL Type: sqlTypeOther, nullable: true, editable: true)
• For_Sale_S (type: esriFieldTypeString, alias: For_Sale_S, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Year_Built (type: esriFieldTypeInteger, alias: Year_Built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Year_Renov (type: esriFieldTypeInteger, alias: Year_Renov, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_O_1 (type: esriFieldTypeInteger, alias: Number_O_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Price_Unit (type: esriFieldTypeDouble, alias: Price_Unit, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cap_Rate (type: esriFieldTypeDouble, alias: Cap_Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vacancy_pc (type: esriFieldTypeDouble, alias: Vacancy_pc, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_Unit_S (type: esriFieldTypeDouble, alias: Avg_Unit_S, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_Asking (type: esriFieldTypeInteger, alias: Avg_Asking, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_Aski_1 (type: esriFieldTypeDouble, alias: Avg_Aski_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_Effect (type: esriFieldTypeInteger, alias: Avg_Effect, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_Effe_1 (type: esriFieldTypeDouble, alias: Avg_Effe_1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Avg_Conces (type: esriFieldTypeDouble, alias: Avg_Conces, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F__Studios (type: esriFieldTypeDouble, alias: F__Studios, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F1_Bed_pct (type: esriFieldTypeDouble, alias: 1_Bed_pct, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F2_Bed_pct (type: esriFieldTypeDouble, alias: 2_Bed_pct, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F3_Bed_pct (type: esriFieldTypeDouble, alias: 3_Bed_pct, SQL Type: sqlTypeOther, nullable: true, editable: true)
• F4_Bed_pct (type: esriFieldTypeString, alias: 4_Bed_pct, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Rent_Type (type: esriFieldTypeString, alias: Rent_Type, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Affordable (type: esriFieldTypeString, alias: Affordable, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Market_Seg (type: esriFieldTypeString, alias: Market_Seg, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Parking_Sp (type: esriFieldTypeDouble, alias: Parking_Sp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_O_2 (type: esriFieldTypeInteger, alias: Number_O_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Days_On_Ma (type: esriFieldTypeInteger, alias: Days_On_Ma, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEMA_Map_D (type: esriFieldTypeDate, alias: FEMA_Map_D, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FEMA_Map_I (type: esriFieldTypeString, alias: FEMA_Map_I, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FIRM_ID (type: esriFieldTypeString, alias: FIRM_ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FIRM_Panel (type: esriFieldTypeString, alias: FIRM_Panel, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• In_SFHA (type: esriFieldTypeString, alias: In_SFHA, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Floodplain (type: esriFieldTypeString, alias: Floodplain, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• FID_2 (type: esriFieldTypeInteger, alias: FID_2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRICT_1 (type: esriFieldTypeString, alias: DISTRICT_1, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• created_us (type: esriFieldTypeString, alias: created_us, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• created_da (type: esriFieldTypeString, alias: created_da, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• last_edite (type: esriFieldTypeString, alias: last_edite, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• last_edi_1 (type: esriFieldTypeString, alias: last_edi_1, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)

Templates:

Name: Join_Output
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/1/2022 5:51:09 PM

Schema Last Edit Date: 12/1/2022 5:51:09 PM

Data Last Edit Date: 12/1/2022 5:51:09 PM

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