Name: exports_with_counties

Display Field: city_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13517769.5567
YMin: 4160772.8214
XMax: -13102658.3963
YMax: 4602041.4181
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[161,78,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• duns_number (type: esriFieldTypeString, alias: duns_number, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• company_profile (type: esriFieldTypeString, alias: company_profile, SQL Type: sqlTypeOther, length: 139, nullable: true, editable: true)
• trade_style (type: esriFieldTypeString, alias: trade_style, SQL Type: sqlTypeOther, length: 116, nullable: true, editable: true)
• ownership_code (type: esriFieldTypeInteger, alias: ownership_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ownership (type: esriFieldTypeString, alias: ownership, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• locatoin_type_code (type: esriFieldTypeInteger, alias: locatoin_type_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• location_type (type: esriFieldTypeString, alias: location_type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• street_address_1 (type: esriFieldTypeString, alias: street_address_1, SQL Type: sqlTypeOther, length: 97, nullable: true, editable: true)
• street_address_2 (type: esriFieldTypeString, alias: street_address_2, SQL Type: sqlTypeOther, length: 97, nullable: true, editable: true)
• city_code (type: esriFieldTypeInteger, alias: city_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• city_name (type: esriFieldTypeString, alias: city_name, SQL Type: sqlTypeOther, length: 46, nullable: true, editable: true)
• us_country_code (type: esriFieldTypeInteger, alias: us_country_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• state_province_name (type: esriFieldTypeString, alias: state_province_name, SQL Type: sqlTypeOther, length: 34, nullable: true, editable: true)
• state_code (type: esriFieldTypeInteger, alias: state_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• country_name (type: esriFieldTypeString, alias: country_name, SQL Type: sqlTypeOther, length: 31, nullable: true, editable: true)
• country_code (type: esriFieldTypeInteger, alias: country_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• postal_code (type: esriFieldTypeString, alias: postal_code, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• executive_contacts1 (type: esriFieldTypeString, alias: executive_contacts1, SQL Type: sqlTypeOther, length: 85, nullable: true, editable: true)
• executive_contacts2 (type: esriFieldTypeString, alias: executive_contacts2, SQL Type: sqlTypeOther, length: 71, nullable: true, editable: true)
• otc_ticker (type: esriFieldTypeString, alias: otc_ticker, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• nyse_ticker (type: esriFieldTypeString, alias: nyse_ticker, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ase_ticker (type: esriFieldTypeString, alias: ase_ticker, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• nms_ticker (type: esriFieldTypeString, alias: nms_ticker, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• nas_ticker (type: esriFieldTypeString, alias: nas_ticker, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• parent_company_duns_number (type: esriFieldTypeString, alias: parent_company_duns_number, SQL Type: sqlTypeOther, length: 139, nullable: true, editable: true)
• parent_company (type: esriFieldTypeString, alias: parent_company, SQL Type: sqlTypeOther, length: 139, nullable: true, editable: true)
• phone (type: esriFieldTypeString, alias: phone, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true)
• url1 (type: esriFieldTypeString, alias: url1, SQL Type: sqlTypeOther, length: 127, nullable: true, editable: true)
• url2 (type: esriFieldTypeString, alias: url2, SQL Type: sqlTypeOther, length: 71, nullable: true, editable: true)
• total_number_of_employees (type: esriFieldTypeInteger, alias: total_number_of_employees, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sales_volume (type: esriFieldTypeDouble, alias: sales_volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• in_business_since (type: esriFieldTypeInteger, alias: in_business_since, SQL Type: sqlTypeOther, nullable: true, editable: true)
• trading_status (type: esriFieldTypeString, alias: trading_status, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• sic (type: esriFieldTypeString, alias: sic, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• line_of_business (type: esriFieldTypeString, alias: line_of_business, SQL Type: sqlTypeOther, length: 62, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• us_shipper_unified_datamyne_cod (type: esriFieldTypeString, alias: us_shipper_unified_datamyne_code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• us_shipper_duns_number (type: esriFieldTypeString, alias: us_shipper_duns_number, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• us_shipper_company_name (type: esriFieldTypeString, alias: us_shipper_company_name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• us_shipper_state (type: esriFieldTypeString, alias: us_shipper_state, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• month (type: esriFieldTypeString, alias: month, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• hs_code (type: esriFieldTypeString, alias: hs_code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• carrier_code (type: esriFieldTypeString, alias: carrier_code, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• carrier_duns_number (type: esriFieldTypeString, alias: carrier_duns_number, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• carrier_name (type: esriFieldTypeString, alias: carrier_name, SQL Type: sqlTypeOther, length: 99, nullable: true, editable: true)
• country_of_final_destination_co (type: esriFieldTypeString, alias: country_of_final_destination_code, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• us_port_of_departure_code (type: esriFieldTypeInteger, alias: us_port_of_departure_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• place_of_receipt_code (type: esriFieldTypeInteger, alias: place_of_receipt_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• foreign_port_code (type: esriFieldTypeInteger, alias: foreign_port_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• teus_quantity (type: esriFieldTypeDouble, alias: teus_quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• metric_tons (type: esriFieldTypeDouble, alias: metric_tons, SQL Type: sqlTypeOther, nullable: true, editable: true)
• container_quantity (type: esriFieldTypeDouble, alias: container_quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• bills_quantity (type: esriFieldTypeDouble, alias: bills_quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• calculated_value (type: esriFieldTypeDouble, alias: calculated_value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FID_dbo_California_Trade_Data_E (type: esriFieldTypeInteger, alias: FID_dbo_California_Trade_Data_Exports, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FID_Counties (type: esriFieldTypeInteger, alias: FID_Counties, SQL Type: sqlTypeOther, nullable: true, editable: true)
• County_Name (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• STATE_NAME (type: esriFieldTypeString, alias: STATE_NAME, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• STATE_FIPS (type: esriFieldTypeString, alias: STATE_FIPS, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• CNTY_FIPS (type: esriFieldTypeString, alias: CNTY_FIPS, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• FIPS (type: esriFieldTypeString, alias: FIPS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• POP2010 (type: esriFieldTypeInteger, alias: POP2010, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POP10_SQMI (type: esriFieldTypeDouble, alias: POP10_SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POP2013 (type: esriFieldTypeInteger, alias: POP2013, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POP13_SQMI (type: esriFieldTypeDouble, alias: POP13_SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WHITE (type: esriFieldTypeInteger, alias: WHITE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLACK (type: esriFieldTypeInteger, alias: BLACK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AMERI_ES (type: esriFieldTypeInteger, alias: AMERI_ES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASIAN (type: esriFieldTypeInteger, alias: ASIAN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAWN_PI (type: esriFieldTypeInteger, alias: HAWN_PI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HISPANIC (type: esriFieldTypeInteger, alias: HISPANIC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OTHER (type: esriFieldTypeInteger, alias: OTHER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MULT_RACE (type: esriFieldTypeInteger, alias: MULT_RACE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MALES (type: esriFieldTypeInteger, alias: MALES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FEMALES (type: esriFieldTypeInteger, alias: FEMALES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_UNDER5 (type: esriFieldTypeInteger, alias: AGE_UNDER5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_5_9 (type: esriFieldTypeInteger, alias: AGE_5_9, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_10_14 (type: esriFieldTypeInteger, alias: AGE_10_14, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_15_19 (type: esriFieldTypeInteger, alias: AGE_15_19, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_20_24 (type: esriFieldTypeInteger, alias: AGE_20_24, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_25_34 (type: esriFieldTypeInteger, alias: AGE_25_34, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_35_44 (type: esriFieldTypeInteger, alias: AGE_35_44, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_45_54 (type: esriFieldTypeInteger, alias: AGE_45_54, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_55_64 (type: esriFieldTypeInteger, alias: AGE_55_64, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_65_74 (type: esriFieldTypeInteger, alias: AGE_65_74, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_75_84 (type: esriFieldTypeInteger, alias: AGE_75_84, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AGE_85_UP (type: esriFieldTypeInteger, alias: AGE_85_UP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MED_AGE (type: esriFieldTypeDouble, alias: MED_AGE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MED_AGE_M (type: esriFieldTypeDouble, alias: MED_AGE_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MED_AGE_F (type: esriFieldTypeDouble, alias: MED_AGE_F, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HOUSEHOLDS (type: esriFieldTypeInteger, alias: HOUSEHOLDS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVE_HH_SZ (type: esriFieldTypeDouble, alias: AVE_HH_SZ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HSEHLD_1_M (type: esriFieldTypeInteger, alias: HSEHLD_1_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HSEHLD_1_F (type: esriFieldTypeInteger, alias: HSEHLD_1_F, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MARHH_CHD (type: esriFieldTypeInteger, alias: MARHH_CHD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MARHH_NO_C (type: esriFieldTypeInteger, alias: MARHH_NO_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MHH_CHILD (type: esriFieldTypeInteger, alias: MHH_CHILD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FHH_CHILD (type: esriFieldTypeInteger, alias: FHH_CHILD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FAMILIES (type: esriFieldTypeInteger, alias: FAMILIES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVE_FAM_SZ (type: esriFieldTypeDouble, alias: AVE_FAM_SZ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HSE_UNITS (type: esriFieldTypeInteger, alias: HSE_UNITS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VACANT (type: esriFieldTypeInteger, alias: VACANT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OWNER_OCC (type: esriFieldTypeInteger, alias: OWNER_OCC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RENTER_OCC (type: esriFieldTypeInteger, alias: RENTER_OCC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NO_FARMS12 (type: esriFieldTypeDouble, alias: NO_FARMS12, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVE_SIZE12 (type: esriFieldTypeDouble, alias: AVE_SIZE12, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CROP_ACR12 (type: esriFieldTypeDouble, alias: CROP_ACR12, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVE_SALE12 (type: esriFieldTypeDouble, alias: AVE_SALE12, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SQMI (type: esriFieldTypeDouble, alias: SQMI, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: exports_with_counties
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat